Study the following Excel multiple regression output. How many predictors are in

Question

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 the model.

A B C D E F 1 Summary Output 2 Regression Statistics 3 Multiple R 0.842 4 R Square 0.710                 5 Adjusted R Square 0.630 6 Standard Error 109.430 7 Observations 15 8                   9 ANOVA 10 df SS MS F Significance F 11 Regression 3 321946.82 107315.6 8.96 0.0027 12 Residual 11 131723.20 11974.8 13 Total 14 453670 14 15 Coefficients Standard Error t Stat P-value 16 Intercept 658.0420 167.460 3.92 0.0024 17 X Variable 1 5.8201 1.792 3.19 0.0087 18 X Variable 2 -0.4806 0.322 1.29 0.2222 19 X Variable 3 -3.4199 1.443 2.41 0.0349   

Explanation / Answer

There are 3 predictor variables in the model.

There are 15 observations.

The equation of the regression line is

y = 658.0420 + 5.8201 x1 - 0.4806 x2 - 3.4199 x3

Since the F value is very small the model is a very good predictor.

Since the p value of x1 is quite less, it is a significant predictor variable.

Overall the model is very effective.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---