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

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 Coefficie
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 Coefficie

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site