Q1: Quality team takes 30 lots to measure the number of defectives. Each lot contains 500 items. The data
given (Q1-data.xls) contains the number of defectives for each lot.
a. With this data draw a p-control chart and write your comment about the process.
b. Draw OC curve for this process. (Hint: p values between 0.01 to 0.15 with 0.01 increments, let’s
say 0.01,0.02, 0.04,…, 0.15. Use a software or basically excel!) In addition to graph, also provide
the corresponding beta values for each p in a table.
Q1 Data
| Sample | Number Defective |
| 1 | 17 |
| 2 | 26 |
| 3 | 31 |
| 4 | 25 |
| 5 | 26 |
| 6 | 29 |
| 7 | 36 |
| 8 | 26 |
| 9 | 25 |
| 10 | 21 |
| 11 | 18 |
| 12 | 33 |
| 13 | 29 |
| 14 | 17 |
| 15 | 28 |
| 16 | 26 |
| 17 | 19 |
| 18 | 31 |
| 19 | 27 |
| 20 | 24 |
| 21 | 22 |
| 22 | 24 |
| 23 | 30 |
| 24 | 25 |
| 25 | 26 |
| 26 | 28 |
| 27 | 22 |
| 28 | 31 |
| 29 | 18 |
| 30 | 23 |
