Practice Exercises Data 7

.xlsx
SUMMARY OUTPUT Regression Statistics Multiple R 0.9811699931 R Square 0.9626945555 Adjusted R Square 0.9598249059 Standard Error 6.1237092905 Observations 15 ANOVA df SS MS F Significance F Regression 1 12580.2357322 12580.235732 335.4746036 1.148905E-10 Residual 13 487.497601168 37.499815474 Total 14 13067.7333333 Coefficients Standard Error t Stat P-value Lower 95% Intercept 235.14288694 8.67750603399 27.097980229 7.995333E-13 216.39627489 X Variable 1 -16.76783479 0.91547641908 -18.31596581 1.148905E-10 -18.74560136
Upper 95% Lower 95.0% Upper 95.0% 253.88949899 216.39627489 253.88949899 -14.79006823 -18.74560136 -14.79006823
Y X 28 12.6 43 11.4 45 11.5 49 11.1 57 10.4 68 9.6 74 9.8 81 8.4 82 8.8 86 8.9 101 8.1 112 7.6 114 7.8 119 7.4 124 6.4 5 6 7 8 9 10 11 12 13 14 0 20 40 60 80 100 120 140 Y X Y
Page1of 4
Uploaded by BaronUniverse10025 on coursehero.com