Raw Data Month January February March April May June July August Septembe r October November December January February March April May Year 2008 2008 2008 2008 2008 2008 2008 2008 2008 Sales 27 24.2 25.6 28.5 30.8 31.5 34.9 32.5 30.4 AdsCost 550 425 450 625 650 675 700 650 550 Unemp 4.6 4.3 4.6 4.3 4.8 5.2 5.6 5.8 5.5 2008 2008 2008 2009 2009 2009 2009 2009 31 28.5 29 26.2 25.4 27.8 26.5 27.4 525 500 600 575 625 650 600 550 5.8 6 6.5 8 8.4 9.1 8.9 9.1 Simple Linear Regression (Sales = 0 + 1Advertising + ) S pleLinearR res ion im eg s 40 y = 0.023x + 15.261 R = 0.38866 35 S ales 30 25 20 15 10 5 0 300 400 500 600 700 800 Ad vertisin ost gC SUMMARY OUTPUT Regression Statistics 0.62342946 Multiple R 4 0.38866429 R Square 6 Adjusted R 0.34790858 Square 3 2.30781381 Standard Error 3 Observations 17 ANOVA df Residual 15 Total 16 SS 50.7911075 1 79.8900689 7 130.681176 5 Coefficients 15.2606896 6 Standard Error 4.37457260 6 Regression Intercept 1 MS 50.7911075 1 5.32600459 8 F 9.53643703 7 Significance F 0.00749705 8 t Stat 3.48849842 7 P-value 0.00330051 6 Lower 95% 5.93650886 2 Upper 95% 24.5848704 5 Lower 95.0% 5.93650886 2 Upper 95.0% 24.5848704 5 AdsCost 0.02300689 7 0.00745014 9 3.08811221 3 0.00749705 8 0.00712728 0.03888651 4 0.00712728 0.03888651 4 Multiple Linear Regression (Sales = 0 + 1Advertising + 2Unemployement + ) SUMMARY OUTPUT Regression Statistics 0.74554437 Multiple R 8 R Square Adjusted R Square 0.55583642 Standard Error 2.03616971 0.49238448 Observations 17 ANOVA df Regression 2 Residual 14 Total 16 Intercept AdsCost Unemp Coefficients 17.5059699 3 0.02655110 5 0.68786317 3 SS 72.6373572 5 58.0438192 2 130.681176 5 Standard Error 3.98167008 0.00675212 0.29965917 8 MS 36.3186786 2 4.14598708 7 F 8.75995941 6 Significance F 0.00341036 3 t Stat 4.39663999 7 3.93226176 8 2.29548508 1 P-value 0.00060873 8 0.00150326 3 Lower 95% 8.96613694 7 0.01206924 7 0.03767131 8 1.33056819 Upper 95% 26.0458029 1 0.04103296 3 0.04515815 7 Lower 95.0% 8.96613694 7 0.01206924 7 1.33056819 Upper 95.0% 26.0458029 1 0.04103296 3 0.04515815 7