C F G KLM A quality control engineer needs to ensure that the caps on shampoo bottles are fastened correctly. If the caps are fastened too loosely, they may fall off during shipping. If they are fastened too tightly, they may be too difficult to remove. The target torque value for fastening the caps is 18+/2 in-lbs. The engineer collects a random sample of 68 bottles and tests the amount of torque that is needed to remove the caps. HOMEWORK: ALL WORK IS TO BE DONE USING THE XL ADD IN 1. Generate the descriptive stats for the data set in Column A. A. Highlight in yellow the measures of central tender ( x bar) B. Highlight in yellow the measures of variation (s) C. Highlight in yellow the count of values in the data ( n ) 2. Make a histogram of the data using an appropriate bin size for the data. A. Add labels for the X and Y axes B. Draw lines on the chart to show the target value of 18 and the +/2 tolerance C. Add an appropriate title to your chart. 3. Make a Pareto Chart of the data A. show values of frequency on the Y axis B. show bin values on the X axis C. Add an appropiate title to your chart 4. Upload your work as Sheets in an XI. workbook with titles on the bottom tabs and/or submit your work as a pdf with individual sheets as needed. Make sure your name and class section are included on EACH submittal