Number of Number of
Month/ Numerator Denominator
Year Cases Cases
1/2004 5 696
2/2004 4 669
3/2004 6 586
4/2004 5 568
5/2004 3 564
6/2004 6 647
7/2004 11 765
8/2004 3 649
9/2004 4 588
10/2004 7 818
11/2004 9 725
12/2004 11 651
1/2005 6 672
2/2005 6 583
3/2005 3 590
4/2005 6 797
5/2005 4 816
6/2005 9 709
7/2005 5 733
8/2005 8 831
9/2005 6 613
10/2005 5 608
11/2005 4 634
12/2005 8 703
Instructions
1. Select cells A1:C25 using your mouse
2. Click on Control Chart Wizard - Answer Yes or Run u Chart
3. Review the u chart - no red points means it's stable
u Char
4. Click on another worksheet and run another u chart
5. Open your own data and run Control Charts (SPC) - u Chart
Practic
and
Applicati
Chart
ractice
and
plication
Manufacturing
Roll Nonconformities 50 Sq Total Sq
Number in Dyed Cloth Meters Meters Verified and Validated using Montgomery, Intro to SPC, 4th Ed., pgs.
R1 14 10 500 To order this book from [Link] go to:
R2 12 8 400 [Link]
R3 20 13 650
R4 11 10 500
R5 7 9.5 475
R6 10 10 500
R7 21 12 600
R8 16 10.5 525
R9 19 12 600
R10 23 12.5 625
Page 4
Manufacturing
Pinholes
in Enamel Subgroup
y, Intro to SPC, 4th Ed., pgs. 320-321 Wire Size Guide to Quality Control (Ishikawa)
4 1
IN/0471316482/quantuicom-20 5 1
3 1
3 1
5 1
2 1.3
5 1.3
3 1.3
2 1.3
1 1.3
5 1.3
2 1.3
4 1.3
2 1.3
6 1.2
4 1.2
0 1.2
8 1.7
3 1.7
8 1.7
Page 5
Oryx
Number of Number of Observed Number of Number of Observed
Month/ Numerator Denominator Rate Month/ Numerator Denominator Rate
Year Cases Cases (XmR) Year Cases Cases (XmR)
1/2004 5 696 0.0071839 1/2004 7 5132 0.001364
2/2004 4 669 0.0059791 2/2004 7 4696 0.0014906
3/2004 6 586 0.0102389 3/2004 14 5043 0.0027761
4/2004 5 568 0.0088028 4/2004 6 4941 0.0012143
5/2004 3 564 0.0053191 5/2004 4 5038 0.000794
6/2004 6 647 0.0092736 6/2004 9 4818 0.001868
7/2004 11 765 0.0143791 7/2004 23 4888 0.0047054
8/2004 3 649 0.0046225 8/2004 17 4941 0.0034406
9/2004 4 588 0.0068027 9/2004 15 4973 0.0030163
10/2004 7 818 0.0085575 10/2004 15 5392 0.0027819
11/2004 9 725 0.0124138 11/2004 7 5067 0.0013815
12/2004 11 651 0.0168971 12/2004 18 5070 0.0035503
1/2005 6 672 0.0089286 1/2005 18 5128 0.0035101
2/2005 6 583 0.0102916 2/2005 7 4862 0.0014397
3/2005 3 590 0.0050847 3/2005 8 5419 0.0014763
4/2005 6 797 0.0075282 4/2005 12 5112 0.0023474
5/2005 4 816 0.004902 5/2005 11 5285 0.0020814
6/2005 9 709 0.0126939 6/2005 8 5071 0.0015776
7/2005 5 733 0.0068213 7/2005 12 5325 0.0022535
8/2005 8 831 0.009627 8/2005 5 5278 0.0009473
9/2005 6 613 0.0097879 9/2005 10 5106 0.0019585
10/2005 5 608 0.0082237 10/2005 10 5193 0.0019257
11/2005 4 634 0.0063091 11/2005 12 4964 0.0024174
12/2005 8 703 0.0113798 12/2005 7 5016 0.0013955
Page 6
Oryx
Number of Number of Observed Number of Number of Observed
Month/ Numerator Denominator Rate Month/ Numerator Denominator Rate
Year Cases Cases (XmR) Year Cases Cases (XmR)
1/2004 0 55 0 1/2004 10 1174 0.0085179
2/2004 3 61 0.0491803 2/2004 3 1228 0.002443
3/2004 1 63 0.015873 3/2004 10 1239 0.008071
4/2004 4 64 0.0625 4/2004 2 1292 0.001548
5/2004 1 56 0.0178571 5/2004 1 1255 0.0007968
6/2004 4 59 0.0677966 6/2004 7 1169 0.005988
7/2004 7 51 0.1372549 7/2004 1 1255 0.0007968
8/2004 5 59 0.0847458 8/2004 3 1152 0.0026042
9/2004 1 57 0.0175439 9/2004 5 1266 0.0039494
10/2004 5 62 0.0806452 10/2004 6 1230 0.004878
11/2004 3 59 0.0508475 11/2004 7 1063 0.0065851
12/2004 6 56 0.1071429 12/2004 18 1169 0.0153978
1/2005 4 57 0.0701754 1/2005 8 1396 0.0057307
2/2005 2 63 0.031746 2/2005 8 1166 0.0068611
3/2005 5 55 0.0909091 3/2005 6 1207 0.004971
4/2005 3 62 0.0483871 4/2005 7 1203 0.0058188
5/2005 7 64 0.109375 5/2005 18 1403 0.0128297
6/2005 7 57 0.122807 6/2005 14 1211 0.0115607
7/2005 7 54 0.1296296 7/2005 12 1142 0.0105079
8/2005 6 56 0.1071429 8/2005 4 1179 0.0033927
9/2005 9 60 0.15 9/2005 6 1200 0.005
10/2005 7 64 0.109375 10/2005 2 1129 0.0017715
11/2005 13 61 0.2131148 11/2005 4 1145 0.0034934
12/2005 6 63 0.0952381 12/2005 8 1049 0.0076263
Page 7
Total Total
Patient Patient
Month Falls Days
Jun-11 17 4658
Jul-11 22 4909
Aug-11 23 4886
Sep-11 30 4970
Oct-11 22 4780
Nov-11 18 4973
Dec-11 44 5762
Jan-12 42 5441
Feb-12 33 5893
Mar-12 33 5743
Apr-12 33 4747
May-12 27 5118
Jun-12 42 5609
Jul-12 41 5722
Aug-12 24 5261
Sep-12 22 6071
Oct-12 50 6072
Nov-12 51 5335
Dec-12 39 6483
Jan-13 22 5752
Feb-13 31 5731
Mar-13 33 5017
Apr-13 25 5158
May-13 22 5040
Jun-13 22 5095
Jul-13 22 5586
Aug-13 20 5086
Sep-13 23 5148
Oct-13 19 4754
Hospital Days Per Million Member Days Building Continual Improvement - Donald J Wheeler
Month Hospital Days Million Member Days Member Days Hosp Rate/MMD (XmR)
Jan 656 2.865 2864648 229.0
Feb 620 2.726 2725604 227.5
Mar 681 2.972 2972063 229.1
Apr 681 3.000 3000390 227.0
May 660 3.102 3102449 212.7
Jun 731 3.126 3125700 233.9
Jul 694 3.367 3366972 206.1
Aug 695 3.381 3381294 205.5
Sep 683 3.362 3362310 203.1
Oct 729 3.406 3406373 214.0
Nov 715 3.481 3480510 205.4
Dec 743 3.657 3657287 203.2
Jan 762 3.589 3589304 212.3
Feb 735 3.372 3371676 218.0
Mar 780 3.834 3833863 203.5
Apr 737 3.668 3667800 200.9
May 770 3.918 3917966 196.5
Jun 727 3.774 3773580 192.7
Jul 784 4.006 4006316 195.7
Aug 839 4.122 4121853 203.5
Sep 779 3.978 3978360 195.8
Oct 853 4.183 4182985 203.9
Nov 804 4.137 4137480 194.3
Dec 832 4.366 4365730 190.6
nt - Donald J Wheeler