# Excel generated control chart

Not what you're looking for?

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.

##### Purchase this Solution

##### Solution Summary

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

##### Solution Preview

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

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

##### Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

##### Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

##### Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.