Submit a Word document formatted in APA style complete with cover and reference pages. The reference page must have at least one entry: the textbook.
The submission must be a form Research Report with the following parts:
Conclusion and Recommendation: This section restates the statistical results and applies it to the business situation in the case. It also makes practical recommendations about what steps the business in the case can take going forward based on the results of the statistical analysis. The application and recommendation can take one or more of these general forms.
The statistical results of the data analysis provided an answer(s) to the issues that the business is facing. As a result specific policies or practical steps can be implemented in the business.
The statistical results of the data analysis provided only partial answers. More research and tests need to be done to come up with a more useful answers for the business situation.
The statistical results did not provide any useful information for the challenges that a business(s) is facing. Recommendations for conducting new research with new approaches, data, variables, etc. may be required.
Note
: there is always room for ‘further research’ since it is impossible for a single research case to answer every possible question.
Note
- The textbook provides narratives, questions, or actual steps/questions for each case study. While these are useful for conducting actual research, the submission must take the form of a research report and follow the above pattern.
- Consistent with the emphasis of this course on interpretation, an edited version of the answer key for the case study has been provided here Download edited version of the answer key for the case study has been provided here. Students are required to use the information to enhance their understanding of the statistical methods and the results obtained.
Case 15.1: Dynamic Scales, Inc.
The central issue in this case is the need to …. to accurately predict the … weight of trucks. If a “good” model can be developed, trucks determined to be within the acceptable weight limits will not be required to stop at the regular weigh stations.
Let
|
y = |
Static weight |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
x1 = |
Dynamic weight |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
x2 = |
Truck speed |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
x3 = |
Temperature |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
x 4 = |
moisture |
The multiple regression information from Excel is given below:
Regression Analysis |
|||||||||||||||
Regression Statistics |
|||||||||||||||
Multiple R |
0.883688864 |
||||||||||||||
R Square |
|||||||||||||||
Adjusted R Square |
|||||||||||||||
Standard Error |
|||||||||||||||
Observations |
30 |
||||||||||||||
ANOVA |
|||||||||||||||
|
df |
SS |
MS |
F |
Significance F |
||||||||||
Regression | 4 | ||||||||||||||
Residual |
25 |
||||||||||||||
Total |
29 |
||||||||||||||
Coefficients |
Standard Error |
t Stat |
P-value |
||||||||||||
Intercept |
|||||||||||||||
Front-Axle Dynamic Weight |
|||||||||||||||
Truck Speed |
|||||||||||||||
Moisture |
Note that only the slope coefficient for Front-Axle Dynamic Weight is significant. The other variables are not significant at any reasonable level of alpha as can be seen by looking at the p-value column. The overall model is …. and the adjusted R2 = ……
Students can use the stepwise regression feature of PhStat or XLSTAT to try to develop a better model. The results are as follows:
Stepwise Analysis |
Table of Results for General Stepwise |
Front-Axle Dynamic Weight entered. |
No other variables could be entered into the model. Stepwise ends. |
This model is also significant and has an R2 of. The students might indicate that the company could want to explore other variables as possible independent variables.