Explore BrainMass

Explore BrainMass

    Statistical Quality Control: Colonel Electric

    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:

    Sample Mean Range
    1 979 50
    2 1087 94
    3 1080 57
    4 934 65
    5 1072 135
    6 1007 134
    7 952 101
    8 986 98
    9 1063 145
    10 958 84

    A) What is the overall average of these means?
    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.
    D) Develop upper and lower control limits for the range. Do these samples indicate that the process is in control?

    © BrainMass Inc. brainmass.com June 4, 2020, 3:29 am ad1c9bdddf


    Solution Preview

    Please refer to the attachment for full solutions.

    a) The overall average of these means is 1011.8.

    b) ...

    Solution Summary

    This solution is comprised of a detailed explanation of 95% confidence interval for Statistics Quality Control using Excel. In this solution, step-by-step explanation of this complicated topic provides students with a clear perspective of 95% confidence interval for process in control with the help of excel. In brief, this solution is comprised of a detailed explanation for upper and lower limits for mean in Statistical Quality Control.