Use excel to get answer of below question please
Posted: Wed Jul 06, 2022 12:40 pm
Use excel to get answer of below question please
II. For the given data on sheet 1, Obtain p chart for variable sample size. Tabulate the values. Us Clearly mark UCL,CL, LCL. Check whether the process is in control. If not obtain the revised limits.
Sheet1 Lot 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Sheet2 Sample Size Numberof defectives 1250 1300 1350 1250 1150 1050 1200 1100 1000 600 1350 1350 1300 1100 1050 950 1560 1150 1230 1100 18 15 13 16 8 16 18 14 22 12 13 19 33 20 21 20 22 17 19 21 Sheet3
- Use Excel To Get Answer Of Below Question Please 1 (10.33 KiB) Viewed 9 times
Sheet1 Lot 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Sheet2 Sample Size Numberof defectives 1250 1300 1350 1250 1150 1050 1200 1100 1000 600 1350 1350 1300 1100 1050 950 1560 1150 1230 1100 18 15 13 16 8 16 18 14 22 12 13 19 33 20 21 20 22 17 19 21 Sheet3