For this case study, you must submit both your report in a word document, and your Excel workbook.
Please include calculation tables and charts in your report as you would in a formal report. Submitting
the workbook does not absolve you from preparing a well formatted written QA report.
1. Weights of containers filled with a powdered dietary supplement made by WeightBgone
were measured by taking samples for 30 days consisting of 4 containers, each. The data
found in the worksheet Case4Data.xlsx were gathered by a quality analyst. The
containers were designed to be filled with 400 ± 20 grams. Construct a histogram of the
data. What can you observe about the shape of the distribution? What would you
recommend to the production manager based on your analysis? Construct a control chart
for the data. What additional information does it provide?
2. Jack Frost has used his belt-driven, hand-guided snowblower to clear his driveway for
several winters. Due to a knee replacement, he can’t do the work this winter. He wants to
make a flowchart to assist his 15-year old son in knowing what steps to follow when he
takes over the job. Assume that the blower is stored in the garage. Some of the steps
would include getting it out of the garage, blowing the snow off the driveway, and
putting it back in the garage. Are there other steps that should be included,
in order to
have a more complete flowchart? Construct the process map flowchart, using Excel, or
other appropriate software having drawing tools.
3. A kiln at Suither Pottery was thought to be unstable, due to the number of defective items
that were being experienced. To test this theory, the temperature was measured every
hour over a 36 hour cycle. The temperature range was required to be 1180 ± 20 deg. C.
The results can be found in the worksheet Case2Data.xlsx. Construct a scatter diagram
for these data. What conclusions can you reach?