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

Answer rating: 100% (QA)

Solution is calculated using Excel and ... View the full answer