Purchase Solution

Excel generated control chart

Not what you're looking for?

Ask Custom Question

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.

Attachments
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
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.

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Constructing a p chart for given data using excel

    On your control chart, extend the control limits generated in (b) and plot the proportions for days 31 through 37. What effect, if any, did the in-store promotion have on RudyBird's market share? Please check attachment.

  • Control Limits

    Note the 30 values for xa,xb and xc are generated in excel. To do this : go to "tools > data analysis> random number generator> select Poisson distribution ). You can plot the corresponding D's on a chart easily using pen and paper.

  • Hypothesis testing problems

    Construct a p chart for this combined sample. Is the process out of control or not?

  • How to make SUpply & Demand Graphs on Excel

    Click on OK and the chart will be generated showing the Equilibrium Quantity point as 20 which confirms the calculation above. The solution will help you create Suppy & Demand Graphs using Excel. Contain a step by step explanation.

  • create a histogram

    I don't know how to add lines to an Excel chart so I put it in manually. The bar chart (histogram) is on the page in Excel.

  • Autopitch Control Charts with Control Limits

    View the Excel formulas in cells I8, I9 for average chart control limits and in cells I12 and I13 for the range chart control limits.

  • Control chart

    Please use Excel. Please see the attachments for solution. The solution describes the determination of the control limits of a control chart.

  • Making an XBar Control Chart with Excel

    589463 Making an XBar Control Chart with Excel CONTROL CHARTS Assignment Overview You have taken data from a production process in order to develop an Xbar control chart.

  • SPC Chart

    542868 Prepares SPC Chart Data Complete the following actions, using the Excel file "Optional Problem Data Student File" for the actions involve Excel: 1.

View More Related Solutions