Year Sales Advertising expenses Marketing expenses Distribution expenses

2000 9324.6 9 129.8 139.9

2001 11870.8 20.2 206.1 124.7
2002 15118.6 9.8 105.1 169.9
2003 19406.4 17.2 53 483.9
2004 21715.4 11.5 65 495
2005 28270.2 38.9 68.5 618.4
2006 41960.1 41.9 81 850.3
2007 64647.5 139.9 203 1273.2
2008 77826.3 344.9 439.6 1624.6
2009 83059.5 451.6 767.7 1538.3
2010 78855.6 656.3 1680 1474.9
2011 94407 882 1638 1732
2012 90615 1051 1376 1594
2013 92313 1170 2063 1588
2014 92038 1676 2361 2041
2015 111281 2518 354 1188
2016 134859 2044 195 1133
2017 151252 2257 234 1069
2018 174580 3389 234 1376
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.969687
R Square 0.940293
Adjusted R 0.928352
Standard E 13093.83
Observatio 19

ANOVA
df SS MS F Significance F
Regression 3 4.05E+10 1.35E+10 78.74226 2.086E-09
Residual 15 2.57E+09 1.71E+08
Total 18 4.31E+10

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 6908.926 6840.615 1.009986 0.328517 -7671.499 21489.35 -7671.499 21489.35
Advertisin 33.56867 3.545418 9.468183 1.021E-07 26.01179 41.12555 26.01179 41.12555
Marketing -15.62548 6.203264 -2.518913 0.023607 -28.84743 -2.403537 -28.84743 -2.403537
Distributi 43.48514 9.002025 4.830595 0.00022 24.29778 62.6725 24.29778 62.6725

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation
Predicted Sales
Residuals
Standard Residuals Percentile Sales
1 11266.43 -1941.828 -0.162456 2.631579 9324.6
2 9789.199 2081.601 0.174149 7.894737 11870.8
3 12983.79 2134.813 0.178601 13.15789 15118.6
4 27700.62 -8294.217 -0.693904 18.42105 19406.4
5 27804.45 -6089.055 -0.509417 23.68421 21715.4
6 34035.61 -5765.413 -0.482341 28.94737 28270.2
7 44025.21 -2065.105 -0.172769 34.21053 41960.1
8 63798.49 849.0079 0.071029 39.47368 64647.5
9 82263.76 -4437.459 -0.371243 44.73684 77826.3
10 76966.05 6093.453 0.509785 50 78855.6
11 66825.47 12030.13 1.006455 55.26316 83059.5
12 86238.22 8168.783 0.68341 60.52632 90615
13 90004.25 610.7512 0.051096 65.78947 92038
14 83003.3 9309.696 0.77886 71.05263 92313
15 115031.4 -22993.42 -1.923657 76.31579 94407
16 137563.8 -26282.76 -2.198846 81.57895 111281
17 121745 13114.02 1.097134 86.84211 134859
18 125502.7 25749.34 2.15422 92.10526 151252
19 176852.3 -2272.333 -0.190106 97.36842 174580
 Advertising expenses Re-
sidual Plot
Marketing expenses Residual
40000
Plot
Residuals

20000
0 Distribution expenses Re-
40000
-20000 0 500 1000 1500 2000 2500 sidual
3000 3500 Plot
4000
Residuals

-40000
20000
0 Advertising expenses Line Fit
40000 expenses
-20000 Advertising
0 500 1000 1500 Plot 2500
2000
Residuals

20000
-40000
0 Marketing expenses Line Fit
200000expenses
-20000 0Marketing
500 1000 1500 Plot 2500
2000 Sales
-40000 100000 Distribution Predicted
expensesSales Line Fit
Sales

200000
0Distribution expenses Plot Predicted Sales
1000 2000 3000 4000 Normal
Sales
0 100000
Sales
Probability Plot
Advertising 200000 Sales
0 expenses
200000
Upper 95.0% 0 100000
500 1000 1500 2000 2500 Predicted Sales
Sales
150000
Marketing
0 expenses
100000

Sales
0 50000
500 1000 1500 2000 2500
Distribution
0 expenses
0 20 40 60 80
Sample Percentile
e Fit
nses Line Fit
Sales
al Probability Plot
Predicted Sales
Sales
Predicted Sales

00 2500

40 60 80 100 120
Sample Percentile
Year Sales Advertisin Marketing Distribution expenses
2000 9324.6 9 129.8 139.9
2001 11870.8 20.2 206.1 124.7
2002 15118.6 9.8 105.1 169.9 SUMMARY OUTPUT
2003 19406.4 17.2 53 483.9
2004 21715.4 11.5 65 495 Regression Statistics
2005 28270.2 38.9 68.5 618.4 Multiple R 0.763844
2006 41960.1 41.9 81 850.3 R Square 0.583458
2007 64647.5 139.9 203 1273.2 Adjusted R 0.53139
2008 77826.3 344.9 439.6 1624.6 Standard E 33486.44
2009 83059.5 451.6 767.7 1538.3 Observatio 19
2010 78855.6 656.3 1680 1474.9
2011 94407 882 1638 1732 ANOVA
2012 90615 1051 1376 1594 df SS
2013 92313 1170 2063 1588 Regression 2 2.51E+10
2014 92038 1676 2361 2041 Residual 16 1.79E+10
2015 111281 2518 354 1188 Total 18 4.31E+10
2016 134859 2044 195 1133
2017 151252 2257 234 1069 Coefficients
Standard Error
2018 174580 3389 234 1376 Intercept -318.1649 17385.08
Marketing -31.7302 15.25633
Distributi 87.17227 19.76782

RESIDUAL OUTPUT

Observation
Predicted Sales
Residuals
1 7758.656 1565.944
2 4012.623 7858.177
3 11157.56 3961.04
4 40182.8 -20776.4
5 40769.65 -19054.25
6 51415.65 -23145.45
7 71234.27 -29274.17
8 104228.3 -39580.84
9 127353.3 -49527
10 109419.7 -26360.16
11 74945.48 3910.118
12 98690.14 -4283.14
13 94973.68 -4358.679
14 72652 19661
15 102685.4 -10647.44
16 92010 19271
17 92260.63 42598.37
18 85444.12 65807.88
19 112206 62373.99
 Marketing expenses Residual
Plot
100000
Distribution expenses
50000 sidual Plot

Residuals
0 100000
Marketing expen
-50000 0 50000
500 1000 1500 Plot
2000

Residuals
-100000 0 200000 Distributio
0 500
-50000 Marketing 1000
expenses 1500
MS F Significance F -100000 100000

Sales
200000
1.26E+10 11.20575 0.000906 0Distribution expenses
1.12E+09 0 100000
500 1000 1500

Sales
Marketing
0 expenses
0 500
t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0% Distributi
-0.018301 0.985625 -37172.9 36536.57 -37172.9 36536.57
-2.079806 0.05398 -64.07217 0.611773 -64.07217 0.611773
4.409807 0.000438 45.26636 129.0782 45.26636 129.0782

PROBABILITY OUTPUT

Standard Residuals Percentile Sales

0.0496 2.631579 9324.6
0.248902 7.894737 11870.8
0.125463 13.15789 15118.6
-0.658078 18.42105 19406.4
-0.60353 23.68421 21715.4
-0.733116 28.94737 28270.2
-0.927239 34.21053 41960.1
-1.253696 39.47368 64647.5
-1.568734 44.73684 77826.3
-0.83494 50 78855.6
0.12385 55.26316 83059.5
-0.135666 60.52632 90615
-0.138058 65.78947 92038
0.622749 71.05263 92313
-0.33725 76.31579 94407
0.610396 81.57895 111281
1.349274 86.84211 134859
2.08442 92.10526 151252
1.975653 97.36842 174580
expenses Residual
Plot
tribution expenses Re-
sidual Plot
Marketing expenses Line Fit
0 1000 1500 Plot 2500
2000

200000
Distribution expenses Line Fit
0 500
Marketing 1000
expenses 1500 Plot 2500
2000 Sales
100000
200000
Normal Probability
Predicted Sales Plot
0Distribution expenses
200000 Sales
0 100000
500 1000150000
1500 2000 2500 Predicted Sales
Sales

Marketing
0 expenses
100000
Sales

0 50000
500 1000 1500 2000 2500
Distribution
0 expenses
0 20 40 60 80 100 120
Sample Percentile