case study 12
tonya0164
Case15.5EditedAnswerKeyGuide.docxCase 15.5: Wendell Motors
The central issue of this case is to determine factors that might be significant in determining shipping costs, in particular is whether the shipping took place on a holiday an important factor? Since a holiday or not is a categorical variables, a dummy variables is introduced into the problem.
d1
Holiday No 0
Yes 1
The Excel output for this problem is:
|
SUMMARY OUTPUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regression Statistics |
|
|
|
|
|
|
|
Multiple R |
|
|
|
|
|
|
|
R Square |
|
|
|
|
|
|
|
Adjusted R Square |
|
|
|
|
|
|
|
Standard Error |
|
|
|
|
|
|
|
Observations |
45 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
|
Regression |
|
|
|
|
|
|
|
Residual |
|
|
|
|
|
|
|
Total |
44 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
|
Intercept |
|
|
|
|
|
|
|
Distance |
|
|
|
|
|
|
|
Weight |
|
|
|
|
|
|
|
Holiday |
|
|
|
|
|
|
Students should write their report based on the results of the regression analysis.
