Business Question Upper And Lower Control Limit Calculation Help complete in excel file. Set control limits for this process and graph the sam- ple data fo | Homework Answers

Business Question Upper And Lower Control Limit Calculation Help complete in excel file. Set control limits for this process and graph the sam-
ple data for both the x- and R-charts.
15-16 Colonel Electric is a large company that produces
lightbulbs and other electrical products. One particu-
lar lightbulb is supposed to have an average life of
about 1,000 hours before it burns out. Periodically,
the company will test five of these and measure the
average time before these burn out. The following
table gives the results of 10 such samples:
SAMPLE 1 2 3 4 5 6 7 8 9 10
Mean 979 1,087 1,080 934 1,072 1.007 952 986 1,063 958
Range
94 57 65 135 134 101 98 145 84
50
(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.

Purchase answer to see full
attachment

Don't use plagiarized sources. Get Your Custom Essay on
Business Question Upper And Lower Control Limit Calculation Help complete in excel file. Set control limits for this process and graph the sam- ple data fo | Homework Answers
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT! To Get a 10% Discount Use Coupon Code FIRST39420
Order Essay
Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper