Below you are given a partial Excel output based on a sample

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

x₁

-3.682

2.630

x₂

45.216

12.560

Refer to Exhibit 13-4. The test statistic used to determine if there is a relationship among the variables equals

-1.4

0.2

0.77

5

Solution

test statis tic = F = MS(reg)/MS(res) = 2426.5/485.3 = 5