In: Statistics and Probability
6. One hundred insurance claim forms are inspected daily at Full Life Insurance Co. over 25 working days, and the number of forms with errors have been recorded in the worksheet Prob07-06 in the Ch07Data.xlsx file. Construct a p-chart. If any points occur outside the control limits, assume that assignable causes have been determined and construct a revised chart.
Problem7-06 | |
Full Life Insurance Co. | |
Day | Number Defective |
1 | 3 |
2 | 3 |
3 | 3 |
4 | 2 |
5 | 0 |
6 | 3 |
7 | 0 |
8 | 1 |
9 | 7 |
10 | 3 |
11 | 2 |
12 | 0 |
13 | 0 |
14 | 4 |
15 | 1 |
16 | 2 |
17 | 4 |
18 | 0 |
19 | 1 |
20 | 1 |
21 | 0 |
22 | 2 |
23 | 8 |
24 | 1 |
25 | 4 |
Please show formulas and all work in excel