Homework SoursePart of an Excel output relating Y dependent variable and 4
Part of an Excel output relating Y (dependent variable) and 4 independent variables, X1 through X4, is shown below.
Fill in all the blanks
df
SS
MS
F
Significance F
| Regression Statistics | |||||
| Multiple R ? | |||||
| R Square ? | |||||
| Adjusted R Square | ? | ||||
| Standard Error | 72.6093 | ||||
| Observations | 20 | ||||
| ANOVA | |||||
| df | SS | MS | F | Significance F | |
| Regression | ? | 422975.2376 | ? | ? | 0.0000 |
| Residual | ? | ? | ? | ||
| Total | ? | ? | |||
| Coefficients | Standard Error | t Stat | P-value | ||
| Intercept | -203.6125 | 100.2940 | 0.0605 | ||
| X1 | 0.6483 | 0.1110 | 0.0000 | ||
| X2 | 0.0190 | 0.0065 | 0.0101 | ||
| X3 | 40.4577 | 7.5940 | 0.0001 | ||
| X4 | -0.1032 | 20.7823 | 0.9961 |
Solution
REGRESSON STATISTICS
Multiple R 0.9179
R Square 0.8425
Adjusted R Square 0.8005
Standard error 72.6093
observations 20
ANOVA
Residual
X1 through X3 are significant, because their p-values are less than 0.05. X4 is not significant ( p-value is 0.9961>0.5).
| df | SS | MS | F | Significance F | |
| Regression | 4 | 422975.2376 | 105743.8094 | 20.0572 | 0.0000 |
| Residual | 15 | 79081.7624 | 5272.1175 | ||
| Total | 19 | 502057.0000 |
