Create Attribute Control Charts Chapter 7

profileericmutua44
07chapProblems.xls

Problem07-03

Chapter 7 - Statistical Process Control for Monitoring Failure Rates
Problem 7.3 - Semmelweis
Month Births Deaths Rate
Jan 1846 336 45 13.4
Feb 293 53 18.1
March 311 48 15.4
April 253 48 19.0
May 305 41 13.4
June 266 27 10.2
July 252 33 13.1
August 216 39 18.1
September 271 39 14.4
October 254 38 15.0
November 297 32 10.8
December 298 16 5.4
Jan 1847 311 10 3.2
Feb 312 6 1.9
March 305 11 3.6
April 312 57 18.3
May 294 36 12.2
June** 268 6 2.4
July 250 3 1.2
August 264 5 1.9
September 262 12 5.2
October 278 11 4.0
November 246 11 4.5
December 273 8 2.9
Jan 1848 283 10 3.5
Feb 291 2 0.7
March 276 0 0.0
April 305 2 0.7
May 313 3 1.0
June 264 3 1.1
July 269 1 0.4
August 261 0 0.0
September 312 3 1.0
October 299 7 2.3
November 310 9 2.9
December 373 5 1.3
Source: Semmelweis I, 1983, The Etiology, Concept, and Prophylaxis of Childbed Fever, The University of Wisconsin Press, Madison WI (originally published 1860) pp. 85, 90-91.

Problem07-04

Chapter 7 - Statistical Process Control for Monitoring Failure Rates
Problem 4 - Surgical Infections
Sample
Patient 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
4 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0
5 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0
8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
14 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Problem07-05

Chapter 7 - Statistical Process Control for Monitoring Failure Rates
Problem 7.5 - Readmission Rates
Month Readmits Sample
Jan 3 10
Feb 3 10
Mar 4 10
Apr 3 8
May 3 10
Jun 3 9
Jul 3 10
Aug 3 9
Sep 3 9
Oct 3 10
Nov 3 9
Dec 2 10
Jan 3 10
Feb 2 8
Mar 3 10
Apr 2 9
May 3 10
Jun 2 9
Jul 3 10
Aug 3 10
Sep 2 10
Oct 2 10
Nov 2 8
Dec 2 9