Week 4 Reflection (Ch 6) AND EXCEL WORK Name: Answer each of the following questions in complete sentences and relate your answers to the context of the problem. Upload your well-documented Excel and...

See attachment. The word document and an excel document will need to be completed


Week 4 Reflection (Ch 6) AND EXCEL WORK Name: Answer each of the following questions in complete sentences and relate your answers to the context of the problem. Upload your well-documented Excel and to make note in this file of what Excel functions you used and when you used them, and how you arrived at your answers. Chapter 6 Reflection: Motorola used the normal distribution to determine the probability of defects and the number of defects expected in a production process. Assume a production process produces items with a mean weight of 10 ounces. 1. The process standard deviation is 0.15 and the process control is set at plus or minus on standard deviation, so units with weights less than 9.85 oz or greater than 10.15 oz will be classified as defects. Find the probability of a defect and the expected number of defects for a 1000-unit production run. 2. Through process design improvements, suppose the process standard deviation can be reduced to 0.05. Assume the process control remains the same, so products with weights less than 9.85 and more than 10.15 ounces are classified as defects. Find the probability of a defect and the expected number of defects for a 1000-unit production run. 3. What is the advantage of reducing process variation (question 2)? In other words, explain (mathematically) why reducing the standard deviation to 0.05 but keeping the process controls at 9.85 and 10.15 ounces led to better production outcomes.