Use the following Excel regression output to answer the next 5 questions. The ou

Question

Use the following Excel regression output to answer the next 5 questions. The output shows the result of running a regression relating costs to production volume. Fill in the highlighted cells first. y J COST: cost of production x OUTPUT: production volume SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Signif F SS MS Regressio 160.072 2.25E-04 Residual 184775.04 7579083.33 Total Coefficients Std Error t Stat value Lower 95% Upper 95% Intercept 617.662 428.31 1.442 0.2227 571.51 1806.84. OUTPUT 8.755 0.0002

Explanation / Answer

16) =SSR/SST=0.9756 option A

17)predicted cost=617.662+8.755*1000= 9372.662 option D

18)option B is correct

19)option C is correct

20) option A is correct

ANOVA df SS MS F regression 1 7394308.29 7394308.3 160.0716 residual 4 184775.04 46193.76 Total 5 7579083.33

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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