Continuing in your role as Chief Quality Control officer at The Heavenly Hula Hoop Company-- and based on your recent success at improving their 100 cm hula-hoop production process-- you have been asked to assess the capability of the company's ability to consistently produce its line of 95 cm diameter hula-hoops. Again, you make observations of 50 hoops, selected at random, and measure their diameters to the hundredth of a centimeter (2 decimal places). The data you have collected is in the following table:

NOTE: See assignment attachments for downloadable excel document of the collected data. This will allow you the opportunity to complete calculations in a spreadsheet.

Observation	Hula-Hoop Diameter (cms)
1	91.89
2	92.66
3	99.45
4	97.81
5	91.83
6	93.60
7	94.77
8	97.69
9	91.77
10	98.68
11	93.23
12	94.45
13	92.43
14	96.73
15	94.17
16	94.76
17	90.26
18	92.71
19	93.84
20	98.03
21	92.09
22	90.65
23	91.64
24	99.88
25	94.73
26	91.09
27	94.65
28	98.51
29	94.53
30	96.30
31	94.85
32	91.11
33	91.59
34	97.61
35	91.02
36	94.92
37	98.54
38	93.52
39	97.78
40	99.77
41	92.07
42	91.92
43	90.76
44	97.91
45	90.75
46	92.61
47	99.47
48	90.23
49	90.41
50	96.39

The buyer of these hula-hoops has stipulated in his contract that he will only buy hula-hoops that are 95 cms in diameter, plus or minus 0.5 cms.Using these customer specifications and the data in the table above, please answer the following questions (please round to 2 decimal places).

Questions

1. What is the Upper Specification Limit, in centimeters?
2. What is the Lower Specification Limit, in centimeters?
3. What is the data set's mean (average) diameter for the production of this line of hula-hoops?
4. What is the standard deviation of the data set?
5. What is the Upper Control Limit?
6. What is the Lower Control Limit?
7. What is the Z-score for the USL?
8. What is the Z-score for the USL?
9. What is the Cp Index?
10. What is the Cpk Index?