Instructions:

Review the Case Study 11.1 in your Textbook (pg. 536): Heating Oil at Dupree Fuels Company. The data for this study can be found in the file 310case_study5data.xlsx. Read the summary in the textbook. Perform the suggested analysis. Produce graphs to illustrate the relationships. Clearly state any null and alternative hypotheses. Present your analysis to Dupree’s Board of Directors. What recommendations would you make based on your analysis?

Submit your analysis in a Word document with any supporting graphs and calculations. Your analysis should be at least three pages. Also submit the Excel file you used to construct the graphs and perform calculations in Blackboard. Save your file as Last Name and CS#5.

Grading Rubric

Points

Purpose

Notes

5

3 pages

More than 3 pages is fine, though more than 5 is starting to be excessive. For each page under 3, subtract two points. Use discretion penalizing for excessive pages

3

Citations in APA format

Citations should generally exist and be properly formatted. Students need not cite the textbook for the case study, but should for other content.

5

Explanations of calculations

While full details of calculations should remain in the Excel file, students should clearly state what they did and the results.

5

Required calculations

All calculations should be completed and checked for accuracy. Errors can count 0.5 points each, for each calculation error, or procedural error, up to 1 point for the entire process.

2

Required graphs

Graphs are appropriate and are properly labeled.

B

case study 5