Help with excel QM

16-16 Colonel Electric is a large company that produces lightbulbs and other electrical products. One partic~ 11la1' lightbulb is supposed to have an average life of about 1,000 hours before it burns out. Petiodically the company will test 5 Of these and measure the av- erage time before these burn out. The following table gives the tesults of 10 such samples: SAMPLE SAMPLE SAMPLE no. 3 a N0. 3 R N0. 3 R 1 63.3 2.0 13 63.6 1.3 2 63.6 1.0 19 63.3 1.3 3 63.7 1.7 20 63.5 1.6 4 63.9 0.9 21 63.9 1.0 s 63.4 1.2 22 63.2 1.8 6 63.0 1.6 23 63.3 1.9 7 63.2 1.3 24 64.0 2.0 s 63.3 1.3 25 63.4 1.5 9 63.7 1.6 SAMPLE l 2 3 4 5 6 7 8 9 10 Mean 979 1037 1080 934 1072 1007 952 986 [063 958 Range 50 94 57 65 135 - 134 101 98 145 34 (a) What is the overall average of these means? What is the average range? (h) What are the upper and lower control limits for a 99.7% control chart for the mean? (0} Does this process appear to be in control? Explain