Check My Work Spreadsheet CO eBook Suppose that a manufacturer of a particular automotive part classifies each unit produced as either defective or nondefective. Each hour 200 parts are randomly selected from a very large batch of manufactured items and tested for possible defectiveness. The file P19_20.xlsx lists the number of defective parts (out of the 100 sampled) found during each of 30 consecutive hours of production. a. Based on the given sample data, is this production process currently in control Provide support for your conclusions. Round your answers for the mean of the proportions of defective items, the lower and upper control limits to three decimal places and for the standard deviation of the proportions of defective items to four decimal places, if necessary. - SDC) - V LCL - maa(0,2-35D) - UCL = min(1,2+35D) - None of the proportions of defective items are outside the control limits. b. What advice, if any, would you give to the managers of this production process? Management should continue to monitor the production process. More importantly, it ought to try to improve the process so that the average defect rate, now about 5% can be decreased Paste B I U A A1 x fx Sample Number A B C D E F Sample Number 1 3 4 Number Defective 9 13 13 9 S Sample Size 200 200 200 200 200 200 200 200 200 6 7 8 9 10 9 10 8 10 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 2 3 4 S 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 12 10 10 8 8 11 9 8 9 10 12 6 8 5 9 6 8 12 7 8 9 29 30 31 32 33