Prob 13.5 - 3.5 4 4.5 5 5.5 86 88 90 92 94 96 98 f(x) =...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
41a513d4945424d61eba75f6da8f4c2e4713b5ba.xls data 96 5 1.5 90 2 2 95 4 1.5 92 2.5 2.5 95 3 3.3 94 3.5 2.3 94 2.5 4.2 94 3 2.5 Weekly Gross Revenue ($K), y Television Advertising ($K), x1 Newspaper Advertising ($K), x2 A B C 1 2 3 4 5 6 7 8 9
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
41a513d4945424d61eba75f6da8f4c2e4713b5ba.xls input data y x1 x2 96 5 1.5 90 2 2 95 4 1.5 92 2.5 2.5 95 3 3.3 94 3.5 2.3 94 2.5 4.2 94 3 2.5 A B C 1 2 3 4 5 6 7 8 9
Background image of page 2
41a513d4945424d61eba75f6da8f4c2e4713b5ba.xls multiple regression report SUMMARY OUTPUT Regression Statistics Multiple R 0.96 R Square 0.92 Adjusted R Square 0.89 Standard Error 0.64 Observations 8 ANOVA df SS MS F Significance F Regression 2 23.44 11.72 28.38 0 Residual 5 2.06 0.41 Total 7 25.5 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 83.23 1.57 52.88 0 79.18 87.28 X Variable 1 2.29 0.3 7.53 0 1.51 3.07 X Variable 2 1.3 0.32 4.06 0.01 0.48 2.13 A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
41a513d4945424d61eba75f6da8f4c2e4713b5ba.xls graphs y x1 x2 96 5 1.5 90 2 2 95 4 1.5 92 2.5 2.5 95 3 3.3 94 3.5 2.3 94 2.5 4.2 94 3 2.5 1.5 2 2.5 3
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3.5 4 4.5 5 5.5 86 88 90 92 94 96 98 f(x) = 1.6x + 88.64 R = 0.65 x1 y 1 1.5 2 2.5 3 3.5 86 88 90 92 94 96 98 f(x) = -0.04x + 93.86 R = 0 x2 41a513d4945424d61eba75f6da8f4c2e4713b5ba.xls graphs 4 4.5 41a513d4945424d61eba75f6da8f4c2e4713b5ba.xls SLR on x1 SUMMARY OUTPUT Regression Statistics Multiple R 0.81 R Square 0.65 Adjusted R Square 0.59 Standard Error 1.22 Observations 8 ANOVA df SS MS F Significance F Regression 1 16.64 16.64 11.27 0.02 Residual 6 8.86 1.48 Total 7 25.5 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 88.64 1.58 56.02 84.77 92.51 x1 1.6 0.48 3.36 0.02 0.43 2.77 A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18...
View Full Document

Page1 / 6

Prob 13.5 - 3.5 4 4.5 5 5.5 86 88 90 92 94 96 98 f(x) =...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online