Question: Exercises to be done before tutorial class Based on the output given below, (a) Obtain the estimated regression equation and interpret the coefficients. (b) Determine

Exercises to be done before tutorial class Based on the output given below, (a) Obtain the estimated regression equation and interpret the coefficients. (b) Determine the coefficient of determination and interpret it. (c) Determine if the overall model is significant at 5% significance level. (d) Determine whether the independent variables are significant at 5% significance level. SUMMARY OUTPUT Regression Statistics Multiple R 0.974988026 R Square 0.950601651 Adjusted R Square 0.925902476 Standard Error 4.858897261 Observations ANOVA df SS MS F Significance F Regression 1817.279 908.6394 38.48718 0.00244 Residual 94.43553 23.60888 Total 1911.714 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 21.04257402 3.29362 1.582908 0.18861 15.8664 57.95157 9.038340433 1.09859 8.22722 0.00119 5.988166 12.08851 0.254862011 0.323956 -0.78672 0.475441 -1.15431 0.644585 Exercises to be done during tutorial class Question 15.1 pg 612 Question 15.2 pg 612 Question 15.3 pg 612 Question 15.5 pg 613 Note: Use Excel to answer this question. Based on the generated output: (a) Obtain the estimated regression equation and interpret the coefficients. (b) Determine if the overall model is significant at 5% significance level. (c) Determine whether the independent variables are significant at 5% significance level
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
