Business statistics project2
qaws848191
Salespricepromotion1-51529.pdf
Price of an item and number of promotonal
coupons can explain the variation in
number of sales.
Mean 3,098.68
Y X1 X2 Standard Error 215.47
Day Observed Sales Price Promotion Median 3,430.50
1 4,141 59 200 Mode none
2 3,842 59 200 Standard Deviation 1,256.42
3 3,056 59 200 Sample Variance 1,578,596.29
4 3,519 59 200 Kurtosis (0.71)
5 4,226 59 400 Skewness (0.37)
6 4,630 59 400 Range 4,445.00
7 3,507 59 400 Minimum 675.00
8 3,754 59 400 Maximum 5,120.00
9 5,000 59 600 Sum 105,355.00
10 5,120 59 600 Count 34
11 4,011 59 600
12 5,015 59 600
13 1,916 79 200 Mean 77.82
14 675 79 200 Standard Error 2.79
15 3,636 79 200 Median 79.00
16 3,224 79 200 Mode 59.00
17 2,295 79 400 Standard Deviation 16.29
18 2,730 79 400 Sample Variance 265.24
19 2,618 79 400 Kurtosis (1.48)
20 4,421 79 400 Skewness 0.11
21 4,113 79 600 Range 40.00
22 3,746 79 600 Minimum 59.00
23 3,532 79 600 Maximum 99.00
24 3,825 79 600 Sum 2,646.00
25 1,096 99 200 Count 34
26 761 99 200
27 2,088 99 200
28 820 99 200 Mean 388.24
29 2,114 99 400 Standard Error 27.93
30 1,882 99 400 Median 400.00
31 2,159 99 400 Mode 200.00
32 1,602 99 400 Standard Deviation 162.86
33 3,354 99 600 Sample Variance 26,524.06
34 2,927 99 600 Kurtosis (1.48)
Skewness 0.11
Range 400.00
Total Sales Number of sales per day Minimum 200.00
Price Price charge in cents Maximum 600.00
Promotion Number of coupons mailed Sum 13,200.00 Count 34
Sales
Price
Promotion
Descriptive Statistics
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.74
R Square 0.54 Regression Statistics
Adjusted R Square 0.53
Standard Error 864.95
Observations 34
ANOVA
df SS MS F Significance F
Regression 1 28,153,486.15 28,153,486.15 37.63 0.00
Residual 32 23,940,191.29 748,130.98
Total 33 52,093,677.44
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 7,512.35 734.62 10.23 0.00 6,015.98 9,008.72
Price (56.71) 9.25 (6.13) 0.00 (75.55) (37.88)
yhat = 7,512.35 - 56.71x1
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.54
R Square 0.29
Adjusted R Square 0.26
Standard Error 1,077.87
Observations 34
ANOVA
df SS MS F Significance F
Regression 1 14,915,814.10 14,915,814.10 12.84 0.00
Residual 32 37,177,863.34 1,161,808.23
Total 33 52,093,677.44
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 1,496.02 483.98 3.09 0.00 510.18 2,481.85
Promotion 4.13 1.15 3.58 0.00 1.78 6.47
yhat = 1,496.02 + 4.13x2
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.87
R Square 0.76
Adjusted R Square 0.74
Standard Error 638.07
Observations 34
ANOVA
df SS MS F Significance F
Regression 2 39,472,730.77 19,736,365.39 48.48 0.00
Residual 31 12,620,946.67 407,127.31
Total 33 52,093,677.44
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 5,837.52 628.15 9.29 0.00 4,556.40 7,118.64
Price (53.22) 6.85 (7.77) 0.00 (67.19) (39.24)
Promotion 3.61 0.69 5.27 0.00 2.22 5.01
yhat = 5,834.52 - 53.22x + 3.61x2
