Solved

Part of an Excel Output Relating Y (Dependent Variable) and 4

Question 59

Essay

Part of an Excel output relating y (dependent variable) and 4 independent variables, x1 through x4, is shown below.
 Regression Statistics  Multiple R ? R Square ? Adjusted R Square 72.6093 Standard Error 20ANOVAdfSSMFS Regression ?422975.2376??0 Residual ??? Total ?? Coefficients  Standard Error t Stat  P-value  Intercept 203.6125100.2940?0.0605x10.64830.1110?0.0000x20.01900.0065?0.0101x340.45777.5940?0.0001x40.1.3220.7823?0.9961\begin{array}{ll}\hline \text { Regression Statistics } & \\\text { Multiple R } & ? \\\text { R Square } & ? \\\text { Adjusted R Square } & 72.6093 \\\text { Standard Error } & 20 \\\hline\\\\ANOVA\\\hline& d f & S S & M & F&S \\\hline \text { Regression } & ? & 422975.2376 & ? & ?&0 \\\text { Residual } & ? & ? & ? & \\\text { Total } & ? & ? & & \\\\\\\hline & \text { Coefficients } & \text { Standard Error } & t \text { Stat } & \text { P-value } \\\hline \text { Intercept } & -203.6125 & 100.2940 & ? & 0.0605 \\\mathrm{x}_{1} & 0.6483 & 0.1110 & ? & 0.0000 \\\mathrm{x}_{2} & 0.0190 & 0.0065 & ? & 0.0101 \\\mathrm{x}_{3} & 40.4577 & 7.5940 & ? & 0.0001 \\\mathrm{x}_{4}&-0.1.32&20.7823&?&0.9961\\\hline\end{array}
a.
Fill in all the blanks marked with "?".
b.
At the 5% level of significance, which independent variables are significant and which ones are not? Explain how you arrived at your answers.

Correct Answer:

verifed

Verified

a. blured image b. x1 through x3 are signifi...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions