One hundred and twenty measurements of the dimension of a manufactured part for an automobile were taken from a controlled process. The data has been collected below.

Process Capability Analysis
													Process Capability
DATA	1	2	3	4	5	6	7	8	9	10	11	12		Nominal specification	10.9
1	11.000	11.000	10.800	10.750	10.900	10.850	11.100	11.000	10.900	11.100	10.700	10.750		Upper specification limit	11.1
2	10.850	11.000	10.950	10.700	11.000	10.700	10.750	10.700	10.950	11.050	11.000	10.800		Lower specification limit	10.7
3	10.700	10.950	11.050	11.100	10.800	10.900	10.850	10.750	10.900	10.850	11.000	11.050
4	10.750	10.850	10.950	11.050	10.950	10.800	10.700	11.000	10.900	10.950	11.000	11.050		Average
5	11.100	11.050	11.000	11.050	10.750	10.900	10.900	11.000	10.700	11.050	11.000	10.750		Standard deviation
6	10.900	10.900	11.100	11.000	10.700	10.850	11.100	10.800	11.100	10.800	10.700	11.100		Cp
7	11.050	11.100	11.050	10.700	10.750	11.000	10.700	10.700	11.000	10.800	10.750	10.850		Cpl
8	10.800	11.050	10.950	11.000	11.100	10.800	10.850	10.850	10.850	10.950	10.900	10.750		Cpu
9	10.950	11.100	10.900	10.700	11.000	11.000	10.850	10.950	10.800	10.950	11.100	10.950		Cpk
10	10.850	10.800	11.100	11.000	11.100	10.850	10.750	11.100	10.750	11.000	10.800	10.950
													Frequency Distribution and Histogram
Use the area below to construct a histogram.
													Number of Cells	10
													Lower limit	10.650
													Upper limit	11.150
													Cell width
													Data Minimum
													Data Maximum
														Cell	From	To (inclusive)
													-Infinity
													1
													2
													3
													4
													5
													6
													7
													8
													9
													10

Questions

1. Calculate the average of the data. Round your answer to four decimal places.

2. Calculate the standard deviation of the data. Round your answer to four decimal places.

3. Calculate the process capability index. Round your answer to five decimal places. Do not round intermediate calculations.

4. Calculate the lower one-sided capability index. Round your answer to five decimal places. Do not round intermediate calculations.

5. Calculate the upper one-sided capability index. Round your answer to five decimal places. Do not round intermediate calculations.

6. Find the smallest one-sided capability index. Round your answer to five decimal places. Do not round intermediate calculations.

7. Find the minimum and maximum of the data. Round your answers to three decimal places.

8. Construct the frequency distribution for the data. For calculating the cell width assume 10 cells, the lower limit of 10.65 inches and upper limit of 11.15 inches. Round your answers for interval boundaries to two decimal places and round your answers for frequencies to the nearest whole number.

Cell	From	To (inclusive)	Frequency
	-Infinity
1
2
3
4
5
6
7
8
9
10