Create Nonconformity Control Charts Chapter 8

profileericmutua44
Ch08.xls

Figure08-01

Chapter 8 - Statistical Process Control for Non-Conformities
Table 8.2 – Medical Record Errors
Figure 8.1 – c chart for Medical Record Errors
n = 10
Errors/Sample
Week c Ctr Line UCLc LCLc
Jan 10 16.30 28.41 4.19
Feb 20 16.30 28.41 4.19
Mar 15 16.30 28.41 4.19
Apr 12 16.30 28.41 4.19
May 22 16.30 28.41 4.19
Jun 21 16.30 28.41 4.19
Jul 18 16.30 28.41 4.19
Aug 16 16.30 28.41 4.19
Sep 15 16.30 28.41 4.19
Oct 14 16.30 28.41 4.19
Total 163
cbar 16.3

Figure08-01

c
Ctr Line
UCLc
LCLc
Errors per Sample (n=10)
c Chart of Medical Record Errors Jan-Oct 2011

Figure08-02

Chapter 8 - Statistical Process Control for Non-Conformities
Table 8.2 – Medical Record Errors
Figure 8.1 – c chart for Medical Record Errors (for comaprison with figure 8.2)
n = 10
Errors/Sample
Week c Ctr Line UCLc LCLc
Jan 10 16.30 28.41 4.19
Feb 20 16.30 28.41 4.19
Mar 15 16.30 28.41 4.19
Apr 12 16.30 28.41 4.19
May 22 16.30 28.41 4.19
Jun 21 16.30 28.41 4.19
Jul 18 16.30 28.41 4.19
Aug 16 16.30 28.41 4.19
Sep 15 16.30 28.41 4.19
Oct 14 16.30 28.41 4.19
Total 163
cbar 16.3
Figure 8.2 – u chart for Medical Record Errors
Errors/Record
Week c U Ctr Line UCLc LCLc
Jan 10 1.00 1.63 2.84 0.42
Feb 20 2.00 1.63 2.84 0.42
Mar 15 1.50 1.63 2.84 0.42
Apr 12 1.20 1.63 2.84 0.42
May 22 2.20 1.63 2.84 0.42
Jun 21 2.10 1.63 2.84 0.42
Jul 18 1.80 1.63 2.84 0.42
Aug 16 1.60 1.63 2.84 0.42
Sep 15 1.50 1.63 2.84 0.42
Oct 14 1.40 1.63 2.84 0.42
Total 163
ubar 1.63

Figure08-02

c
Ctr Line
UCLc
LCLc
Errors per Sample (n=10)
c Chart of Medical Record Errors Jan-Oct 2011

Figure08-03

U
Ctr Line
UCLc
LCLc
Errors per Medical Record
u Chart of Medical Record Errors: Jan-Oct 2011

Figure08-05

Chapter 8 - Statistical Process Control for Non-Conformities
Dec-09 Date c N n (2%) n u Ctr Line UCLu LCLu
Tuesday 1-Dec 14 300 6 6 2.33 2.48 4.41 0.55
Wednesday 2-Dec 12 295 6 6 2.00 2.48 4.41 0.55
Thursday 3-Dec 15 280 6 6 2.50 2.48 4.41 0.55
Friday 4-Dec 11 242 5 5 2.20 2.48 4.59 0.37 Figure 8.3 – u chart for Dietary Concerns
Saturday 5-Dec 12 206 4 4 3.00 2.48 4.84 0.12
Sunday 6-Dec 13 208 4 4 3.25 2.48 4.84 0.12
Monday 7-Dec 14 302 6 6 2.33 2.48 4.41 0.55
Tuesday 8-Dec 13 306 6 6 2.17 2.48 4.41 0.55
Wednesday 9-Dec 14 303 6 6 2.33 2.48 4.41 0.55
Thursday 10-Dec 12 278 6 6 2.00 2.48 4.41 0.55
Friday 11-Dec 10 238 5 5 2.00 2.48 4.59 0.37
Saturday 12-Dec 11 214 4 4 2.75 2.48 4.84 0.12
Sunday 13-Dec 13 204 4 4 3.25 2.48 4.84 0.12
Monday 14-Dec 14 299 6 6 2.33 2.48 4.41 0.55
Tuesday 15-Dec 12 302 6 6 2.00 2.48 4.41 0.55
Wednesday 16-Dec 11 298 6 6 1.83 2.48 4.41 0.55
Thursday 17-Dec 14 285 6 6 2.33 2.48 4.41 0.55
Friday 18-Dec 10 245 5 5 2.00 2.48 4.59 0.37
Saturday 19-Dec 13 229 5 5 2.60 2.48 4.59 0.37
Sunday 20-Dec 11 211 4 4 2.75 2.48 4.84 0.12
Monday 21-Dec 12 274 5 5 2.40 2.48 4.59 0.37
Tuesday 22-Dec 12 266 5 5 2.40 2.48 4.59 0.37
Wednesday 23-Dec 11 259 5 5 2.20 2.48 4.59 0.37
Thursday 24-Dec 14 286 6 6 2.33 2.48 4.41 0.55
Friday 25-Dec 20 190 4 4 5.00 2.48 4.84 0.12
Saturday 26-Dec 15 192 4 4 3.75 2.48 4.84 0.12
Sunday 27-Dec 13 199 4 4 3.25 2.48 4.84 0.12
Monday 28-Dec 9 223 4 4 2.25 2.48 4.84 0.12
Tuesday 29-Dec 11 241 5 5 2.20 2.48 4.59 0.37
Wednesday 30-Dec 12 237 5 5 2.40 2.48 4.59 0.37
Thursday 31-Dec 11 221 4 5 2.75 2.48 4.84 0.12
Total 389 157 5.00 max
ubar 2.48 1.83 min

Figure08-05

u
Ctr Line
UCLu
LCLu
Concerns per Patient
Dietary Concerns: December 2011

Figure08-06

Chapter 8 - Statistical Process Control for Non-Conformities
n = 5
Table 8.4 - AMI Treatment, Jan 2011 through August 2012
(non-conformities)
Sample Conformities c Ctr Line UCLc LCLc
2011 Jan 31 9 4 10 0 Figure 8.5 – c chart for AMI Treatment
Feb 39 1 4 10 0
Mar 37 3 4 10 0
Apr 33 7 4 10 0
May 35 5 4 10 0
Jun 35 5 4 10 0
Jul 34 6 4 10 0
Aug 37 3 4 10 0
Sep 39 1 4 10 0
Oct 35 5 4 10 0
Nov 38 2 4 10 0
Dec 34 6 4 10 0
2012 Jan 36 4 4 10 0
Feb 36 4 4 10 0
Mar 38 2 4 10 0
Apr 34 6 4 10 0
May 35 5 4 10 0
Jun 39 1 4 10 0
Jul 38 2 4 10 0 4 = 10% non-confomities
Aug 37 3 4 10 0 10 = 25% non-conformities
Average 36 4
cbar

Figure08-06

9 4 10 0
1 4 10 0
3 4 10 0
7 4 10 0
5 4 10 0
5 4 10 0
6 4 10 0
3 4 10 0
1 4 10 0
5 4 10 0
2 4 10 0
6 4 10 0
4 4 10 0
4 4 10 0
2 4 10 0
6 4 10 0
5 4 10 0
1 4 10 0
2 4 10 0
3 4 10 0
c
cl
ucl
lcl
AMI Measures Not Delivered
Medicare AMI Quality Measures

Figure08-07

Chapter 8 - Statistical Process Control for Non-Conformities
Curran et al. (2008)
Month c Ctr Line UCLc LCLc
2002 Jan 0 1.10 4.24 0.00 Figure 8.6 – Curren et al. SPC Chart
Feb 2 1.10 4.24 0.00
Mar 1 1.10 4.24 0.00
Apr 1 1.10 4.24 0.00
May 0 1.10 4.24 0.00
Jun 1 1.10 4.24 0.00
Jul 1 1.10 4.24 0.00
Aug 0 1.10 4.24 0.00
Sep 0 1.10 4.24 0.00
Oct 5 1.10 4.24 0.00
Nov 0 1.10 4.24 0.00
Dec 2 1.10 4.24 0.00
2003 Jan 0 1.10 4.24 0.00
Feb 2 1.10 4.24 0.00
Mar 0 1.10 4.24 0.00
Apr 1 1.10 4.24 0.00
May 1 1.10 4.24 0.00
Jun 1 1.10 4.24 0.00
Jul 3 1.10 4.24 0.00
Aug 3 1.10 4.24 0.00
Sep 2 1.10 4.24 0.00
Oct 0 1.10 4.24 0.00
Nov 0 1.10 4.24 0.00
Dec 1 1.10 4.24 0.00
2004 Jan 0 1.10 4.24 0.00
Feb 4 1.10 4.24 0.00
Mar 1 1.10 4.24 0.00
Apr 0 1.10 4.24 0.00
May 2 1.10 4.24 0.00
Jun 0 0.54 2.74 0.00
Jul 0 0.54 2.74 0.00
Aug 0 0.54 2.74 0.00
Sep 0 0.54 2.74 0.00
Oct 1 0.54 2.74 0.00
Nov 0 0.54 2.74 0.00
Dec 1 0.54 2.74 0.00
2005 Jan 0 0.54 2.74 0.00
Feb 1 0.54 2.74 0.00
Mar 0 0.54 2.74 0.00
Apr 0 0.54 2.74 0.00
May 1 0.54 2.74 0.00
Jun 0 0.54 2.74 0.00
Jul 0 0.54 2.74 0.00
Aug 1 0.54 2.74 0.00
Sep 0 0.54 2.74 0.00
Oct 1 0.54 2.74 0.00
Nov 1 0.54 2.74 0.00
Dec 0 0.54 2.74 0.00
2006 Jan 0 0.54 2.74 0.00
Control Limits: 2002 through 2004 Jul
34
cbar 1.10
UCLc 4.24
LCL 0
Control Limits: 2004 Jun through 2006
7
cbar 0.54
UCLc 2.74
LCL 0
Data reconstructed by the author.

Figure08-07

c
Ctr Line
UCLc
LCLc
# of MRSAs
MRSA Infection Rate: SPC + Tools

Figure08-08

Chapter 8 - Statistical Process Control for Non-Conformities
Walberg et al. (2008)
Month c Ctr Line UCLc LCLc
1999 Feb 6 6.17 13.62 0.00
Mar 4 6.17 13.62 0.00 Figure 8.7 - Walberg et al. SPC Chart
Apr 9 6.17 13.62 0.00
May 2 6.17 13.62 0.00
Jun 6 6.17 13.62 0.00
Jul 5 6.17 13.62 0.00
Aug 4 6.17 13.62 0.00
Sep 9 6.17 13.62 0.00
Oct 8 6.17 13.62 0.00
Nov 5 6.17 13.62 0.00
Dec 5 6.17 13.62 0.00
Jan 4 6.17 13.62 0.00
2000 Feb 8 6.17 13.62 0.00
Mar 10 6.17 13.62 0.00
Apr 6 6.17 13.62 0.00
May 9 6.17 13.62 0.00
Jun 5 6.17 13.62 0.00
Jul 7 6.17 13.62 0.00
Aug 3 6.17 13.62 0.00
Sep 7 6.17 13.62 0.00
Oct 4 6.17 13.62 0.00
Nov 10 6.17 13.62 0.00
Dec 6 6.17 13.62 0.00
Jan 8 6.17 13.62 0.00
2001 Feb 7 6.17 13.62 0.00
Mar 7 6.17 13.62 0.00
Apr 5 6.17 13.62 0.00
May 6 6.17 13.62 0.00
Jun 5 6.17 13.62 0.00
Jul 5 6.17 13.62 0.00
Aug 7 6.17 13.62 0.00
Sep 8 6.17 13.62 0.00
Oct 4 6.17 13.62 0.00
Nov 2 6.17 13.62 0.00
Dec 6 6.17 13.62 0.00
Jan 16 6.17 13.62 0.00
2002 Feb 5 6.17 13.62 0.00
Mar 6 6.17 13.62 0.00
Apr 3 6.17 13.62 0.00
May 6 6.17 13.62 0.00
Jun 4 6.17 13.62 0.00
Jul 6 6.17 13.62 0.00
Control Limits 1999 Feb through 2001 Jul
sum 185
count 30
cbar 6.1666666667
UCLc 13.6164988795
LCLc 0
Data reconstructed by the author.

Figure08-08

c
Ctr Line
UCLc
LCLc
# of Cases
Pseudomonas Aeruginosa Cases

Problem08-02

Chapter 8 - Statistical Process Control for Non-Conformities
Pollard and Garnerin (1999)
Month c cbar UCLc LCLc Figure 8.8 - Pollard and Garnerin SPC Charts
1994 Feb 286 315.9 369.2 262.6
Mar 359 315.9 369.2 262.6
Apr 304 315.9 369.2 262.6
May 284 315.9 369.2 262.6
Jun 337 315.9 369.2 262.6
Jul 337 315.9 369.2 262.6
Aug 333 315.9 369.2 262.6
Sep 342 315.9 369.2 262.6
Oct 299 315.9 369.2 262.6
Nov 278 315.9 369.2 262.6
Dec 303 315.9 369.2 262.6
Jan 309 315.9 369.2 262.6
1995 Feb 298 315.9 369.2 262.6
Mar 323 315.9 369.2 262.6
Apr 283 315.9 369.2 262.6
May 320 315.9 369.2 262.6
Jun 313 315.9 369.2 262.6
Jul 328 315.9 369.2 262.6
Aug 388 315.9 369.2 262.6
Sep 303 315.9 369.2 262.6
Control Limits: 1994 Feb through 1994 Nov
cbar 315.9
UCLc 369.2
LCLc 262.6
Month p pbar UCLp LCLp
1994 Feb 0.28 0.247 0.324 0.170
Mar 0.27 0.247 0.315 0.179
Apr 0.24 0.247 0.321 0.173
May 0.18 0.247 0.324 0.170
Jun 0.24 0.247 0.317 0.177
Jul 0.23 0.247 0.317 0.177
Aug 0.23 0.247 0.318 0.176
Sep 0.26 0.247 0.317 0.177
Oct 0.25 0.247 0.322 0.172
Nov 0.29 0.247 0.325 0.169
Dec 0.40 0.247 0.321 0.173
Jan 0.39 0.247 0.321 0.173
1995 Feb 0.41 0.247 0.322 0.172
Mar 0.38 0.247 0.319 0.175
Apr 0.48 0.247 0.324 0.170
May 0.45 0.247 0.319 0.175
Jun 0.52 0.247 0.320 0.174
Jul 0.48 0.247 0.318 0.176
Aug 0.51 0.247 0.313 0.181
Sep 0.50 0.247 0.321 0.173
Control Limits: 1994 Feb through 1994 Nov
pbar 0.247
Data reconstructed by the author.

Problem08-02

c
cbar
UCLc
LCLc
# of Procedures
Pollard & Garnerin c chart

Problem08-03

p
pbar
UCLp
LCLp
% O/P Procedures
Pollard & Garnerin p chart

Problem08-04

Chapter 8 - Statistical Process Control for Non-Conformities
Problem 8.2 - Medical Records Errors
n = 50
Month Errors
Jan 7
Feb 6
Mar 8
Apr 7
May 6
Jun 6
Jul 8
Aug 7
Sep 6
Oct 8
Nov 8
Dec 9
Jan 10
Feb 8
Mar 7
Apr 11
May 12
Jun 8
Jul 12
Aug 8

Problem08-05

Chapter 8 - Statistical Process Control for Non-Conformities
Problem 8.3 - Missed Oxygen Treatments
Week Missed Sample
1 11 10
2 9 10
3 7 10
4 8 10
5 6 10
6 7 10
7 8 10
8 9 10
9 6 10
10 9 10
11 7 10
12 6 10
13 6 10
14 7 10
15 9 10
16 5 10
17 7 10
18 9 10
19 12 10
20 8 10
21 8 10
22 7 10
23 4 10
24 6 10
25 6 10
26 3 10
27 5 10
28 6 10
29 5 10
30 6 10
31 5 10
32 3 10
33 4 10
34 5 10
35 6 10
36 6 10
37 7 10
38 7 10
39 8 10
40 8 10
Chapter 8 - Statistical Process Control for Non-Conformities
Problem 8.4 - Call Light Use
Month Call Lights Patients
Jan 30 10
Feb 29 10
Mar 24 10
Apr 32 10
May 35 10
Jun 28 10
Jul 26 10
Aug 23 10
Sep 22 10
Oct 29 10
Nov 31 10
Dec 36 10
Jan 32 10
Feb 27 10
Mar 26 10
Apr 19 10
May 23 10
Jun 24 10
Jul 25 10
Aug 23 10
Sep 25 10
Oct 21 10
Nov 17 10
Dec 22 10
Chapter 8 - Statistical Process Control for Non-Conformities
Problem 8.5 - Patient Satisfaction
Month n c
Jan 6 34
Feb 6 32
Mar 5 25
Apr 5 31
May 4 22
Jun 6 33
Jul 4 21
Aug 5 38
Sep 5 33
Oct 5 28
Nov 4 20
Dec 4 25
Total 59 342