ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
YX1X2X31 variable2 variables3 variablesContribution
2
TimePie Sales ($1,000s)Price ($)Advertising ($1,000s)HolidayForecast: Price OnlyForecast: Price + AdsForecast: Price + Ads + HolidayBaselinePriceAdsHolidayBaselinePriceAdsHoliday
3
Week 13505.53.30426414374$415.10-$95.10$53.91$0.00$6,226.48-$1,715.34$852.83$626.03
4
Week 24607.53.31378364429$415.10-$129.69$53.91$89.43
5
Week 3350830366329326$415.10-$138.33$49.01$0.00BaselinePriceAdsHoliday
6
Week 443084.51366440440$415.10-$138.33$73.52$89.43103.95%-28.64%14.24%10.45%
7
Week 53506.830395359347$415.10-$117.58$49.01$0.00
8
Week 63807.540378416351$415.10-$129.69$65.35$0.00
9
Week 74304.530450417386$415.10-$77.81$49.01$0.00
10
Week 84706.43.71404421454$415.10-$110.67$60.45$89.43
11
Week 945073.51390391441$415.10-$121.04$57.18$89.43
12
Week 10490541438478483$415.10-$86.46$65.35$89.43
13
Week 113407.23.50385386348$415.10-$124.50$57.18$0.00
14
Week 123007.93.20368346331$415.10-$136.60$52.28$0.00
15
Week 134405.941416456468$415.10-$102.02$65.35$89.43
16
Week 1445053.51438441475$415.10-$86.46$57.18$89.43
17
Week 1530072.70390332338$415.10-$121.04$44.11$0.00
18
$6,226.48-$1,715.34$852.83$626.03
19
Coefficient X3Coefficient X2Coefficient X1103.95%-28.64%14.24%10.45%
20
HolidayAdvertisingPriceIntercept
21
1 variable-24.03385832558.2772497
22
2 variables74.13095749-24.97508952306.5261933
23
3 variables89.4325624316.33776686-17.29170481415.0985167
24
25
All statistics89.4325624316.33776686-17.29170481415.0985167
26
19.4640459220.253165676.82961894973.73295445
27
0.83608069529.01464824#N/A#N/A
28
18.7020632711#N/A#N/A
29
47232.985399260.34794#N/A#N/A
30
31
DescriptionsStatistics
32
89.4325624316.33776686-17.29170481
The values of the coefficients
33
415.0985167
The y-intercept which is the value of y when x=0
34
19.4640459220.253165676.829618949
The standard error values for the coefficients
35
73.73295445
The standard error value for the y-intercept
36
0.836080695
The coefficient of determination (R squared)
37
29.01464824
The standard error for the y estimate
38
18.70206327The F statistic
39
11
The number of degrees of freedom
40
47232.98539
The regression sum of squares
41
9260.34794
The residual sum of squares
42
#N/A
The unused cells
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100