Given are five observations for two variables, a: and y. Use the estimated regression equation: = 67.9731 2.471323. a. Compute the mean square error using equation. SSE n2 s2 = MSE = (to 4 decimals) b. Compute the standard error of the estimate using equation. 3: MSE: SSE Vim2 (to 4 decimals) c. Compute the estimated standard deviation of 131 using equation. .9 31,1 = V Z (3%: if (to 4 decimals) d. Use the t-test to test the following hypotheses (a = 0.10): H0: 51 = 0 Ha: 51 35 0 Compute the value of the ttest statistic (Enter negative values as negative numbers). (to 3 decimals) an q-Iinp . ...-. 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 i J Select your answer I between 0.01 and 0.02 between 0.02 and 0.05 between 0.05 and 0.10 between 0.10 and 0.20 between 0.20 and 0.40 greater than 0.40 lower than 0.01 heses in part (d) at a 0.10 level of significance. 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 Mean of Variation of Freedom Squares Square F p-value Regression Error Total What is your conclusion, based on this F test? We - Select your answer - v Ho