Question: Study the Excel regression output that follows. How many predictors are there? What is the equation of the regression model? Using the key statistics discussed
Study the Excel regression output that follows. How many predictors are there? What is the equation of the regression model? Using the key statistics discussed in this chapter, discuss the strength of the model and its predictors.
| Summary Output | |||||||||||
| Regression Statistics | |||||||||||
| Multiple R | 0.814 | ||||||||||
| R Square | 0.663 | ||||||||||
| Adjusted R Square | 0.636 | ||||||||||
| Standard Error | 51.761 | ||||||||||
| Observations | 28 | ||||||||||
| ANOVA | |||||||||||
| df | SS | MS | F | Significance F | |||||||
| Regression | 2 | 131567.0243 | 65783.5121 | 24.55 | 0.0000013 | ||||||
| Residual | 25 | 66979.6543 | 2679.19 | ||||||||
| Total | 27 | 198546.6786 | |||||||||
| Coefficients | Standard Error | t Stat | P-value | ||||||||
| Intercept | 203.3937 | 67.5177 | 3.01 | 0.0059 | |||||||
| X1 | 1.1151 | 0.5278 | 2.11 | 0.0448 | |||||||
| X2 | 2.2115 | 0.5667 | 3.90 | 0.0006 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
