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 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%

Answer 1

Notes:

Ramk1 - Forl(Product Activation failed) x HS FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 A EX F === == = Copy Wrap Text Merge & Center. Alignment Normal Neutral General .% Number Bad Calculation ? M - Sign in AutoSum - A Fill Sort & Find & - Filter Sclect- Editing Good Check Cell A * ert Delete Format Conditional Format as Formatting Table Font Calibri Paste Format Painter BIV Cupboard F19 X V for A B C 1 Quality Control p min max D E F G H I J K L M N O P R S T 1.50 0.75 P U P test test 1.36 1.44 0.50 0.40 0 0 1 1 10 11 12 13 14 15 1.90 1.52 1.23 1.65 1.29 1,15 0.82 0.32 0.75 0.50 .36 0,45 1 1 0 1 0 0 0 1 1 1 1 1 Iwo Tests P test Otest Two lests 1 (IF146>D2,1,0)) (-IF(86>D3,0,1)) (-C6-06) 0 (=IF[A7>D2,1,0)) (=IF[B7>D3,0,1)) (=C7*07) 0 (=IFIAB>D2,1,0)) (=IFB8D3,0,1) I=CB*08) (-IF1A9D2,1,0)) (-IF(89>D3,0,1)) 1-c909) 0 -IFA10SD2,1,0)) -TH10D3,0.1)) (-C10-D10) (-1F1411>D2,1,0) (-IF(811>D3,0,1)) (-C11-011) 0 (=IF[A12>D2,1,0)) (=IF[B12>D3,0,1)) (=C12-D12) 1 (=IF|A13>D2,1,0)) (=IF013>D3,0,1)) (-C13D13) 0 (-IF1A14D2,1,0)) (-1F/B14D3,0,1)) (-C14 014) 0 -TFA1D2.1.0) (-1-(815--D3,0,1)) (-C15*015) (-SUMIF(06:C15,1,C (-SUMIF(D6:015,1,D-SUMIF(E6:E15,1,E 40.00% 6:C157/10) 6:015\/10) 6:E15/10) 0 16 Percentage Passing 50.00% 90.00% ... Sheet84 Sheet114 Sheet115 Sheet116 Sheet85 Sheet86 Sheet87 Sheet88 Sheet89 Sheet90 Sheet91 Sheet92 - FEADY H = + 100 Type here to search 1 9 e ] A ENG 11-02-20202

1. I have attached a screenshot of excel sheet so that you can easily understand the cell references used.
2. All the formulas are written in orange background cells in brackets. Just remove the outer bracket and the formula will work.