e. Use the F-test to test the hypotheses in part (d) at a 0.10 level of significance. Complete the F table below using Excel. Calculate the Sum of Squares (to 1 decimal), the Mean Squares (to 1...

(NEED ANSWER FOR E, COMPLETE THE F-TABLE)

Extracted text: e. Use the F-test to test the hypotheses in part (d) at a 0.10 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). Source Degrees Sum of Мean of Variation of Freedom Squares Square F p-value Regression Error Total What is your conclusion, based on this F test? We reject v Họ.


Extracted text: Given are five observations for two variables, a and y. 1 7 12 16 19 58 55 48 15 11 Use the estimated regression equation: ŷ = 68.8515 – 2.8592a. a. Compute the mean square error using equation. SSE g? = MSE = n - 2 120.37 (to 4 decimals) b. Compute the standard error of the estimate using equation. SSE s = VMSE n- 2 10.971 (to 4 decimals) c. Compute the estimated standard deviation of bị using equation. S = 0.7644 (to 4 decimals) d. Use the t-test to test the following hypotheses (a = 0.10): Ho: B1 = 0 H.: ß1 #0 Compute the value of the t-test statistic (Enter negative values as negative numbers). 3.740 (to 3 decimals) What is the p-value? Use Table 2 from Appendix B. p-value is between 0.10 and 0o.20 v What is your conclusion? We reject v Họ.