15-16 Colonel Electric is a large company that produces lightbulbs and other electrical products. One particular lightbulb
Question:
15-16 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
No. x R
Sample
No. x R
Sample
No. x R
1 63.5 2.0 10 63.5 1.3 18 63.6 1.8
2 63.6 1.0 11 63.3 1.8 19 63.8 1.3
3 63.7 1.7 12 63.2 1.0 20 63.5 1.6
4 63.9 0.9 13 63.6 1.8 21 63.9 1.0
5 63.4 1.2 14 63.3 1.5 22 63.2 1.8
6 63.0 1.6 15 63.4 1.7 23 63.3 1.7
7 63.2 1.8 16 63.4 1.4 24 64.0 2.0
8 63.3 1.3 17 63.5 1.1 25 63.4 1.5
9 63.7 1.6
Sample 1 2 3 4 5 6 7 8 9 10
Mean 979 1087 1080 934 1072 1007 952 986 1063 958
Range 50 94 57 65 135 134 101 98 145 84
(a) What is the overall average of these means? What is the average range?
15-17 For Problem 15-16, develop upper and lower control limits for the range. Do these samples indicate that the process is in control?
REF Quantitative Analysis for Management (12th Edition) 12th Edition by Barry Render (Author), Ralph M. Stair Jr. (Author), Michael E. Hanna (Author), Trevor S. Hale (Author)
Please answer the questions with excel or QM and explain step by step how you input the data into windows QM or Excel QM to solve.
Quantitative Analysis for Management
ISBN: 978-0132149112
11th Edition
Authors: Barry render, Ralph m. stair, Michael e. Hanna