"For Genious Alert1234" ONLY! No other replies please

profileBrikrys
w6_template.xlsx

Question 1

day # errors proportion of errors
1 4 0.2
2 2 0.1
3 0 0
4 5 0.25
5 2 0.1
6 0 0
7 1 0.05
8 0 0
9 5 0.25
10 1 0.05
11 4 0.2
12 2 0.1
13 0 0
14 5 0.25
15 3 0.15
16 0 0
17 5 0.25
18 2 0.1
19 1 0.05
20 0 0
n 20.0000
days 20.0000
p-bar 0.105
sigma 0.0685474288 Sigma = sqrt (p-bar * (1- p-bar))/n)
3 * sigma 0.2056422865
UCL 0.3106422865 pbar + (3*sigma)
LCL 0 < --- Cant have less than zero instances of errors
Now - Graph this. Graph the proportion of errors, and make a horizontal line across the graph at 0.31 for the upper control limit. Make another horizontal line at 0 for the lower control limit. Do the proportion of errors for any of the days go outside of these two lines?

Question 2

Day #errors Dr A #errors Dr B #errors Dr C #patients Dr A #patients Dr B #patients Dr C Proportion errors Doctor A Proportion errors Doctor B Proportion Errors Doctor C
1 0 33 31 25 0.00
2 2 35 33 24 0.06
3 0 38 30 28 0.00
4 0 35 28 22 0.00
5 4 33 30 24 0.12
6 0 40 31 19 0.00
7 0 37 29 24 0.00
8 2 41 30 23 0.05
9 0 34 32 23 0.00
10 1 32 30 25 0.03
11 0 36 28 24 0.00
12 0 35 30 16 0.00
13 2 40 24 26 0.05
14 0 38 33 25 0.00
15 0 36 34 24 0.00
16 0 38 30 26 0.00
17 2 34 29 24 0.06
18 0 35 28 28 0.00
19 1 36 30 25 0.03
20 0 34 30 25 0.00

Sheet2

Sheet3