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?

We can handle this paper for you

We Guarantee ZERO Plagiarism ZERO AI

Done by Professional writers from scratch