B_F07 - Sales TV New Gas People Rebate List Mean 69.83 5.21...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sales TV New Gas People Rebate List Mean 69.83 5.21 12.05 2.48 10.84 92.35 14.22 Standard Error 0.4 0.33 0.75 0.05 0.12 9.02 0.02 Median 70 4.4 11.5 2.24 11 82.3 14.23 Mode 70 2.9 2.18 12 14.27 Standard Devia 3.7 3.07 7.02 0.43 1.08 84.1 0.17 Sample Varianc 13.66 9.44 49.22 0.18 1.16 ### 0.03 Kurtosis 0.02-0.18-0.7-1.12 2.22-0.78 Skewness 0.16 0.2 0.57 0.82-0.41 1.24 0.15 Range 17 12 29.9 1.42 3 374 0.62 Minimum 62 1.1 1.93 9 13.93 Maximum 79 12 31 3.35 12 374 14.56 Sum 6075 453.5 1048.5 215.45 943 ### 1236.95 Count 87 87 87 87 87 87 87 Table 1 Outlier Screening Stat TV News Gas People Rebate List Mean 5.2 12.1 2.48 10.8 92.4 14.2178 Stdev 3.1 7.0 0.43 1.1 84.1 0.1684 Min 1.1 1.93 9.0 13.93 Max 12 31 3.35 12.0 374 14.56 Min SDs 1.70 1.56 1.28 1.71 1.10 1.70 Max SDs 2.21 2.70 2.05 1.08 3.35 2.01 - 3.0 6.0 9.0 12.0 60 65 70 75 80 Sales vs. TV advertisement TV Sales - 5.0 10.0 15.0 20.0 25.0 30.0 35.0 55 60 65 70 75 80 85 Sales vs News News Sales 0.0 100.0 200.0 300.0 400.0 55 60 65 70 75 80 85 Sales vs Rebate Rebate Sales 1.75 2.00 2.25 2.50 2.75 3.00 3.25 3.50 55 60 65 70 75 80 85 Sales vs Gas Gas Sales 9 9 10 10 11 11 12 12 13 50 55 60 65 70 75 80 85 90 Sales vs People People Sales 13.800 13.900 14.000 14.100 14.200 14.300 14.400 14.500 14.600 55 60 65 70 75 80 85 Chart 1 -Sales vs List List Sales SUMMARY OUTPUT Regression Statistics Multiple R 0.68 R Square 0.47 Adjusted R Sq 0.42 Standard Erro 2.82 Observations 87 ANOVA df SS MS F ignificance F Regression 7 547.81 78.26 9.87 Residual 79 626.61 7.93 Total 86 1174.41 Coefficients tandard Erro t Stat P-valueLower 95%pper 95% ower 95.0% pper 95.0% Intercept 62.5 26.51 2.36 0.02 9.73 115.27 9.73 115.27 TV 0.41 0.25 1.69 0.1-0.07 0.9-0.07 0.9 News-0.01 0.11-0.14 0.89-0.23 0.2-0.23 0.2 Gas-1.4 0.8-1.74 0.09-2.99 0.2-2.99 0.2 People 0.06 0.31 0.18 0.86-0.56 0.68-0.56 0.68 Rebate 0.02 5.27 0.01 0.03 0.01 0.03 List 0.39 1.83 0.22 0.83-3.25 4.04-3.25 4.04 Promo 3.79 0.93 4.08 1.94 5.64 1.94 5.64 RESIDUAL OUTPUT Observation Predicted Y Residuals 1 68.39-0.39 2 72.16 2.84 3 72.03-3.03 4 68.36-1.36 5 71.2 2.8 6 67.27 2.73 7 69.51-3.51 8 65.69 0.31 9 69.03-0.03 10 70.59-1.59 11 75.65-5.65 12 70.37-0.37 13 66.91-0.91 14 72.33 4.67 15 72.3-0.3 16 71.26 4.74 17 69.25-1.25 18 67.66 1.34 19 73.84 3.16 20 70.87 1.13 Residu Resid 21 72.65 0.35 22 69.22-1.22 23 72.23-1.23 24 68.77 0.23 25 67.24 4.76 26 71.05 0.95 27 68.4 1.6 28 69.41-0.41 29 70.84 0.16 30 73.07 2.93 31 69.29-3.29 32 69.45-3.45 33 67.02 1.98 34 69.41-4.41 35 69.5 1.5 36 70.37 2.63 37 69.4-4.4 38 67.77-5.77 39 67.19-4.19 40 70.99-0.99 41 68.71-3.71 42 69.78 1.22 43 69.46-0.46 44 71.28-1.28 45 72.21-1.21 46 70.6-0.6 47 70.62 2.38 48 68.97 1.03 49 65.41 4.59 50 65.4-1.4 51 69 1 52 72.17-0.17 53 72.85 3.15 54 71.08 0.92 55 70.07-0.07 56 69.08 2.92 57 66.38-0.38 58 68.61 0.39 59 70.1 1.9 60 72.22-3.22 61 67.4467....
View Full Document

This essay was uploaded on 04/17/2008 for the course WCOB 2023 taught by Professor Billthompson during the Fall '07 term at Arkansas.

Page1 / 34

B_F07 - Sales TV New Gas People Rebate List Mean 69.83 5.21...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online