Exhibit 134 Below you are given a partial Excel output based
Exhibit 13-4
Below you are given a partial Excel output based on a sample of 16 observations.
ANOVA
df
SS
MS
F
Regression
4,853
2,426.5
Residual
485.3
Coefficients
Standard Error
Intercept
12.924
4.425
x1
-3.682
2.630
x2
45.216
12.560
Refer to Exhibit 13-4. Carry out the test to determine if there is a relationship among the variables at the 5% level. The null hypothesis should
be rejected
not be rejected
revised
None of these alternatives is correct.
| ANOVA | ||||
| df | SS | MS | F | |
| Regression | 4,853 | 2,426.5 | ||
| Residual | 485.3 | |||
| Coefficients | Standard Error | |||
| Intercept | 12.924 | 4.425 | ||
| x1 | -3.682 | 2.630 | ||
| x2 | 45.216 | 12.560 |
Solution
regression df =2
residual df = 13
so critical point is 3.8
and F=2426.5/485.3=5
hence reject H0

