a) Write down the estimated model. b) What is the sample size of this analysis? c) Compute all missing statistics. d) Compute the R-square and comment. e) Are the slope and intercept significant at 5% level? Answer with underlying hypothesis. f) State the underlying assumptions of this analysis.

Question 1: Consider the following Excel results with missing calculations. ANOVA df F MS (i) Significance F 0.000 Regression Residual Total SS 1 16340644.5 933136375523.7 934 152716168.2 Intercept Coefficients Standard Error 146.952 77.715 60.214 5.695 Stat 1.891 (iv) P-value 0.059 0.000 Lower 95% -5.564 (v) Upper 95% 299.469 71.391 a) Write down the estimated model. b) What is the sample size of this analysis? c) Compute all missing statistics. d) Compute the R-square and comment. e) Are the slope and intercept significant at 5% level? Answer with underlying hypothesis. f) State the underlying assumptions of this analysis