Solved

Part of an Excel Output Relating X (Independent Variable) and Y

Question 5

Essay

Part of an Excel output relating x (independent variable) and y (dependent variable) is shown below. Fill in all the blanks marked with a question mark. Summary Output\mathbf {Summary~ Output}

Regression Statistics\mathbf {Regression~ Statistics}
 Multiple R 0.1347 R Square ? Adjusted R Square ? Standard Error 3.3838 Observations ?\begin{array}{ll}\text { Multiple R } & 0.1347 \\\text { R Square } & ? \\\text { Adjusted R Square } & ? \\\text { Standard Error } & 3.3838 \\\text { Observations } & ?\end{array}ANOVAdfSSMSFSignificance F Regression ?2.750??0.6322 Residual ??11.45Total14?\begin{array}{llllll} \mathbf { ANOVA}\\& \mathbf {d f} & \mathbf {S S} & \mathbf {M S} & \mathbf {F} & \mathbf {Significance ~F} \\\text { Regression } & ? & 2.750 & ? & ? & 0.6322 \\\text { Residual } & ? & ? & 11.45 & &\\Total&14&?\end{array}CoefficientsStandard Errort StatPvalue Intercept 8.62.2197?0.0019x0.250.5101?0.6322\begin{array} { l l l l l } & \mathbf {Coefficients } & \mathbf { Standard~ Error } & \mathbf {t~ Stat } & \mathbf {P-value } \\\text { Intercept } & 8.6 & 2.2197 & ? & 0.0019 \\x & 0.25 & 0.5101 & ? & 0.6322\end{array}

Correct Answer:

verifed

Verified

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

Related Questions