Formulas Cut Wrap Text Paste Merge & Cen 109.43 178.67 162.31 90.14 106.09 88.51

Question

Formulas Cut Wrap Text Paste Merge & Cen 109.43 178.67 162.31 90.14 106.09 88.51 82.54 69.43 87.16 10104.49 1132.42 12141.21 62.59 49.59 57.21 56.31 76.11 37.48 42.28 41.12 39.06 15.27 1729.42 81.5711974.9249 6653.6649 8926.2051 11246.6025 18947.9535 43.1826344.5361 1864.5124 7008.5458 9.65 8125.2196 3558.12255376851 11255.0881 4081.93216778.0901 55.93 7834.0201 3128.16494950.3643 46.98 6812 8516 2207.12043877.7292 4820.5249 1383.0961 2582.1017 7596.8656 1712.3044 3606.6808 3421.0026 963.1982 2.3719940.2641 10478169 4570.9677 671.3281 1621.7069 106.0531922 63.89 37.19 1.38 2.7410918.1601 1071 29.71 12 1051.0564 882.6841 13 25.91 917.5081 2459.1681 26.493272.9841 3170.8161 15 16 29.13 848.5569 1444 5567 701.7201 1515.4929 885.65761675.7856 15 29.76 44.14 24.57 18.56 17.33 24.52 15.11 17 5792.7321 1948.3396 3359.4954 404.7504 1787.5984 1690 8544 1525.6836 233.1729 603.6849 344.4736 920.8836 19 784.71 21 23 24 Totals 957.7512 230.7297 886.16173851.748645971.561 84233.4184 601.2304 228.3121 26 determine the coefficient of determination, r squared 28 How did they get the answer of 0.5452? 0 And what steps on Excel do I do to determine the standard error of the estimate? 1 What steps do I do on Excel to get this answer? 2 Syx= 15.2878 PLEASE EXPLAIN WITH WHAT COLUMNS TO USE AS WELL (DET

Explanation / Answer

Sol:

perform

data-->dataanalysis>regresssion

Select Y as DVD revenue

and Xas Gross

r sq=0.5452

stddrror=15.2878

SUMMARY OUTPUT Regression Statistics Multiple R 0.738355071 R Square 0.545168211 Adjusted R Square 0.522426621 Standard Error 15.28777741 Observations 22 ANOVA df SS MS F Significance F Regression 1 5602.713 5602.713 23.9723 8.73E-05 Residual 20 4674.323 233.7161 Total 21 10277.04 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 10.05643467 6.980576 1.440631 0.165162 -4.50479 24.61766 -4.50479 24.61766 X 0.384474817 0.078526 4.896152 8.73E-05 0.220673 0.548277 0.220673 0.548277

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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