Regression

Month Spend Sales 1000 9914 Sales 4000 40487 180000 5000 54324 160000 4500 50044 140000 3000 34719 D DO V O UT A W N 120000 4000 42551 100000 9000 94871 80000 11000 118914 60000 15000 158484 400 00 10 12000 131348 20000 11 7000 78504 12 3000 36284 2000 4000 6000 8000 100 00 12000 140 00 16000 The Regression Equation (Y=mx +b)= Sales=slope times Spend(x) + Intercept (b) Month Spend Sales Sales (Y) = Intercept + Slope Spend (X) Equation Result Difference From Actual 1000 9914 9914 = 1383.471 + 10.62219546 * 1000 12005.67 2091.67 4000 40487 40487 = 1383.471 + 10.62219546 * 4000 43872.25 3385.25 5000 54324 54324 = 1383.471 + 10.62219546 * 5000 54494.45 170.45 4500 50044 50044 = 1383.471 + 10.62219546 * 4500 49183.35 -860.65 3000 34719 34719 = 1383.471 + 10.62219546 * 3000 33250.06 -1468.94 6 DO V O UT A W N 4000 42551 42551 = 1383.471 + 10.62219546 4000 43872.25 1321.25 9000 94871 94871 = 1383.471 + 10.62219546 * 9000 96983.23 2112.23 11000 118914 118914 = 1383.471 + 10.62219546 11000 118227.62 -686.38 15000 158484 158484 = 1383.471 + 10.62219546 * 15000 160716.40 2232.40 10 12000 131348 131348 = 1383.471 + 10.62219546 * 12000 128849.82 -2498.18 11 7000 78504 78504 = 1383.471 + 10.62219546 * 7000 75738.84 -2765.16 12 3000 36284 36284 = 1383.471 + 10.62219546 * 3000 33250.06 -3033.94 AVERAGE 6541.667 70870.33 Difference SUM 0.00 RegressionDataPlot Regression Output ANOVAdataOutput ChiSquare ClusterAnalysis Equation +SUMMARY OUTPUT W N Regression Statistics Multiple R 0.998832 5 R Square 0.997666 6 Adjusted R Square 0.997432 Standard Error 2313.361 8 Observations 12 10 ANOVA 11 af SS MS F Significance F 12 Regression 1 2.29E+10 2.29E+10 4274.232 1.7067E-14 Scientific Notation: Move the decimal point 14 spaces to the left resulting .0000 13 Zeros 13 Residual 10 53516375 5351637 Total 11 2.29E+10 15 16 Coefficientsandard Erro t Stat P-value Lower 95% Upper 95% ower 95.0upper 95.0% 17 Intercept 1383.471 1255.24 1.102156 0.296212 1413.378591 4180.321 -1413.38 4180.321 18 Spend 10.6222 0.162475 65.37761 1.718-14 10.2601797 10.98421 10.26018 10.98421 19 20 21 22 23 24 25 26 27 28 29 30 31 RegressionDataPlot Regression Output ANOVAdataOutput ChiSquare ClusterAnalysis Equation +