D. Use the formulas in this chapter and Appendix D 4-12 Using computer software,

Question

D. Use the formulas in this chapter and Appendix D 4-12 Using computer software, find the least-squares re- gression line for the data in Problem 4-10. Based on the F test, is there a statistically significant relation ship between the demand for guitars and the number of YouTube views? 4-13 students in a management science class have just re their the first test. The instructor has provided information about the first test grades in some previous classes as well as the final average Note: Q the problem may be solved with Windows 2x means the p solved means the problem may be solved with QM for Windo with Excel QM: and

Explanation / Answer

From Excel

a) The Regression equation is

y=a+bx

from Excel

y=13.38 +0.80*(x)

b) Now x=83

then the final grade is

y=13.38+0.80*(83) =79.78

c)

Correlation coefficient r=0.9440

Coefficient of determination R2 =0.891

SUMMARY OUTPUT Regression Statistics Multiple R 0.943974 R Square 0.891087 Adjusted R Square 0.872934 Standard Error 4.234633 Observations 8 ANOVA df SS MS F Significance F Regression 1 880.2823 880.2823 49.0897 0.000421 Residual 6 107.5927 17.93212 Total 7 987.875 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 13.38128 9.537303 1.403047 0.210176 -9.95565 36.71822 -9.95565 36.71822 first 0.798714 0.113998 7.006404 0.000421 0.519771 1.077656 0.519771 1.077656

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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