Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Exhibit 13-4 Below you are given a partial Excel output based on a sample of 16

ID: 3392962 • Letter: E

Question

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

Explanation / Answer

regression df =2

residual df = 13

so critical point is 3.8

and F=2426.5/485.3=5

hence reject H0

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote