Question: please explain how to do it 2) in industrial engineering, quality control of manufacturing processes is a core concern. In a specific manufacturing plant, 10
2) in industrial engineering, quality control of manufacturing processes is a core concern. In a specific manufacturing plant, 10 items are tested every hour. For each item, two quantities (P and Q) are measured. The P value must be at least a certain value (pmin), while the value must not exceed a certain value (qmax). Using any sort of Excel conditional functions, replicate the worksheet shown below. What happens to the passing percentages if pmin is increased to 1.50, and gmax is increased to 0.75? (You should only need to change the values of prin and qmax in D2 and D3 to answer that question.) 1 Quality control Ipmin Iqmax 0.50 P test IQ test Two tests 0.65 0.50 OPPO 0.50 0.36 0.45 Percentage passing 80.0% 70.0% 60.0%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
