6) Consider the following partially completed Excel computer printout for a regr

Question

6) Consider the following partially completed Excel computer printout for a regression analysis w response variable is the price of a personal computer and the explanatory variable is the size of SUMMARY OUTPUT Statistics Multiple R R Square Adjusted R Square 0.661687702 Standard Error Observations 36 ANOVA df MS Significance F Regression Residual 1 33116034 84 33116034.84 162112147 35 49327249.56 Coefficients Standard Eror Stat 50.84102383 246.9869514 0.205844979 0.838139607 P-value Intercept Hard Drive Capacity 217.7539792 26.12854674 9.95844E-10 Based on the information provided, what is the estimate sa of the standard deviation of the linear model y= 0 + 1 x + ? A) 476,800 C) About 4,026 8) Just under 376.23 D) Approximately 690.50

Explanation / Answer

Here dF (Residual) = dF(total) - dF(regression) = 35 - 1 = 34

MSE = SSE/dF (error) = 16211214.72/34 = 476800. 433

Standard error = se = sqrt(476800.433) = 690.5074

Option D is correct.

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

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