Lecture Data for Week 08 (1)

Week Sales (Y) ($1000s) Advertising (X) ($100s) Region 1 10 9 Sydney 2 6 7 Sydney 3 5 5 Sydney 4 16 14 Melbourne 5 13 15 Melbourne 6 17 12 Melbourne 7 5 6 Sydney 8 12 10 Sydney 9 19 15 Melbourne 10 23 21 Melbourne

SUMMARY OUTPUT Regression Statistics Multiple R 0.985018059218 R Square 0.9702605769857 Adjusted R Square 0.9623300641819 Standard Error 19720.131703245 Observations 20 ANOVA df SS MS F Significance F Regression 4 1.90312E+11 47578060840 122.3452507 2.936734E-11 Residual 15 5833253916 388883594.39 Total 19 1.96145E+11 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 600807.75 12855.953 46.733816611 1.15317E-17 573405.9348 628209.5652 Time (X1) 15407.2375 779.5066493 19.765370205 3.74331E-12 13745.75841 17068.71659 dec (X2) 42981.3125 12689.4489 3.3871693601 0.004063362 15934.39242 70028.23258 mar (X3) -1570.925 12569.16705 -0.124982427 0.902197088 -28361.47039 25219.62039 jun (X4) -93360.9625 12496.44223 -7.47100341 1.97884E-06 -119996.4986 -66725.4264 RESIDUAL OUTPUT Observation Predicted Takings Residuals 1 659196.3 9335.7 2 630051.3 -8652.3 3 553668.5 180.5 4 662436.7 2075.3 5 720825.25 38777.75 6 691680.25 183.75 7 615297.45 12467.55 8 724065.65 -3202.65 9 782454.2 -32553.2 10 753309.2 -3944.2 11 676926.4 -2020.4 12 785694.6 -8502.6 13 844083.15 -34485.15 14 814938.15 -13587.15 15 738555.35 -6228.35

16 847323.55 -8094.55 17 905712.1 18924.9 18 876567.1 25999.9 19 800184.3 -4399.3 20 908952.5 17724.5