help

Given are five observations for two variables, x and y. 25 5 8 11 18 20 yi 56 55 46 12 10 Use the estimated regression equation: y = 79.1550 3.49642. a. Compute the mean square error using equation. $2 = MSE SSE n-2 (to 4 decimals) b. Compute the standard error of the estimate using equation. SSE MSE 2 S = n- (to 4 decimals) c. Compute the estimated standard deviation of b using equation. 8 Sbi (xi - 7) (to 4 decimals) d. Use the t-test to test the following hypotheses (a 0.05): H: Bi = 0 H: B170 Compute the value of the t-test statistic (Enter negative values as negative numbers). (to 3 decimals) What is the p-value? Use Table 2 from Appendix B. p-value is - Select your answer - What is your conclusion? We - Select your answer - H. e. Use the F-test to test the hypotheses in part (d) at a 0.05 level of significance. Complete the F table below using Excel. Calculate the Sum of Squares (to 1 decimal), the Mean Squares (to 1 decimal), and the F ratio (to 2 decimals) and the p-value (to 4 decimals). Mean Source of Variation Degrees of Freedom Sum of Squares Square F p-value Regression Error Total What is your conclusion, based on this F test? We - Select your answer - H. Given are five observations for two variables, x and y. 25 5 8 11 18 20 yi 56 55 46 12 10 Use the estimated regression equation: y = 79.1550 3.49642. a. Compute the mean square error using equation. $2 = MSE SSE n-2 (to 4 decimals) b. Compute the standard error of the estimate using equation. SSE MSE 2 S = n- (to 4 decimals) c. Compute the estimated standard deviation of b using equation. 8 Sbi (xi - 7) (to 4 decimals) d. Use the t-test to test the following hypotheses (a 0.05): H: Bi = 0 H: B170 Compute the value of the t-test statistic (Enter negative values as negative numbers). (to 3 decimals) What is the p-value? Use Table 2 from Appendix B. p-value is - Select your answer - What is your conclusion? We - Select your answer - H. e. Use the F-test to test the hypotheses in part (d) at a 0.05 level of significance. Complete the F table below using Excel. Calculate the Sum of Squares (to 1 decimal), the Mean Squares (to 1 decimal), and the F ratio (to 2 decimals) and the p-value (to 4 decimals). Mean Source of Variation Degrees of Freedom Sum of Squares Square F p-value Regression Error Total What is your conclusion, based on this F test? We - Select your answer - H