Study the following Excel multiple regression output. How many predictors are in this model? How many observations? What is the equation of the regression line? Discuss the strength of the model in terms F. Which predictors, if any, are significant? Why or why not?

Comment on the overall effectiveness of themodel.

Transcribed Image Text:

SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.842 0.710 0.630 109.430 ANOVA MS 107315.6 11974.8 Significance F 0.0027 df Regression 3 Residual Total 321946.82 131723.20 453670.00 8.96 Coefficients 657.0530 5.7103 -0.4169 -3.4715 P-value 0.0024 0.0087 0.2222 0.0349 Standard Error t Stat 3.92 3.19 Intercept X Variable 1 X Variable 2 X Variable 3 167.460 1.792 0.322 1.443 2.41