Explore BrainMass
Share

Excel generated control chart

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Colonel Electric is a large company that produces lightbulbs and other electrical products. One particular lightbulb is supposed to have an average life of about 1,000 hours before it burns out. Periodically the company will test 5 of these and measure the average time before these burn out. The following table gives the results of 10 such samples:

(a) What is the overall average of these means? What is the average range?
(b) What are the upper and lower control limits for a 99.7% control chart for the mean?
(c) Does this process appear to be in control? Explain.

See the attached file.

© BrainMass Inc. brainmass.com March 21, 2019, 7:15 pm ad1c9bdddf
https://brainmass.com/statistics/control-chart/excel-generated-control-chart-285020

Attachments

Solution Preview

Attached is a spreadsheet with the control chart. Note the Excel ...

Solution Summary

Attached is a spreadsheet with the control chart. This includes the Excel formulas used to implement A2 and calculate the limits.

$2.19