Given are five observations for two variables, and y. Excel File: data14-25.xlsx The estimated regression equation...

Transcribed Image Text:

Given are five observations for two variables, and y. Excel File: data14-25.xlsx The estimated regression equation is = 7.6+0.92. 2 6 9 13 20 Vi 7 18 9 26 23 a. What is the value of the standard error of the estimate (to 4 decimals)? 6.5141 b. Test for a significant relationship by using the t test. Use a = 0.05. What is the value of the t test statistic (to 2 decimals)? 1.90 What is the p-value? Use Table 2 of Appendix B. between 0.10 and 0.20 What is your conclusion (a = 0.05)? Cannot conclude a significant relationship exists between x and y v c. Use the F test to test for a significant relationship. Use a=0.05. Compute the value of the F test statistic (to 2 decimals). What is the p-value? Use Table 4 of Appendix B. greater than 0.10 What is your conclusion? Cannot conclude a significant relationship exists between x and y Given are five observations for two variables, and y. Excel File: data14-25.xlsx The estimated regression equation is = 7.6+0.92. 2 6 9 13 20 Vi 7 18 9 26 23 a. What is the value of the standard error of the estimate (to 4 decimals)? 6.5141 b. Test for a significant relationship by using the t test. Use a = 0.05. What is the value of the t test statistic (to 2 decimals)? 1.90 What is the p-value? Use Table 2 of Appendix B. between 0.10 and 0.20 What is your conclusion (a = 0.05)? Cannot conclude a significant relationship exists between x and y v c. Use the F test to test for a significant relationship. Use a=0.05. Compute the value of the F test statistic (to 2 decimals). What is the p-value? Use Table 4 of Appendix B. greater than 0.10 What is your conclusion? Cannot conclude a significant relationship exists between x and y