Answer Happy

Excel Online Activity: Process Capability 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 in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Questions 1. Calculate the average of the data. Round your answer to four decimal places. 10.8708 2. Calculate the standard deviation of the data. Round your answer to four decimal places. .365 3. Calculate the process capability index. Round your answer to five decimal places. Do not round intermediate calculations. 0 4. Calculate the lower one-sided capability index. Round your answer to five decimal places. Do not round intermediate calculations. 0 5. Calculate the upper one-sided capability index. Round your answer to five decimal places. Do not round intermediate calculations. 0 6. Find the smallest one-sided capability index. Round your answer to five decimal places. Do not round intermediate calculations. 0 7. Find the minimum and maximum of the data. Round your answers to three decimal places.
Б H 1 nalysis Process Capability 10.9 6 10.700 10 11.000 11 10.800 10.900 12 11.100 Nominal specification Upper specification limit Lower specification limit 11.1 10.7 10.750 10.850 10.750 10.750 1 2 10.800 10.750 11.000 10.950 10.800 11.050 10.900 10.850 10.900 11.050 10.800 10.750 10.800 10.700 11.000 10.900 11.050 11.050 10.850 10.700 3 10.850 11.050 10.750 10.800 10.700 11.100 11.050 10.700 10.750 10.700 4 11.050 10.700 10.900 10.750 10.800 10.950 11.050 10.950 11.000 10.800 5 11.000 10.850 10.850 10.750 10.750 10.850 11.000 10.850 10.950 11.100 11.050 10.850 10.700 7 8 9 11.050 10.700 10.700 11.100 10.900 10.800 10.800 11.050 10.800 10.750 10.800 11.000 11.000 11.100 11.000 10.850 10.800 10.700 10.800 10.950 11.050 10.900 10.700 10.800 10.950 10.750 10.700 10.750 10.800 11.050 10.950 10.850 10.750 11.050 10.900 10.700 10.800 11.000 10.700 10.900 10.700 10.700 10.900 10.950 11.000 10.700 10.750 11.000 11.000 10.850 11.100 10.950 10.700 10.800 Average Standard deviation Ср Cpl Cpu Cpk 10.850 10.900 10.950 10.800 Frequency Distribution and Histog construct a histogram. 10 Number of Cells Lower limit Upper limit 10.650 11.150