Part of an Excel output relating Y (dependent variable) and 4 independent variab

Question

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

Explanation / Answer

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

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.