Hi, could you please answer this question by using excle with full details and showin formulas please. thank u
1)- You’ve been assigned to evaluate insurance claims for errors and developed the following data. Your sample size varied each day depending on the number of claims. Construct a P chart and determine if your company’s process for completing claims is in control.
Day Number Defective Number Sampled
1 3 75
2 3 80
3 3 92
4 2 68
5 0 70
6 3 80
7 0 93
8 1 58
9 7 112
10 3 96
11 2 82
12 0 76
13 0 74
14 4 78
15 1 96
16 2 65
17 4 64
18 0 58
19 1 78
20 1 59
21 0 60
22 2 58
23 8 54
24 1 74
25 4 67
Expert Answer
C27 =AVERAGE(C2:C26)
D27 =AVERAGE(D2:D26)
UCL: =D27+3*(SQRT((D27*(1-D27)/C27)))
LCL: =D27-3*(SQRT((D27*(1-D27)/C27)))
https://d2vlcm61l7u1fs.cloudfront.net/media%2F960%2F9601d5c3-5b58-4a8a-9122-b919e4d15abc%2FphpuzvfzO.png
https://d2vlcm61l7u1fs.cloudfront.net/media%2F22e%2F22e9af73-b618-41bb-ade5-ccc24a575610%2FphpOQt5xP.png
Since one of the values of defective fraction is out of control limits, we have to say that the process is not in control.