Week Pie Sales Price ($) Advertising ($100s)
1 350 5.5 3.3
2 460 7.5 3.3
3 350 8 3
4 430 8 4.5
5 350 6.8 3
6 380 7.5 4
7 430 4.5 3
8 470 6.4 3.7
9 450 7 3.5
10 490 5 4
11 340 7.2 3.5
12 300 7.9 3.2
13 440 5.9 4
14 450 5 3.5
15 300 7 2.7
Holiday
0
1
1
0
0
0
0 SUMMARY OUTPUT
0
1 Regression Statistics
1 Multiple R 0.72213429224
0 R Square 0.52147793603
0 Adjusted R Square 0.4417242587
0 Standard Error 47.4634126348
0 Observations 15
0
ANOVA
df SS
Regression 2 29460.0268661
Residual 12 27033.3064673
Total 14 56493.3333333
Coefficients Standard Error
Intercept 306.526193284 114.25389351
X Variable 1 -24.975089518 10.8321251194
X Variable 2 74.1309574887 25.9673179179
RESIDUAL OUTPUT
Observation Predicted Y Residuals
1 413.795360649 -63.7953606485
2 363.845181613 96.1548183871
3 329.118349607 20.8816503926
4 440.31478584 -10.3147858405
5 359.088457029 -9.08845702874
6 415.736851855 -35.736851855
7 416.53116292 13.4688370803
8 420.970163078 49.029836922
9 391.15891787 58.8410821305
10 478.17457565 11.8254243504
11 386.163899966 -46.163899966
12 346.442050057 -46.4420500569
13 455.696995084 -15.6969950835
14 441.109096905 8.8909030948
15 331.854151879 -31.8541518786
Predicted Sales Price Advertisement
750.959069139 8 3.3
MS F Significance F
14730.0134330389 6.538606789 0.0120063722332
2252.77553893795
t Stat P-value Lower 95% Upper 95%
2.6828511822715 0.019931591 57.588344263652 555.464042304
-2.30565002181063 0.0397884612 -48.57626270056 -1.3739163351
2.85477913903187 0.0144936268 17.553032057088 130.70888292
X Variable 1 Residual Plot
150
100
Residuals 50
0
4 4.5 5 5.5 6 6.5 7 7.5 8 8.5
-50
-100
X Variable 1
X Variable 2 Line Fit Plot
600
500
400
Y
300
Y
200 Predicted Y
100
0
2.6 2.8 3 3.2 3.4 3.6 3.8 4 4.2 4.4 4.6
X Variable 2
Lower 95.0% Upper 95.0% X Variable 1 Line Fit Plo
57.588344264 555.464042304
600
-48.5762627 -1.3739163351
500
17.553032057 130.70888292 400
300
Y
200
100
0
4 4.5 5 5.5 6 6.5 7 7.5 8
X Variable 1
X Variable 2 Residual P
120
80
esiduals
40
0
X Variable 2 Residual P
120
80
Residuals
40
0
2.6 2.8 3 3.2 3.4 3.6 3.8
-40
-80
X Variable 2
dual Plot
5 7 7.5 8 8.5
Fit Plot
Y
Predicted Y
4 4.2 4.4 4.6
iable 1 Line Fit Plot
Y
Predicted Y
.5 6 6.5 7 7.5 8 8.5
X Variable 1
riable 2 Residual Plot
riable 2 Residual Plot
3.2 3.4 3.6 3.8 4 4.2 4.4 4.6
X Variable 2
Week Pie Sales Price ($)
1 350 5.5
2 460 7.5
3 350 8
4 430 8
5 350 6.8
6 380 7.5
7 430 4.5
8 470 6.4
9 450 7
10 490 5
11 340 7.2
12 300 7.9
13 440 5.9
14 450 5
15 300 7
Advertising ($100s) Holiday
3.3 0
3.3 1
3 1
4.5 0
3 0
4 0
3 0 SUMMARY OUTPUT
3.7 0
3.5 1 Regression Statistics
4 1 Multiple R
3.5 0 R Square
3.2 0 Adjusted R S
4 0 Standard Erro
3.5 0 Observations
2.7 0
ANOVA
Regression
Residual
Total
Intercept
X Variable 1
X Variable 2
X Variable 3
RESIDUAL OUTPUT
Observation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Predicted Sales Price Advertisement
850.953609593 8 3.3
MARY OUTPUT
egression Statistics
0.8594785
0.7387033
0.66744056
36.6327246
15
df SS MS F Significance F
3 41731.8117 13910.6038968237 10.3659126 0.0015503969643
11 14761.5216 1341.95651298748
14 56493.3333
CoefficientsStandard Error t Stat P-value Lower 95%
303.782759 88.1869355 3.44475922237327 0.00547847 109.6846230036
-28.5690426 8.44439098 -3.38319751175193 0.00610792 -47.15502179222
76.7393229 20.0603815 3.82541692271588 0.00281663 32.586720883448
65.3787443 21.6198129 3.02401989885517 0.0115723 17.79385703054
DUAL OUTPUT
Predicted Y Residuals
399.892791 -49.8927908
408.13345 51.86655
370.827132 -20.8271318
420.557372 9.44262816
339.731239 10.2687614
396.472232 -16.4722317
405.440036 24.5599635
404.876382 65.1236184
437.765836 12.2341642
533.273582 -43.2735824
366.673283 -26.673283
323.653156 -23.6531564
442.1827 -2.18269977
429.525177 20.4748234
310.995633 -10.9956332
Holiday
1
X Variable 1 Residu
80
60 X Variable 2
40
Residuals
80
20
0
60 XV
40
Residuals
-20 4 4.5 5 5.580 6 6.5
20
-40 60
0
Residuals
-60 -202.6 2.8 40 3 3.2 3
20
-40 X Variable 1
0
-60
-20 0 0.2
-40
-60
Upper 95% Lower 95.0% Upper 95.0%
497.880896 109.684623 497.880896
-9.98306332 -47.1550218 -9.98306332
120.891925 32.5867209 120.891925
112.963632 17.793857 112.963632
iable 1 Residual Plot
X Variable 2 Residual Plot
X Variable 3 Residual Plot
5.580 6 6.5 7 7.5 8 8.5
60 X Variable 1 Line Fit Plot
Residuals
2.8 40 3 3.2 3.4 3.6 3.8 4 4.2 4.4 4.6
20 600
X Variable 500
1
0
400
X Variable 2 Line Fit Plot
-20 0 0.2 0.4 0.6 0.8 1 1.2 Y
-40 300 600
X Variable 2
Y
Predicted Y
-60
200
100 400
X Variable 3 Line Fit Plot
Y
0 X Variable 3
600
Y
Predicted
4 4.5 2005 5.5 6 6.5 7 7.5 8 8.5
400
0 X Variable 1
Y
2.6 2.8 200
3 3.2 3.4 3.6 3.8 4 4.2 4.4 4.6
0 X Variable 2
0 0.2 0.4 0.6 0.8 1
X Variable 3
Plot
Y
Predicted Y
Line Fit Plot
Y
Predicted Y
Y
2 4.4 4.6 Predicted Y
0.8 1 1.2
3
