A manufacturing process with acceptance limits 100 +-3 produces measurements in Data below. What percentage of production does not meet the acceptance limits? Please show how to compute in excel.
98.735 |
100.714 |
101.408 |
99.543 |
101.002 |
98.128 |
100.713 |
101.124 |
98.408 |
99.424 |
99.855 |
98.321 |
100.653 |
100.918 |
101.449 |
101.439 |
101.562 |
100.501 |
100.584 |
99.929 |
100.103 |
100.699 |
99.280 |
100.430 |
100.628 |
101.745 |
101.382 |
99.522 |
100.465 |
100.863 |
100.413 |
99.417 |
99.278 |
100.248 |
98.216 |
98.376 |
101.782 |
99.715 |
100.654 |
99.561 |
99.855 |
102.001 |
100.976 |
101.014 |
98.673 |
99.797 |
98.274 |
101.543 |
97.845 |
101.391 |
First copy your data and paste it in any one of the column of excel sheet.
Then click on ‘Data’.
Sort the data from minimum to maximum. For sorting this data, use A to Z down-arrow icon.
After sorting you will get minimum value as 97.845 and maximum value as 102.001.
We are given process acceptance limits as 100 ± 3
Lower limit = 100 – 3 = 97
Upper limit = 100 + 3 = 103
So, it is observed that all observations are lies within 97 and 103.
There is no any observation beyond the lower and upper limits.
100% of the production meets the acceptance limits.
So, 0% of the production does not meet the acceptance limits.
Answer: 0%
Get Answers For Free
Most questions answered within 1 hours.