Explore BrainMass

Excel generated control chart

This content was STOLEN 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 October 25, 2018, 2:04 am ad1c9bdddf


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.

See Also This Related BrainMass Solution

Construct Hypothesis Tests in Excel for Employees

Please help setting up and solving the following problem in Excel. The problem with all necessary data are contained in the attached excel spread sheet.

MegaStat or similar excel add-in program may be used for the solution.

StatPro [or other excel statistics program] generates new sheets for each problem and deletes previous sheets with the same name. If you want to keep a sheet for your solution, then rename it immediately by prefixing the problem number. You may need suffix numbers to keep the names unique.

The data in the file P11_3.XLS - as set forth below - consist of 25 subsamples of 6 observations each on the fill weights of cans of paint. The ideal weight of these paint cans is 20 pounds.


(a) Using Excel - Generate and interpret ¯X and R charts for the given data. (i) Which control limits do you believe are most appropriate? Explain. (ii) Does this filing process appear to be in control now? (iii) Does this filing process appear to be in control now?

(b) Are there any other indications that the given process may be out of control now? If so, explain.

(c) What advise would you give to the operators of the filing process based on your analysis of the latest sample information?

View Full Posting Details