Use the attached Template for question #1. Replace the data with that from the case

Component: \#03217666 Description: Bracket Design specification: 40.06 inches Once Bill calculated a preliminary process capability from this data and examined the training and quality control procedures at Trexler, he realized he had some serious work ahead of him. ASSIGNMENT 1. Calculate the Cp and Cpk of the process that produces the component purchased by Integrated Devices. Remember-process width = six times the standard deviation of the sample. Can the process at Trexler satisfy design requirements? What should be a target Cp level? \begin{tabular}{l|r|} \hline Nominal specification & 10.7 \\ \cline { 2 - 2 } Upper specification limit & 10.9 \\ \cline { 2 - 3 } Lower specification limit & 10.5 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline DATA & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 & 12 & 13 & 14 & 15 \\ \hline 1 & 10.650 & 10.800 & 10.500 & 10.800 & 10.700 & 10.800 & 10.750 & 10.650 & 10.850 & 10.650 & 10.800 & 10.650 & & & \\ \hline 2 & 10.750 & 10.850 & 10.800 & 10.800 & 10.700 & 10.700 & 10.850 & 10.700 & 10.800 & 10.550 & 10.700 & 10.850 & & & \\ \hline 3 & 10.750 & 10.700 & 10.650 & 10.800 & 10.650 & 10.650 & 10.750 & 10.650 & 10.500 & 10.800 & 10.750 & 10.800 & & & \\ \hline 4 & 10.600 & 10.650 & 10.650 & 10.700 & 10.600 & 10.750 & 10.800 & 10.850 & 10.650 & 10.650 & 10.700 & 10.600 & & & \\ \hline 5 & 10.700 & 10.750 & 10.700 & 10.750 & 10.550 & 10.700 & 10.850 & 10.700 & 10.750 & 10.600 & 10.750 & 10.700 & & & \\ \hline 6 & 10.600 & 10.900 & 10.850 & 10.750 & 10.650 & 10.650 & 10.600 & 10.750 & 10.750 & 10.600 & 10.650 & 10.650 & & & \\ \hline 7 & 10.600 & 10.750 & 10.800 & 10.700 & 10.600 & 10.850 & 10.850 & 10.850 & 10.800 & 10.850 & 10.850 & 10.800 & & & \\ \hline 8 & 10.750 & 10.750 & 10.700 & 10.700 & 10.700 & 10.600 & 10.650 & 10.850 & 10.750 & 10.650 & 10.700 & 10.650 & & & \\ \hline 9 & 10.650 & 10.650 & 10.750 & 10.800 & 10.650 & 10.900 & 10.650 & 10.750 & 10.700 & 10.750 & 10.700 & 10.700 & & & \\ \hline 10 & 10.600 & 10.600 & 10.750 & 10.800 & 10.750 & 10.850 & 10.750 & 10.750 & 10.700 & 10.650 & 10.600 & 10.650 & & & \\ \hline \end{tabular} Process Capability Index Calculations \begin{tabular}{|c|c|} \hline Average & 10.7171 \\ \hline Standard deviation & 0.0868 \\ \hline \end{tabular}\begin{tabular}{|l|l|} \hline Cp & 0.76766 \\ \hline Cpl & 0.83323 \\ \hline Cpu & 0.70209 \\ \hline Cpk & 0.70209 \\ \hline \end{tabular} Frequency Distribution and Histogram \begin{tabular}{|l|l|} \hline Data Minimum & 10.500 \\ \hline Data Maximum & 10.900 \\ \hline \end{tabular} Enter smallest and largest limits for the frequency distribution. The lower limit should be slightly less than the data minimum. The upper limit should be slightly larger than the data maximum. Enter number of cells ( 10 or less) \begin{tabular}{|l|r|} \hline Number of Cells & 8 \\ \hline \end{tabular} \begin{tabular}{|l|c|} \hline Lower limit & 10.450 \\ \hline Upper limit & 10.950 \\ \hline Cell width & 0.063 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Cell & From & To (inclusive) & Frequency \\ \hline & -Infinity & 10.45 & 0 \\ \hline 1 & 10.45 & 10.51 & 2 \\ \hline 2 & 10.51 & 10.58 & 2 \\ \hline 3 & 10.58 & 10.64 & 13 \\ \hline 4 & 10.64 & 10.70 & 47 \\ \hline 5 & 10.70 & 10.76 & 24 \\ \hline 6 & 10.76 & 10.83 & 16 \\ \hline 7 & 10.83 & 10.89 & 14 \\ \hline 8 & 10.89 & 10.95 & 2 \\ \hline 9 & 10.95 & 11.01 & 0 \\ \hline 10 & 11.01 & 11.08 & 0 \\ \hline \end{tabular}