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 321946.82 131723.20 453670.00 MS 107315.6 11974.8 Significance F 0.0027 8.96 Regression Residual Total P-value 0.0024 0.0087 0.2222 0.0349 Coefficients Standard Error t Stat 3.92 3.19 657.053 Intercept x Variable1 x Variable 2 x Variable 3 167.46 1.792 0.322 1.443 5.7103 -0.4169 -3.4715 -2.41