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