OPD
September 2024
## [1] "C:/Users/User/Documents/RStudio/OPD"##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union1 Time reference 2024
Month
Week
January
February
March
April
May
June
July
August
September
October
November
December
1-5
5-9
9-13
14-18
18-22
22-26
27-31
31-35
36-40
40-44
44-48
49-52
2 Control chart
Control charts, also known as Shewhart Charts or Statistical Process Control Charts (SPC) are tools used to determine if a process is in a state of statistical control, or how much variation exists in a process. Like run charts, they are graphs of data over time (time-series charts). Clinical Excellence Commission, Quality Improvement Tools, Control Charts
Common Causes are those that are inherent in a system over time, affecting everyone working in the system and all outcomes of that system. They indicate a stable process that is in statistical control.
Special Causes, in contrast, are not part of the system all the time, but arise because of specific circumstances, and indicate an unstable system which is not in statistical control.
The improvement approach in this case is to identify when special cause occurred and why; if positive, improvement efforts may seek to replicate that event as a part of the system, while negative special cause may be the subject of attempts to eliminate the possibility of recurrence and bring the system into statistical control.
There are five rules for identifying special cause in control charts to understand whether improvement is occurring:
- A single point outside the control limits
- Eight or more consecutive points above or below the centre
line
- Six consecutive points increasing (trend up) or decreasing (trend
down)
- Two out of three consecutive points near a control limit (outer
one-third)
- Fifteen consecutive points close to the centre line (inner one-third).
2.1 Attribute charts
Source: Quality America, Quality Improvement Tools, Control charts
2.1.1 u-chart
- for monitoring the percent of samples having the condition, relative to either a fixed or varying sample size, when each sample can have more than one instance of the condition.
2.1.2 p chart
- for monitoring the percent of samples having the condition, relative to either a fixed or varying sample size, when each sample can either have this condition, or not have this condition
3 Pareto chart
Pareto Chart is a powerful tool for showing the
relative importance of problems. It contains both bars and lines, where
individual values are represented in descending order by bars, and the
cumulative total of the sample is represented by the curved line. An
80% cut off line indicate where the 80/20 rule applies
i.e. the Vital Few factors (compared with
Trivial Many) that warrant the most attention sit under
the 80% cut off line. For many events, roughly 80% of the
effects come from 20% of the causes. Clinical
Excellence Commission, Quality Improvement Tools, Pareto
Charts
The cumulative line should be steep, with a lot
of arch to it, implying that the first few problem areas
rapidly add to a high percentage of the total problems. If the
cumulative line is straight, the contribution from each successive bar
(after the first) is about even. These bars, then, should be about the
same height. This says no problems stand out than the rest. Quality
America, Quality Improvement Tools, Pareto chart
4 Attendance
With varying No.Patients every week, u-control chart is applied. The special causes are detected when violating 2 in five rules.
Eight or more consecutive points above (week 2-11) or below (week 23-31) the centre line
Six consecutive points increasing (trend up) (week 24-30)
Pareto chart is then used to analyze the No.Attendance with other factors in those weeks.
## No. Attendances
## List of 11
## $ call : language qcc::qcc(data = df_uChart$sum, type = "u", sizes = df_uChart$size, labels = df_uChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "u"
## $ data.name : chr "df_uChart$sum"
## $ data : num [1:31, 1] 3709 5854 5753 5941 5927 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:31] 0.699 0.727 0.715 0.717 0.729 ...
## ..- attr(*, "names")= chr [1:31] "1" "2" "3" "4" ...
## $ sizes : num [1:31] 5308 8056 8048 8284 8134 ...
## $ center : num 0.714
## $ std.dev : num 0.845
## $ nsigmas : num 3
## $ limits : num [1:31, 1:2] 0.679 0.686 0.686 0.686 0.686 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"4.0.1 Attendance vs. Booking
- No.of Attendance but not booking increase significantly on week 31. This highlights the DNA (below) going up sharply in the same week.
## No. Attendance but not booking
## List of 11
## $ call : language qcc::qcc(data = df_uChart$sum, type = "u", sizes = df_uChart$size, labels = df_uChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "u"
## $ data.name : chr "df_uChart$sum"
## $ data : num [1:36, 1] 496 550 577 565 570 553 547 548 589 575 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:36] 0.1337 0.094 0.1003 0.0951 0.0962 ...
## ..- attr(*, "names")= chr [1:36] "1" "2" "3" "4" ...
## $ sizes : num [1:36] 3709 5854 5753 5941 5927 ...
## $ center : num 0.109
## $ std.dev : num 0.33
## $ nsigmas : num 3
## $ limits : num [1:36, 1:2] 0.0927 0.096 0.0959 0.0961 0.096 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"4.0.2 Attendance vs. Clinic
- No.of Clinic vary from 320 - 338 clinics between week 26 and 30. According to the Pareto Principle, 80% of Patient Attendances come from 20% of clinics as in table (narrowed down to less than 140 clinics). Among that, Clinic 850, 379 always have the most visits those weeks. Next are clinics 1522, 1555, 467, 1038 or 1499; except for week 30, clinic 1499 increases slightly more than previous weeks.
## Pareto of No. Attendance with selected weeks on Clinic Code
## Frequency table of Clinic Code W26 :
## nominalValue freq percent cum.percent
## 1 ClinicCode_850 250 4.5012604 4.501260
## 2 ClinicCode_379 87 1.5664386 6.067699
## 3 ClinicCode_1522 74 1.3323731 7.400072
## 4 ClinicCode_1555 72 1.2963630 8.696435
## 5 ClinicCode_467 66 1.1883327 9.884768
## 6 ClinicCode_1038 63 1.1343176 11.019085
## 7 ClinicCode_1175 63 1.1343176 12.153403
## 8 ClinicCode_766 61 1.0983075 13.251710
## 9 ClinicCode_493 60 1.0803025 14.332013
## 10 ClinicCode_269 57 1.0262874 15.358300
## 11 ClinicCode_1392 56 1.0082823 16.366583
## 12 ClinicCode_987 53 0.9542672 17.320850
## 13 ClinicCode_1498 52 0.9362622 18.257112
## 14 ClinicCode_546 50 0.9002521 19.157364
## 15 ClinicCode_1499 50 0.9002521 20.057616
## 16 ClinicCode_337 49 0.8822470 20.939863
## 17 ClinicCode_1132 48 0.8642420 21.804105
## 18 ClinicCode_1210 48 0.8642420 22.668347
## 19 ClinicCode_109 47 0.8462369 23.514584
## 20 ClinicCode_1171 46 0.8282319 24.342816
## 21 ClinicCode_666 44 0.7922218 25.135038
## 22 ClinicCode_785 44 0.7922218 25.927260
## 23 ClinicCode_938 44 0.7922218 26.719481
## 24 ClinicCode_1020 44 0.7922218 27.511703
## 25 ClinicCode_1029 43 0.7742168 28.285920
## 26 ClinicCode_1458 43 0.7742168 29.060137
## 27 ClinicCode_439 41 0.7382067 29.798344
## 28 ClinicCode_711 41 0.7382067 30.536550
## 29 ClinicCode_1479 41 0.7382067 31.274757
## 30 ClinicCode_293 40 0.7202017 31.994959
## 31 ClinicCode_1133 38 0.6841916 32.679150
## 32 ClinicCode_404 37 0.6661865 33.345337
## 33 ClinicCode_922 37 0.6661865 34.011523
## 34 ClinicCode_1391 37 0.6661865 34.677710
## 35 ClinicCode_1150 36 0.6481815 35.325891
## 36 ClinicCode_529 35 0.6301764 35.956068
## 37 ClinicCode_641 35 0.6301764 36.586244
## 38 ClinicCode_683 35 0.6301764 37.216421
## 39 ClinicCode_731 35 0.6301764 37.846597
## 40 ClinicCode_1243 35 0.6301764 38.476773
## 41 ClinicCode_1517 35 0.6301764 39.106950
## 42 ClinicCode_602 34 0.6121714 39.719121
## 43 ClinicCode_877 34 0.6121714 40.331293
## 44 ClinicCode_1551 34 0.6121714 40.943464
## 45 ClinicCode_233 33 0.5941664 41.537631
## 46 ClinicCode_572 33 0.5941664 42.131797
## 47 ClinicCode_713 33 0.5941664 42.725963
## 48 ClinicCode_1201 33 0.5941664 43.320130
## 49 ClinicCode_1371 33 0.5941664 43.914296
## 50 ClinicCode_1432 33 0.5941664 44.508462
## 51 ClinicCode_1341 32 0.5761613 45.084624
## 52 ClinicCode_1389 32 0.5761613 45.660785
## 53 ClinicCode_424 31 0.5581563 46.218941
## 54 ClinicCode_551 31 0.5581563 46.777098
## 55 ClinicCode_757 31 0.5581563 47.335254
## 56 ClinicCode_1324 31 0.5581563 47.893410
## 57 ClinicCode_1480 31 0.5581563 48.451566
## 58 ClinicCode_414 30 0.5401512 48.991718
## 59 ClinicCode_1124 30 0.5401512 49.531869
## 60 ClinicCode_1550 30 0.5401512 50.072020
## 61 ClinicCode_634 29 0.5221462 50.594166
## 62 ClinicCode_663 29 0.5221462 51.116313
## 63 ClinicCode_763 29 0.5221462 51.638459
## 64 ClinicCode_277 28 0.5041412 52.142600
## 65 ClinicCode_585 28 0.5041412 52.646741
## 66 ClinicCode_1005 28 0.5041412 53.150882
## 67 ClinicCode_800 27 0.4861361 53.637018
## 68 ClinicCode_1006 27 0.4861361 54.123154
## 69 ClinicCode_451 26 0.4681311 54.591286
## 70 ClinicCode_841 26 0.4681311 55.059417
## 71 ClinicCode_1113 26 0.4681311 55.527548
## 72 ClinicCode_1261 26 0.4681311 55.995679
## 73 ClinicCode_1390 26 0.4681311 56.463810
## 74 ClinicCode_507 25 0.4501260 56.913936
## 75 ClinicCode_709 25 0.4501260 57.364062
## 76 ClinicCode_814 25 0.4501260 57.814188
## 77 ClinicCode_1125 25 0.4501260 58.264314
## 78 ClinicCode_1351 25 0.4501260 58.714440
## 79 ClinicCode_1424 25 0.4501260 59.164566
## 80 ClinicCode_1447 25 0.4501260 59.614692
## 81 ClinicCode_448 24 0.4321210 60.046813
## 82 ClinicCode_472 24 0.4321210 60.478934
## 83 ClinicCode_718 24 0.4321210 60.911055
## 84 ClinicCode_849 24 0.4321210 61.343176
## 85 ClinicCode_1134 24 0.4321210 61.775297
## 86 ClinicCode_1526 24 0.4321210 62.207418
## 87 ClinicCode_874 23 0.4141160 62.621534
## 88 ClinicCode_287 22 0.3961109 63.017645
## 89 ClinicCode_456 22 0.3961109 63.413756
## 90 ClinicCode_855 22 0.3961109 63.809867
## 91 ClinicCode_927 22 0.3961109 64.205978
## 92 ClinicCode_1217 22 0.3961109 64.602089
## 93 ClinicCode_1229 22 0.3961109 64.998199
## 94 ClinicCode_1468 22 0.3961109 65.394310
## 95 ClinicCode_1576 22 0.3961109 65.790421
## 96 ClinicCode_635 21 0.3781059 66.168527
## 97 ClinicCode_883 21 0.3781059 66.546633
## 98 ClinicCode_1137 21 0.3781059 66.924739
## 99 ClinicCode_1372 21 0.3781059 67.302845
## 100 ClinicCode_925 20 0.3601008 67.662946
## 101 ClinicCode_1047 20 0.3601008 68.023046
## 102 ClinicCode_1135 20 0.3601008 68.383147
## 103 ClinicCode_1282 20 0.3601008 68.743248
## 104 ClinicCode_1445 20 0.3601008 69.103349
## 105 ClinicCode_719 19 0.3420958 69.445445
## 106 ClinicCode_919 19 0.3420958 69.787541
## 107 ClinicCode_936 19 0.3420958 70.129636
## 108 ClinicCode_1059 19 0.3420958 70.471732
## 109 ClinicCode_1117 19 0.3420958 70.813828
## 110 ClinicCode_1173 19 0.3420958 71.155924
## 111 ClinicCode_1249 19 0.3420958 71.498019
## 112 ClinicCode_1302 19 0.3420958 71.840115
## 113 ClinicCode_150 18 0.3240907 72.164206
## 114 ClinicCode_726 18 0.3240907 72.488297
## 115 ClinicCode_781 18 0.3240907 72.812387
## 116 ClinicCode_786 18 0.3240907 73.136478
## 117 ClinicCode_811 18 0.3240907 73.460569
## 118 ClinicCode_906 18 0.3240907 73.784660
## 119 ClinicCode_1204 18 0.3240907 74.108750
## 120 ClinicCode_1248 18 0.3240907 74.432841
## 121 ClinicCode_1431 18 0.3240907 74.756932
## 122 ClinicCode_408 17 0.3060857 75.063018
## 123 ClinicCode_1369 17 0.3060857 75.369103
## 124 ClinicCode_1460 17 0.3060857 75.675189
## 125 ClinicCode_1495 17 0.3060857 75.981275
## 126 ClinicCode_297 16 0.2880807 76.269355
## 127 ClinicCode_1127 16 0.2880807 76.557436
## 128 ClinicCode_1180 16 0.2880807 76.845517
## 129 ClinicCode_1306 16 0.2880807 77.133597
## 130 ClinicCode_1478 16 0.2880807 77.421678
## 131 ClinicCode_1501 16 0.2880807 77.709759
## 132 ClinicCode_625 15 0.2700756 77.979834
## 133 ClinicCode_762 15 0.2700756 78.249910
## 134 ClinicCode_816 15 0.2700756 78.519986
## 135 ClinicCode_930 15 0.2700756 78.790061
## 136 ClinicCode_979 15 0.2700756 79.060137
## 137 ClinicCode_1170 15 0.2700756 79.330212
## 138 ClinicCode_1295 15 0.2700756 79.600288
## 139 ClinicCode_1355 15 0.2700756 79.870364
## Total Value of Clinic Code W26[1] 5554
## Total Value of Clinic Code in 80% W26[1] 4436
## No.of Clinic Code W26[1] 328
## No.of Clinic Code in 80% W26[1] 139
## Frequency table of Clinic Code W27 :
## nominalValue freq percent cum.percent
## 1 ClinicCode_850 229 4.0914776 4.091478
## 2 ClinicCode_379 91 1.6258710 5.717349
## 3 ClinicCode_1522 83 1.4829373 7.200286
## 4 ClinicCode_1038 74 1.3221369 8.522423
## 5 ClinicCode_1555 67 1.1970699 9.719493
## 6 ClinicCode_493 65 1.1613364 10.880829
## 7 ClinicCode_766 64 1.1434697 12.024299
## 8 ClinicCode_1392 61 1.0898696 13.114168
## 9 ClinicCode_724 60 1.0720029 14.186171
## 10 ClinicCode_1210 58 1.0362694 15.222441
## 11 ClinicCode_932 57 1.0184027 16.240843
## 12 ClinicCode_987 56 1.0005360 17.241379
## 13 ClinicCode_1588 54 0.9648026 18.206182
## 14 ClinicCode_709 53 0.9469359 19.153118
## 15 ClinicCode_1479 53 0.9469359 20.100054
## 16 ClinicCode_1499 51 0.9112024 21.011256
## 17 ClinicCode_1458 49 0.8754690 21.886725
## 18 ClinicCode_938 48 0.8576023 22.744327
## 19 ClinicCode_1171 47 0.8397356 23.584063
## 20 ClinicCode_233 46 0.8218689 24.405932
## 21 ClinicCode_546 46 0.8218689 25.227801
## 22 ClinicCode_666 46 0.8218689 26.049669
## 23 ClinicCode_269 44 0.7861354 26.835805
## 24 ClinicCode_922 44 0.7861354 27.621940
## 25 ClinicCode_1391 44 0.7861354 28.408076
## 26 ClinicCode_757 43 0.7682687 29.176344
## 27 ClinicCode_711 42 0.7504020 29.926746
## 28 ClinicCode_1113 42 0.7504020 30.677148
## 29 ClinicCode_717 41 0.7325353 31.409684
## 30 ClinicCode_1133 41 0.7325353 32.142219
## 31 ClinicCode_268 40 0.7146686 32.856888
## 32 ClinicCode_414 39 0.6968019 33.553689
## 33 ClinicCode_1029 39 0.6968019 34.250491
## 34 ClinicCode_1517 39 0.6968019 34.947293
## 35 ClinicCode_1551 39 0.6968019 35.644095
## 36 ClinicCode_439 38 0.6789351 36.323030
## 37 ClinicCode_641 38 0.6789351 37.001965
## 38 ClinicCode_1201 38 0.6789351 37.680900
## 39 ClinicCode_1274 38 0.6789351 38.359836
## 40 ClinicCode_1351 38 0.6789351 39.038771
## 41 ClinicCode_404 37 0.6610684 39.699839
## 42 ClinicCode_859 37 0.6610684 40.360908
## 43 ClinicCode_1480 36 0.6432017 41.004109
## 44 ClinicCode_529 35 0.6253350 41.629444
## 45 ClinicCode_731 35 0.6253350 42.254779
## 46 ClinicCode_424 34 0.6074683 42.862248
## 47 ClinicCode_789 34 0.6074683 43.469716
## 48 ClinicCode_1020 34 0.6074683 44.077184
## 49 ClinicCode_369 33 0.5896016 44.666786
## 50 ClinicCode_467 33 0.5896016 45.256387
## 51 ClinicCode_1150 33 0.5896016 45.845989
## 52 ClinicCode_1433 33 0.5896016 46.435590
## 53 ClinicCode_1249 32 0.5717349 47.007325
## 54 ClinicCode_1324 32 0.5717349 47.579060
## 55 ClinicCode_1424 32 0.5717349 48.150795
## 56 ClinicCode_1369 31 0.5538681 48.704663
## 57 ClinicCode_1583 31 0.5538681 49.258531
## 58 ClinicCode_851 30 0.5360014 49.794533
## 59 ClinicCode_1481 30 0.5360014 50.330534
## 60 ClinicCode_456 29 0.5181347 50.848669
## 61 ClinicCode_507 29 0.5181347 51.366804
## 62 ClinicCode_800 29 0.5181347 51.884938
## 63 ClinicCode_337 28 0.5002680 52.385206
## 64 ClinicCode_712 28 0.5002680 52.885474
## 65 ClinicCode_929 28 0.5002680 53.385742
## 66 ClinicCode_551 27 0.4824013 53.868144
## 67 ClinicCode_585 26 0.4645346 54.332678
## 68 ClinicCode_1006 26 0.4645346 54.797213
## 69 ClinicCode_1341 26 0.4645346 55.261747
## 70 ClinicCode_1550 26 0.4645346 55.726282
## 71 ClinicCode_1591 26 0.4645346 56.190817
## 72 ClinicCode_293 25 0.4466679 56.637484
## 73 ClinicCode_806 25 0.4466679 57.084152
## 74 ClinicCode_1047 25 0.4466679 57.530820
## 75 ClinicCode_1134 25 0.4466679 57.977488
## 76 ClinicCode_1243 25 0.4466679 58.424156
## 77 ClinicCode_1282 25 0.4466679 58.870824
## 78 ClinicCode_1371 25 0.4466679 59.317492
## 79 ClinicCode_277 24 0.4288011 59.746293
## 80 ClinicCode_287 24 0.4288011 60.175094
## 81 ClinicCode_786 24 0.4288011 60.603895
## 82 ClinicCode_1419 24 0.4288011 61.032696
## 83 ClinicCode_1526 24 0.4288011 61.461497
## 84 ClinicCode_814 23 0.4109344 61.872432
## 85 ClinicCode_841 23 0.4109344 62.283366
## 86 ClinicCode_1005 23 0.4109344 62.694301
## 87 ClinicCode_1124 23 0.4109344 63.105235
## 88 ClinicCode_1390 23 0.4109344 63.516169
## 89 ClinicCode_150 22 0.3930677 63.909237
## 90 ClinicCode_718 22 0.3930677 64.302305
## 91 ClinicCode_927 22 0.3930677 64.695373
## 92 ClinicCode_936 22 0.3930677 65.088440
## 93 ClinicCode_1350 22 0.3930677 65.481508
## 94 ClinicCode_1389 22 0.3930677 65.874576
## 95 ClinicCode_1402 22 0.3930677 66.267643
## 96 ClinicCode_472 21 0.3752010 66.642844
## 97 ClinicCode_602 21 0.3752010 67.018045
## 98 ClinicCode_672 21 0.3752010 67.393246
## 99 ClinicCode_1175 21 0.3752010 67.768447
## 100 ClinicCode_1180 21 0.3752010 68.143648
## 101 ClinicCode_1445 21 0.3752010 68.518849
## 102 ClinicCode_1495 21 0.3752010 68.894050
## 103 ClinicCode_625 20 0.3573343 69.251385
## 104 ClinicCode_635 20 0.3573343 69.608719
## 105 ClinicCode_761 20 0.3573343 69.966053
## 106 ClinicCode_1248 20 0.3573343 70.323388
## 107 ClinicCode_1306 20 0.3573343 70.680722
## 108 ClinicCode_906 19 0.3394676 71.020189
## 109 ClinicCode_1447 19 0.3394676 71.359657
## 110 ClinicCode_1570 19 0.3394676 71.699125
## 111 ClinicCode_1576 19 0.3394676 72.038592
## 112 ClinicCode_726 18 0.3216009 72.360193
## 113 ClinicCode_765 18 0.3216009 72.681794
## 114 ClinicCode_919 18 0.3216009 73.003395
## 115 ClinicCode_1125 18 0.3216009 73.324996
## 116 ClinicCode_1127 18 0.3216009 73.646596
## 117 ClinicCode_1135 18 0.3216009 73.968197
## 118 ClinicCode_1229 18 0.3216009 74.289798
## 119 ClinicCode_408 17 0.3037341 74.593532
## 120 ClinicCode_448 17 0.3037341 74.897266
## 121 ClinicCode_550 17 0.3037341 75.201001
## 122 ClinicCode_979 17 0.3037341 75.504735
## 123 ClinicCode_1218 17 0.3037341 75.808469
## 124 ClinicCode_1484 17 0.3037341 76.112203
## 125 ClinicCode_320 16 0.2858674 76.398070
## 126 ClinicCode_650 16 0.2858674 76.683938
## 127 ClinicCode_715 16 0.2858674 76.969805
## 128 ClinicCode_874 16 0.2858674 77.255673
## 129 ClinicCode_925 16 0.2858674 77.541540
## 130 ClinicCode_930 16 0.2858674 77.827408
## 131 ClinicCode_1195 16 0.2858674 78.113275
## 132 ClinicCode_1355 16 0.2858674 78.399142
## 133 ClinicCode_1504 16 0.2858674 78.685010
## 134 ClinicCode_1452 15 0.2680007 78.953011
## 135 ClinicCode_698 14 0.2501340 79.203145
## 136 ClinicCode_710 14 0.2501340 79.453279
## 137 ClinicCode_1079 14 0.2501340 79.703413
## 138 ClinicCode_1148 14 0.2501340 79.953547
## Total Value of Clinic Code W27[1] 5597
## Total Value of Clinic Code in 80% W27[1] 4475
## No.of Clinic Code W27[1] 338
## No.of Clinic Code in 80% W27[1] 138
## Frequency table of Clinic Code W28 :
## nominalValue freq percent cum.percent
## 1 ClinicCode_850 234 4.2154567 4.215457
## 2 ClinicCode_379 90 1.6213295 5.836786
## 3 ClinicCode_1499 85 1.5312556 7.368042
## 4 ClinicCode_1549 85 1.5312556 8.899297
## 5 ClinicCode_1038 76 1.3691227 10.268420
## 6 ClinicCode_766 67 1.2069897 11.475410
## 7 ClinicCode_493 66 1.1889750 12.664385
## 8 ClinicCode_1498 65 1.1709602 13.835345
## 9 ClinicCode_467 64 1.1529454 14.988290
## 10 ClinicCode_1392 64 1.1529454 16.141236
## 11 ClinicCode_1555 61 1.0989011 17.240137
## 12 ClinicCode_1576 60 1.0808863 18.321023
## 13 ClinicCode_1588 60 1.0808863 19.401910
## 14 ClinicCode_709 56 1.0088272 20.410737
## 15 ClinicCode_269 53 0.9547829 21.365520
## 16 ClinicCode_938 53 0.9547829 22.320303
## 17 ClinicCode_718 52 0.9367681 23.257071
## 18 ClinicCode_1006 51 0.9187534 24.175824
## 19 ClinicCode_546 49 0.8827238 25.058548
## 20 ClinicCode_1522 48 0.8647091 25.923257
## 21 ClinicCode_987 47 0.8466943 26.769951
## 22 ClinicCode_1133 47 0.8466943 27.616646
## 23 ClinicCode_666 46 0.8286795 28.445325
## 24 ClinicCode_717 45 0.8106647 29.255990
## 25 ClinicCode_1171 45 0.8106647 30.066655
## 26 ClinicCode_883 44 0.7926500 30.859305
## 27 ClinicCode_439 43 0.7746352 31.633940
## 28 ClinicCode_1020 42 0.7566204 32.390560
## 29 ClinicCode_1029 42 0.7566204 33.147181
## 30 ClinicCode_1324 42 0.7566204 33.903801
## 31 ClinicCode_1458 40 0.7205909 34.624392
## 32 ClinicCode_109 39 0.7025761 35.326968
## 33 ClinicCode_711 39 0.7025761 36.029544
## 34 ClinicCode_922 39 0.7025761 36.732120
## 35 ClinicCode_1517 39 0.7025761 37.434696
## 36 ClinicCode_408 38 0.6845613 38.119258
## 37 ClinicCode_1180 38 0.6845613 38.803819
## 38 ClinicCode_414 37 0.6665466 39.470366
## 39 ClinicCode_1351 37 0.6665466 40.136912
## 40 ClinicCode_855 35 0.6305170 40.767429
## 41 ClinicCode_1150 35 0.6305170 41.397946
## 42 ClinicCode_1391 35 0.6305170 42.028463
## 43 ClinicCode_1113 34 0.6125023 42.640966
## 44 ClinicCode_1248 34 0.6125023 43.253468
## 45 ClinicCode_811 33 0.5944875 43.847955
## 46 ClinicCode_1550 33 0.5944875 44.442443
## 47 ClinicCode_404 32 0.5764727 45.018916
## 48 ClinicCode_731 32 0.5764727 45.595388
## 49 ClinicCode_1175 32 0.5764727 46.171861
## 50 ClinicCode_1245 32 0.5764727 46.748334
## 51 ClinicCode_233 31 0.5584579 47.306792
## 52 ClinicCode_337 31 0.5584579 47.865250
## 53 ClinicCode_424 31 0.5584579 48.423707
## 54 ClinicCode_585 31 0.5584579 48.982165
## 55 ClinicCode_757 31 0.5584579 49.540623
## 56 ClinicCode_641 30 0.5404432 50.081066
## 57 ClinicCode_800 30 0.5404432 50.621510
## 58 ClinicCode_1432 30 0.5404432 51.161953
## 59 ClinicCode_1480 30 0.5404432 51.702396
## 60 ClinicCode_1066 29 0.5224284 52.224824
## 61 ClinicCode_1479 29 0.5224284 52.747253
## 62 ClinicCode_150 28 0.5044136 53.251666
## 63 ClinicCode_602 28 0.5044136 53.756080
## 64 ClinicCode_1389 28 0.5044136 54.260494
## 65 ClinicCode_1481 28 0.5044136 54.764907
## 66 ClinicCode_277 27 0.4863988 55.251306
## 67 ClinicCode_478 27 0.4863988 55.737705
## 68 ClinicCode_634 27 0.4863988 56.224104
## 69 ClinicCode_1447 27 0.4863988 56.710503
## 70 ClinicCode_1590 27 0.4863988 57.196901
## 71 ClinicCode_1591 27 0.4863988 57.683300
## 72 ClinicCode_293 26 0.4683841 58.151684
## 73 ClinicCode_529 26 0.4683841 58.620068
## 74 ClinicCode_765 26 0.4683841 59.088453
## 75 ClinicCode_1137 26 0.4683841 59.556837
## 76 ClinicCode_1201 26 0.4683841 60.025221
## 77 ClinicCode_320 25 0.4503693 60.475590
## 78 ClinicCode_930 25 0.4503693 60.925959
## 79 ClinicCode_1369 25 0.4503693 61.376329
## 80 ClinicCode_713 24 0.4323545 61.808683
## 81 ClinicCode_1125 24 0.4323545 62.241038
## 82 ClinicCode_1282 23 0.4143398 62.655377
## 83 ClinicCode_1341 23 0.4143398 63.069717
## 84 ClinicCode_1445 23 0.4143398 63.484057
## 85 ClinicCode_1460 23 0.4143398 63.898397
## 86 ClinicCode_1495 23 0.4143398 64.312736
## 87 ClinicCode_551 22 0.3963250 64.709061
## 88 ClinicCode_1583 22 0.3963250 65.105386
## 89 ClinicCode_650 21 0.3783102 65.483697
## 90 ClinicCode_786 21 0.3783102 65.862007
## 91 ClinicCode_814 21 0.3783102 66.240317
## 92 ClinicCode_841 21 0.3783102 66.618627
## 93 ClinicCode_1390 21 0.3783102 66.996937
## 94 ClinicCode_1431 21 0.3783102 67.375248
## 95 ClinicCode_1506 21 0.3783102 67.753558
## 96 ClinicCode_1551 21 0.3783102 68.131868
## 97 ClinicCode_456 20 0.3602954 68.492164
## 98 ClinicCode_726 20 0.3602954 68.852459
## 99 ClinicCode_785 20 0.3602954 69.212754
## 100 ClinicCode_849 20 0.3602954 69.573050
## 101 ClinicCode_979 20 0.3602954 69.933345
## 102 ClinicCode_1134 20 0.3602954 70.293641
## 103 ClinicCode_1229 20 0.3602954 70.653936
## 104 ClinicCode_1338 20 0.3602954 71.014232
## 105 ClinicCode_1371 20 0.3602954 71.374527
## 106 ClinicCode_1526 20 0.3602954 71.734823
## 107 ClinicCode_472 19 0.3422807 72.077103
## 108 ClinicCode_816 19 0.3422807 72.419384
## 109 ClinicCode_1005 19 0.3422807 72.761665
## 110 ClinicCode_1173 19 0.3422807 73.103945
## 111 ClinicCode_1274 19 0.3422807 73.446226
## 112 ClinicCode_1491 19 0.3422807 73.788507
## 113 ClinicCode_625 18 0.3242659 74.112772
## 114 ClinicCode_1124 18 0.3242659 74.437038
## 115 ClinicCode_1448 18 0.3242659 74.761304
## 116 ClinicCode_1452 18 0.3242659 75.085570
## 117 ClinicCode_416 17 0.3062511 75.391821
## 118 ClinicCode_635 17 0.3062511 75.698072
## 119 ClinicCode_1355 17 0.3062511 76.004324
## 120 ClinicCode_1402 17 0.3062511 76.310575
## 121 ClinicCode_507 16 0.2882364 76.598811
## 122 ClinicCode_710 16 0.2882364 76.887047
## 123 ClinicCode_1283 16 0.2882364 77.175284
## 124 ClinicCode_1306 16 0.2882364 77.463520
## 125 ClinicCode_1350 16 0.2882364 77.751756
## 126 ClinicCode_1570 16 0.2882364 78.039993
## 127 ClinicCode_630 15 0.2702216 78.310214
## 128 ClinicCode_761 15 0.2702216 78.580436
## 129 ClinicCode_763 15 0.2702216 78.850658
## 130 ClinicCode_874 15 0.2702216 79.120879
## 131 ClinicCode_907 15 0.2702216 79.391101
## 132 ClinicCode_927 15 0.2702216 79.661322
## 133 ClinicCode_1372 15 0.2702216 79.931544
## Total Value of Clinic Code W28[1] 5551
## Total Value of Clinic Code in 80% W28[1] 4437
## No.of Clinic Code W28[1] 320
## No.of Clinic Code in 80% W28[1] 133
## Frequency table of Clinic Code W29 :
## nominalValue freq percent cum.percent
## 1 ClinicCode_850 229 4.0495137 4.049514
## 2 ClinicCode_379 85 1.5030946 5.552608
## 3 ClinicCode_467 81 1.4323607 6.984969
## 4 ClinicCode_1499 79 1.3969938 8.381963
## 5 ClinicCode_1038 73 1.2908930 9.672856
## 6 ClinicCode_1555 69 1.2201592 10.893015
## 7 ClinicCode_493 68 1.2024757 12.095491
## 8 ClinicCode_1588 66 1.1671088 13.262599
## 9 ClinicCode_766 64 1.1317418 14.394341
## 10 ClinicCode_1392 58 1.0256410 15.419982
## 11 ClinicCode_1479 57 1.0079576 16.427940
## 12 ClinicCode_1522 55 0.9725906 17.400531
## 13 ClinicCode_933 54 0.9549072 18.355438
## 14 ClinicCode_1576 52 0.9195402 19.274978
## 15 ClinicCode_233 50 0.8841733 20.159151
## 16 ClinicCode_546 50 0.8841733 21.043324
## 17 ClinicCode_717 48 0.8488064 21.892131
## 18 ClinicCode_724 47 0.8311229 22.723254
## 19 ClinicCode_790 47 0.8311229 23.554377
## 20 ClinicCode_1006 47 0.8311229 24.385500
## 21 ClinicCode_1550 47 0.8311229 25.216622
## 22 ClinicCode_987 46 0.8134394 26.030062
## 23 ClinicCode_1458 46 0.8134394 26.843501
## 24 ClinicCode_1517 46 0.8134394 27.656941
## 25 ClinicCode_666 45 0.7957560 28.452697
## 26 ClinicCode_109 44 0.7780725 29.230769
## 27 ClinicCode_268 43 0.7603890 29.991158
## 28 ClinicCode_439 43 0.7603890 30.751547
## 29 ClinicCode_718 42 0.7427056 31.494253
## 30 ClinicCode_1020 42 0.7427056 32.236958
## 31 ClinicCode_1591 42 0.7427056 32.979664
## 32 ClinicCode_293 41 0.7250221 33.704686
## 33 ClinicCode_709 41 0.7250221 34.429708
## 34 ClinicCode_711 41 0.7250221 35.154730
## 35 ClinicCode_859 41 0.7250221 35.879752
## 36 ClinicCode_404 40 0.7073386 36.587091
## 37 ClinicCode_1171 40 0.7073386 37.294430
## 38 ClinicCode_938 39 0.6896552 37.984085
## 39 ClinicCode_1113 39 0.6896552 38.673740
## 40 ClinicCode_408 38 0.6719717 39.345712
## 41 ClinicCode_585 38 0.6719717 40.017683
## 42 ClinicCode_922 38 0.6719717 40.689655
## 43 ClinicCode_1029 38 0.6719717 41.361627
## 44 ClinicCode_641 37 0.6542882 42.015915
## 45 ClinicCode_1324 37 0.6542882 42.670203
## 46 ClinicCode_414 36 0.6366048 43.306808
## 47 ClinicCode_369 35 0.6189213 43.925729
## 48 ClinicCode_731 35 0.6189213 44.544651
## 49 ClinicCode_800 35 0.6189213 45.163572
## 50 ClinicCode_269 34 0.6012378 45.764810
## 51 ClinicCode_337 34 0.6012378 46.366048
## 52 ClinicCode_1210 34 0.6012378 46.967286
## 53 ClinicCode_785 33 0.5835544 47.550840
## 54 ClinicCode_1245 33 0.5835544 48.134394
## 55 ClinicCode_1351 32 0.5658709 48.700265
## 56 ClinicCode_529 30 0.5305040 49.230769
## 57 ClinicCode_602 30 0.5305040 49.761273
## 58 ClinicCode_1150 30 0.5305040 50.291777
## 59 ClinicCode_1274 30 0.5305040 50.822281
## 60 ClinicCode_1371 30 0.5305040 51.352785
## 61 ClinicCode_712 29 0.5128205 51.865606
## 62 ClinicCode_929 29 0.5128205 52.378426
## 63 ClinicCode_1067 29 0.5128205 52.891247
## 64 ClinicCode_1369 29 0.5128205 53.404067
## 65 ClinicCode_1390 29 0.5128205 53.916888
## 66 ClinicCode_1480 29 0.5128205 54.429708
## 67 ClinicCode_1590 29 0.5128205 54.942529
## 68 ClinicCode_1133 28 0.4951370 55.437666
## 69 ClinicCode_1432 28 0.4951370 55.932803
## 70 ClinicCode_1583 28 0.4951370 56.427940
## 71 ClinicCode_277 27 0.4774536 56.905393
## 72 ClinicCode_551 27 0.4774536 57.382847
## 73 ClinicCode_686 27 0.4774536 57.860301
## 74 ClinicCode_855 27 0.4774536 58.337754
## 75 ClinicCode_1341 27 0.4774536 58.815208
## 76 ClinicCode_1249 26 0.4597701 59.274978
## 77 ClinicCode_1282 26 0.4597701 59.734748
## 78 ClinicCode_1372 26 0.4597701 60.194518
## 79 ClinicCode_1402 26 0.4597701 60.654288
## 80 ClinicCode_456 25 0.4420866 61.096375
## 81 ClinicCode_634 25 0.4420866 61.538462
## 82 ClinicCode_1005 25 0.4420866 61.980548
## 83 ClinicCode_1135 25 0.4420866 62.422635
## 84 ClinicCode_1243 25 0.4420866 62.864721
## 85 ClinicCode_1248 25 0.4420866 63.306808
## 86 ClinicCode_287 24 0.4244032 63.731211
## 87 ClinicCode_763 24 0.4244032 64.155615
## 88 ClinicCode_930 24 0.4244032 64.580018
## 89 ClinicCode_1261 24 0.4244032 65.004421
## 90 ClinicCode_1445 23 0.4067197 65.411141
## 91 ClinicCode_1551 23 0.4067197 65.817860
## 92 ClinicCode_761 22 0.3890363 66.206897
## 93 ClinicCode_1229 22 0.3890363 66.595933
## 94 ClinicCode_806 21 0.3713528 66.967286
## 95 ClinicCode_1173 21 0.3713528 67.338638
## 96 ClinicCode_1338 21 0.3713528 67.709991
## 97 ClinicCode_726 20 0.3536693 68.063660
## 98 ClinicCode_1125 20 0.3536693 68.417330
## 99 ClinicCode_1389 20 0.3536693 68.770999
## 100 ClinicCode_1501 20 0.3536693 69.124668
## 101 ClinicCode_765 19 0.3359859 69.460654
## 102 ClinicCode_786 19 0.3359859 69.796640
## 103 ClinicCode_816 19 0.3359859 70.132626
## 104 ClinicCode_979 19 0.3359859 70.468612
## 105 ClinicCode_1059 19 0.3359859 70.804598
## 106 ClinicCode_1066 19 0.3359859 71.140584
## 107 ClinicCode_1350 19 0.3359859 71.476569
## 108 ClinicCode_1391 19 0.3359859 71.812555
## 109 ClinicCode_1447 19 0.3359859 72.148541
## 110 ClinicCode_290 18 0.3183024 72.466844
## 111 ClinicCode_472 18 0.3183024 72.785146
## 112 ClinicCode_649 18 0.3183024 73.103448
## 113 ClinicCode_814 18 0.3183024 73.421751
## 114 ClinicCode_1175 18 0.3183024 73.740053
## 115 ClinicCode_1306 18 0.3183024 74.058355
## 116 ClinicCode_1506 18 0.3183024 74.376658
## 117 ClinicCode_1526 18 0.3183024 74.694960
## 118 ClinicCode_547 17 0.3006189 74.995579
## 119 ClinicCode_663 17 0.3006189 75.296198
## 120 ClinicCode_1124 17 0.3006189 75.596817
## 121 ClinicCode_1127 17 0.3006189 75.897436
## 122 ClinicCode_1203 17 0.3006189 76.198055
## 123 ClinicCode_1283 17 0.3006189 76.498674
## 124 ClinicCode_1355 17 0.3006189 76.799293
## 125 ClinicCode_550 16 0.2829355 77.082228
## 126 ClinicCode_762 16 0.2829355 77.365164
## 127 ClinicCode_907 16 0.2829355 77.648099
## 128 ClinicCode_919 16 0.2829355 77.931034
## 129 ClinicCode_1148 16 0.2829355 78.213970
## 130 ClinicCode_1180 16 0.2829355 78.496905
## 131 ClinicCode_1204 16 0.2829355 78.779841
## 132 ClinicCode_418 15 0.2652520 79.045093
## 133 ClinicCode_424 15 0.2652520 79.310345
## 134 ClinicCode_625 15 0.2652520 79.575597
## 135 ClinicCode_1078 15 0.2652520 79.840849
## Total Value of Clinic Code W29[1] 5655
## Total Value of Clinic Code in 80% W29[1] 4515
## No.of Clinic Code W29[1] 333
## No.of Clinic Code in 80% W29[1] 135
## Frequency table of Clinic Code W30 :
## nominalValue freq percent cum.percent
## 1 ClinicCode_850 252 4.3106398 4.310640
## 2 ClinicCode_1499 95 1.6250428 5.935683
## 3 ClinicCode_379 79 1.3513514 7.287034
## 4 ClinicCode_1555 76 1.3000342 8.587068
## 5 ClinicCode_493 72 1.2316114 9.818679
## 6 ClinicCode_1588 69 1.1802942 10.998974
## 7 ClinicCode_938 67 1.1460828 12.145056
## 8 ClinicCode_766 66 1.1289771 13.274034
## 9 ClinicCode_1392 62 1.0605542 14.334588
## 10 ClinicCode_666 56 0.9579199 15.292508
## 11 ClinicCode_717 56 0.9579199 16.250428
## 12 ClinicCode_1132 56 0.9579199 17.208348
## 13 ClinicCode_467 55 0.9408142 18.149162
## 14 ClinicCode_883 54 0.9237085 19.072870
## 15 ClinicCode_1038 54 0.9237085 19.996579
## 16 ClinicCode_404 50 0.8552857 20.851865
## 17 ClinicCode_546 50 0.8552857 21.707150
## 18 ClinicCode_1066 50 0.8552857 22.562436
## 19 ClinicCode_709 49 0.8381800 23.400616
## 20 ClinicCode_789 49 0.8381800 24.238796
## 21 ClinicCode_1522 47 0.8039685 25.042764
## 22 ClinicCode_408 46 0.7868628 25.829627
## 23 ClinicCode_529 46 0.7868628 26.616490
## 24 ClinicCode_1020 46 0.7868628 27.403353
## 25 ClinicCode_1458 46 0.7868628 28.190216
## 26 ClinicCode_1006 45 0.7697571 28.959973
## 27 ClinicCode_1133 44 0.7526514 29.712624
## 28 ClinicCode_987 43 0.7355457 30.448170
## 29 ClinicCode_1391 43 0.7355457 31.183715
## 30 ClinicCode_1591 43 0.7355457 31.919261
## 31 ClinicCode_109 42 0.7184400 32.637701
## 32 ClinicCode_233 42 0.7184400 33.356141
## 33 ClinicCode_922 42 0.7184400 34.074581
## 34 ClinicCode_1576 42 0.7184400 34.793021
## 35 ClinicCode_337 41 0.7013342 35.494355
## 36 ClinicCode_585 39 0.6671228 36.161478
## 37 ClinicCode_731 39 0.6671228 36.828601
## 38 ClinicCode_1210 39 0.6671228 37.495724
## 39 ClinicCode_1341 39 0.6671228 38.162846
## 40 ClinicCode_293 37 0.6329114 38.795758
## 41 ClinicCode_711 37 0.6329114 39.428669
## 42 ClinicCode_269 36 0.6158057 40.044475
## 43 ClinicCode_1248 36 0.6158057 40.660281
## 44 ClinicCode_414 35 0.5987000 41.258980
## 45 ClinicCode_439 35 0.5987000 41.857680
## 46 ClinicCode_1201 35 0.5987000 42.456380
## 47 ClinicCode_1550 35 0.5987000 43.055080
## 48 ClinicCode_369 34 0.5815943 43.636675
## 49 ClinicCode_1029 34 0.5815943 44.218269
## 50 ClinicCode_1171 34 0.5815943 44.799863
## 51 ClinicCode_785 33 0.5644885 45.364352
## 52 ClinicCode_930 33 0.5644885 45.928840
## 53 ClinicCode_1324 33 0.5644885 46.493329
## 54 ClinicCode_1432 33 0.5644885 47.057817
## 55 ClinicCode_641 32 0.5473828 47.605200
## 56 ClinicCode_800 32 0.5473828 48.152583
## 57 ClinicCode_1249 32 0.5473828 48.699966
## 58 ClinicCode_405 31 0.5302771 49.230243
## 59 ClinicCode_507 31 0.5302771 49.760520
## 60 ClinicCode_1282 31 0.5302771 50.290797
## 61 ClinicCode_478 30 0.5131714 50.803969
## 62 ClinicCode_277 29 0.4960657 51.300034
## 63 ClinicCode_634 29 0.4960657 51.796100
## 64 ClinicCode_1137 29 0.4960657 52.292166
## 65 ClinicCode_1150 29 0.4960657 52.788231
## 66 ClinicCode_1479 29 0.4960657 53.284297
## 67 ClinicCode_424 28 0.4789600 53.763257
## 68 ClinicCode_663 28 0.4789600 54.242217
## 69 ClinicCode_1175 28 0.4789600 54.721177
## 70 ClinicCode_287 27 0.4618543 55.183031
## 71 ClinicCode_1351 27 0.4618543 55.644885
## 72 ClinicCode_456 26 0.4447485 56.089634
## 73 ClinicCode_713 26 0.4447485 56.534382
## 74 ClinicCode_763 26 0.4447485 56.979131
## 75 ClinicCode_814 26 0.4447485 57.423880
## 76 ClinicCode_1047 26 0.4447485 57.868628
## 77 ClinicCode_1245 26 0.4447485 58.313377
## 78 ClinicCode_1369 26 0.4447485 58.758125
## 79 ClinicCode_1402 26 0.4447485 59.202874
## 80 ClinicCode_1447 26 0.4447485 59.647622
## 81 ClinicCode_1590 26 0.4447485 60.092371
## 82 ClinicCode_602 25 0.4276428 60.520014
## 83 ClinicCode_718 25 0.4276428 60.947657
## 84 ClinicCode_1134 25 0.4276428 61.375299
## 85 ClinicCode_1229 25 0.4276428 61.802942
## 86 ClinicCode_1517 25 0.4276428 62.230585
## 87 ClinicCode_1583 25 0.4276428 62.658228
## 88 ClinicCode_635 24 0.4105371 63.068765
## 89 ClinicCode_811 24 0.4105371 63.479302
## 90 ClinicCode_816 24 0.4105371 63.889839
## 91 ClinicCode_1114 24 0.4105371 64.300376
## 92 ClinicCode_1371 24 0.4105371 64.710913
## 93 ClinicCode_1516 24 0.4105371 65.121451
## 94 ClinicCode_874 23 0.3934314 65.514882
## 95 ClinicCode_1372 23 0.3934314 65.908313
## 96 ClinicCode_1495 23 0.3934314 66.301745
## 97 ClinicCode_849 22 0.3763257 66.678070
## 98 ClinicCode_907 22 0.3763257 67.054396
## 99 ClinicCode_927 22 0.3763257 67.430722
## 100 ClinicCode_1480 22 0.3763257 67.807048
## 101 ClinicCode_1506 22 0.3763257 68.183373
## 102 ClinicCode_1526 22 0.3763257 68.559699
## 103 ClinicCode_786 21 0.3592200 68.918919
## 104 ClinicCode_1243 21 0.3592200 69.278139
## 105 ClinicCode_1261 21 0.3592200 69.637359
## 106 ClinicCode_1445 21 0.3592200 69.996579
## 107 ClinicCode_719 20 0.3421143 70.338693
## 108 ClinicCode_919 20 0.3421143 70.680807
## 109 ClinicCode_1005 20 0.3421143 71.022922
## 110 ClinicCode_1390 20 0.3421143 71.365036
## 111 ClinicCode_625 19 0.3250086 71.690044
## 112 ClinicCode_762 19 0.3250086 72.015053
## 113 ClinicCode_1059 19 0.3250086 72.340062
## 114 ClinicCode_1113 19 0.3250086 72.665070
## 115 ClinicCode_1389 19 0.3250086 72.990079
## 116 ClinicCode_1570 19 0.3250086 73.315087
## 117 ClinicCode_550 18 0.3079028 73.622990
## 118 ClinicCode_551 18 0.3079028 73.930893
## 119 ClinicCode_855 18 0.3079028 74.238796
## 120 ClinicCode_925 18 0.3079028 74.546699
## 121 ClinicCode_1180 18 0.3079028 74.854601
## 122 ClinicCode_1355 18 0.3079028 75.162504
## 123 ClinicCode_1476 18 0.3079028 75.470407
## 124 ClinicCode_1551 18 0.3079028 75.778310
## 125 ClinicCode_279 17 0.2907971 76.069107
## 126 ClinicCode_297 17 0.2907971 76.359904
## 127 ClinicCode_649 17 0.2907971 76.650701
## 128 ClinicCode_1125 17 0.2907971 76.941498
## 129 ClinicCode_1127 17 0.2907971 77.232296
## 130 ClinicCode_1504 17 0.2907971 77.523093
## 131 ClinicCode_472 16 0.2736914 77.796784
## 132 ClinicCode_781 16 0.2736914 78.070476
## 133 ClinicCode_782 16 0.2736914 78.344167
## 134 ClinicCode_906 16 0.2736914 78.617858
## 135 ClinicCode_1148 16 0.2736914 78.891550
## 136 ClinicCode_1173 16 0.2736914 79.165241
## 137 ClinicCode_1338 16 0.2736914 79.438933
## 138 ClinicCode_1451 16 0.2736914 79.712624
## 139 ClinicCode_726 15 0.2565857 79.969210
## Total Value of Clinic Code W30[1] 5846
## Total Value of Clinic Code in 80% W30[1] 4675
## No.of Clinic Code W30[1] 338
## No.of Clinic Code in 80% W30[1] 1394.0.3 Attendance vs. Specialty
- Ophthamology, Haematology, Cardiology, Infectious Diseases, Orthopaedics are the top 5 specialties having the high OP Visits. According to the Pareto Principle, 80% of Patient Attendances come from 20% of Specialties as in table (narrowed down from 31 to 14 specialties).
## Pareto of No. Attendance with selected weeks on Specialty Mater
## Frequency table of Specialty Mater W26 :
## nominalValue freq percent cum.percent
## 1 SpecMater_Ophthalmology 765 13.773857 13.77386
## 2 SpecMater_Haematology 462 8.318329 22.09219
## 3 SpecMater_Cardiology 445 8.012243 30.10443
## 4 SpecMater_Infectious Diseases 395 7.111991 37.21642
## 5 SpecMater_Orthopaedics 373 6.715880 43.93230
## 6 SpecMater_Endocrinology 272 4.897371 48.82967
## 7 SpecMater_Urology 255 4.591286 53.42096
## 8 SpecMater_General Surgery: Breast 239 4.303205 57.72416
## 9 SpecMater_Respiratory Medicine 213 3.835074 61.55924
## 10 SpecMater_Gastro-Enterology 210 3.781059 65.34030
## 11 SpecMater_Oncology 195 3.510983 68.85128
## 12 SpecMater_Dermatology 184 3.312928 72.16421
## 13 SpecMater_Nephrology 175 3.150882 75.31509
## 14 SpecMater_Neurology 155 2.790781 78.10587
## Total Value of Specialty Mater W26[1] 5554
## Total Value of Specialty Mater in 80% W26[1] 4338
## No.of Specialty Mater W26[1] 32
## No.of Specialty Mater in 80% W26[1] 14
## Frequency table of Specialty Mater W27 :
## nominalValue freq percent cum.percent
## 1 SpecMater_Ophthalmology 784 14.007504 14.00750
## 2 SpecMater_Haematology 499 8.915490 22.92299
## 3 SpecMater_Infectious Diseases 395 7.057352 29.98035
## 4 SpecMater_Cardiology 347 6.199750 36.18010
## 5 SpecMater_Orthopaedics 334 5.967483 42.14758
## 6 SpecMater_General Surgery: Breast 281 5.020547 47.16813
## 7 SpecMater_Urology 281 5.020547 52.18867
## 8 SpecMater_Endocrinology 256 4.573879 56.76255
## 9 SpecMater_Gastro-Enterology 254 4.538145 61.30070
## 10 SpecMater_Dermatology 209 3.734143 65.03484
## 11 SpecMater_Respiratory Medicine 197 3.519743 68.55458
## 12 SpecMater_Rheumatology 181 3.233875 71.78846
## 13 SpecMater_Oncology 171 3.055208 74.84367
## 14 SpecMater_Nephrology 167 2.983741 77.82741
## Total Value of Specialty Mater W27[1] 5597
## Total Value of Specialty Mater in 80% W27[1] 4356
## No.of Specialty Mater W27[1] 31
## No.of Specialty Mater in 80% W27[1] 14
## Frequency table of Specialty Mater W28 :
## nominalValue freq percent cum.percent
## 1 SpecMater_Ophthalmology 775 13.961448 13.96145
## 2 SpecMater_Haematology 487 8.773194 22.73464
## 3 SpecMater_Orthopaedics 417 7.512160 30.24680
## 4 SpecMater_Cardiology 410 7.386057 37.63286
## 5 SpecMater_Infectious Diseases 376 6.773554 44.40641
## 6 SpecMater_Urology 293 5.278328 49.68474
## 7 SpecMater_General Surgery: Breast 289 5.206269 54.89101
## 8 SpecMater_Dermatology 255 4.593767 59.48478
## 9 SpecMater_Endocrinology 206 3.711043 63.19582
## 10 SpecMater_Gastro-Enterology 195 3.512881 66.70870
## 11 SpecMater_Oncology 183 3.296703 70.00540
## 12 SpecMater_Nephrology 167 3.008467 73.01387
## 13 SpecMater_Neurology 156 2.810304 75.82418
## 14 SpecMater_Rheumatology 142 2.558098 78.38227
## Total Value of Specialty Mater W28[1] 5551
## Total Value of Specialty Mater in 80% W28[1] 4351
## No.of Specialty Mater W28[1] 31
## No.of Specialty Mater in 80% W28[1] 14
## Frequency table of Specialty Mater W29 :
## nominalValue freq percent cum.percent
## 1 SpecMater_Ophthalmology 817 14.447392 14.44739
## 2 SpecMater_Haematology 477 8.435013 22.88240
## 3 SpecMater_Cardiology 454 8.028294 30.91070
## 4 SpecMater_Infectious Diseases 382 6.755084 37.66578
## 5 SpecMater_Orthopaedics 361 6.383731 44.04951
## 6 SpecMater_Urology 293 5.181256 49.23077
## 7 SpecMater_Endocrinology 276 4.880637 54.11141
## 8 SpecMater_Rheumatology 227 4.014147 58.12555
## 9 SpecMater_Plastic Surgery 186 3.289125 61.41468
## 10 SpecMater_Dermatology 185 3.271441 64.68612
## 11 SpecMater_Respiratory Medicine 185 3.271441 67.95756
## 12 SpecMater_General Surgery: Breast 180 3.183024 71.14058
## 13 SpecMater_Gastro-Enterology 173 3.059240 74.19982
## 14 SpecMater_Nephrology 173 3.059240 77.25906
## Total Value of Specialty Mater W29[1] 5655
## Total Value of Specialty Mater in 80% W29[1] 4369
## No.of Specialty Mater W29[1] 31
## No.of Specialty Mater in 80% W29[1] 14
## Frequency table of Specialty Mater W30 :
## nominalValue freq percent cum.percent
## 1 SpecMater_Ophthalmology 812 13.889839 13.88984
## 2 SpecMater_Haematology 514 8.792337 22.68218
## 3 SpecMater_Cardiology 443 7.577831 30.26001
## 4 SpecMater_Infectious Diseases 419 7.167294 37.42730
## 5 SpecMater_Orthopaedics 357 6.106740 43.53404
## 6 SpecMater_Urology 283 4.840917 48.37496
## 7 SpecMater_Endocrinology 270 4.618543 52.99350
## 8 SpecMater_General Surgery: Breast 235 4.019843 57.01334
## 9 SpecMater_Rheumatology 235 4.019843 61.03319
## 10 SpecMater_Gastro-Enterology 217 3.711940 64.74512
## 11 SpecMater_Respiratory Medicine 196 3.352720 68.09784
## 12 SpecMater_Dermatology 195 3.335614 71.43346
## 13 SpecMater_Nephrology 176 3.010606 74.44406
## 14 SpecMater_Oncology 173 2.959288 77.40335
## Total Value of Specialty Mater W30[1] 5846
## Total Value of Specialty Mater in 80% W30[1] 4525
## No.of Specialty Mater W30[1] 31
## No.of Specialty Mater in 80% W30[1] 144.1 Virtual Attendance
- No.Virtual Attendances: Week 20 increases out of control limit. Week 21, 25 drops out of control limit.
## No. Virtual Attendances
## List of 11
## $ call : language qcc::qcc(data = df_uChart$sum, type = "u", sizes = df_uChart$size, labels = df_uChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "u"
## $ data.name : chr "df_uChart$sum"
## $ data : num [1:31, 1] 463 728 744 782 785 653 767 802 795 818 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:31] 0.0872 0.0904 0.0924 0.0944 0.0965 ...
## ..- attr(*, "names")= chr [1:31] "1" "2" "3" "4" ...
## $ sizes : num [1:31] 5308 8056 8048 8284 8134 ...
## $ center : num 0.0964
## $ std.dev : num 0.31
## $ nsigmas : num 3
## $ limits : num [1:31, 1:2] 0.0836 0.086 0.086 0.0861 0.086 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"4.2 New Attendance
- No.New Attendances: Week 14 drops out of control limit. Week 22 increases out of control limit.
## No. New Attendances
## List of 11
## $ call : language qcc::qcc(data = df_uChart$sum, type = "u", sizes = df_uChart$size, labels = df_uChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "u"
## $ data.name : chr "df_uChart$sum"
## $ data : num [1:31, 1] 893 1470 1424 1556 1564 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:31] 0.168 0.182 0.177 0.188 0.192 ...
## ..- attr(*, "names")= chr [1:31] "1" "2" "3" "4" ...
## $ sizes : num [1:31] 5308 8056 8048 8284 8134 ...
## $ center : num 0.181
## $ std.dev : num 0.425
## $ nsigmas : num 3
## $ limits : num [1:31, 1:2] 0.164 0.167 0.167 0.167 0.167 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"4.3 Return Attendance
- No.Return Attendances: Week 17 increases out of control limit.
## No. Return Attendances
## List of 11
## $ call : language qcc::qcc(data = df_uChart$sum, type = "u", sizes = df_uChart$size, labels = df_uChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "u"
## $ data.name : chr "df_uChart$sum"
## $ data : num [1:31, 1] 2816 4384 4329 4385 4363 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:31] 0.531 0.544 0.538 0.529 0.536 ...
## ..- attr(*, "names")= chr [1:31] "1" "2" "3" "4" ...
## $ sizes : num [1:31] 5308 8056 8048 8284 8134 ...
## $ center : num 0.533
## $ std.dev : num 0.73
## $ nsigmas : num 3
## $ limits : num [1:31, 1:2] 0.503 0.509 0.509 0.509 0.509 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"5 Do not attend (DNAs)
With unequal subgroup size of classification DNAs, p-control chart is applied. In the percentage of DNA, the special cause is detected when violating 1 in five rules.
- A single point outside the control limits week 31.
## Percent. DNAs
## List of 11
## $ call : language qcc::qcc(data = df_pChart$per, type = "p", sizes = df_pChart$size, labels = df_pChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "p"
## $ data.name : chr "df_pChart$per"
## $ data : num [1:31, 1] 13.4 13 12.9 12.5 12.5 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:31] 0.00252 0.00161 0.0016 0.00151 0.00154 ...
## ..- attr(*, "names")= chr [1:31] "1" "2" "3" "4" ...
## $ sizes : num [1:31] 5308 8056 8048 8284 8134 ...
## $ center : num 0.00162
## $ std.dev : num 0.0403
## $ nsigmas : num 3
## $ limits : num [1:31, 1:2] 0 0.000278 0.000277 0.000296 0.000284 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"5.1 DNA vs. Booking Type
- According to the Pareto Principle, 80% of DNAs come from Return Patient.
## No. DNA with bookings## Pareto of No. DNA with selected weeks on Booking Type
## Frequency table of Booking Type W31 :
## nominalValue freq percent cum.percent
## 1 BookingTypeDNA_R : RETURN 2309 64.89601 64.89601## `geom_line()`: Each group consists of only one observation.
## ℹ Do you need to adjust the group aesthetic?
## Total Value of Booking Type W31[1] 3558
## Total Value of Booking Type in 80% W31[1] 2309
## No.of Booking Type W31[1] 7
## No.of Booking Type in 80% W31[1] 15.2 DNA vs. Clinic
5.2.1 Clinic Code
- As clinic 850 has the highest Attendances, so as DNAs. Following is clinic 724 and 1020. According to the Pareto Principle, roughly 80% of Patient Attendances come from “Vital Few” Clinics as in table (narrowed down from 322 to 102 clinics).
## Pareto of No. DNA with selected weeks on Clinic Code
## Frequency table of Clinic Code W31 :
## nominalValue freq percent cum.percent
## 1 ClinicCodeDNA_850 169 4.7498595 4.749859
## 2 ClinicCodeDNA_724 64 1.7987634 6.548623
## 3 ClinicCodeDNA_1020 63 1.7706577 8.319280
## 4 ClinicCodeDNA_337 57 1.6020236 9.921304
## 5 ClinicCodeDNA_1499 56 1.5739179 11.495222
## 6 ClinicCodeDNA_666 54 1.5177066 13.012929
## 7 ClinicCodeDNA_766 51 1.4333895 14.446318
## 8 ClinicCodeDNA_467 50 1.4052839 15.851602
## 9 ClinicCodeDNA_546 50 1.4052839 17.256886
## 10 ClinicCodeDNA_987 49 1.3771782 18.634064
## 11 ClinicCodeDNA_1576 48 1.3490725 19.983137
## 12 ClinicCodeDNA_717 47 1.3209668 21.304103
## 13 ClinicCodeDNA_268 46 1.2928612 22.596965
## 14 ClinicCodeDNA_1351 45 1.2647555 23.861720
## 15 ClinicCodeDNA_938 44 1.2366498 25.098370
## 16 ClinicCodeDNA_731 43 1.2085441 26.306914
## 17 ClinicCodeDNA_1549 41 1.1523328 27.459247
## 18 ClinicCodeDNA_1583 41 1.1523328 28.611580
## 19 ClinicCodeDNA_709 40 1.1242271 29.735807
## 20 ClinicCodeDNA_1201 40 1.1242271 30.860034
## 21 ClinicCodeDNA_1006 39 1.0961214 31.956155
## 22 ClinicCodeDNA_1282 39 1.0961214 33.052277
## 23 ClinicCodeDNA_1392 39 1.0961214 34.148398
## 24 ClinicCodeDNA_293 38 1.0680157 35.216414
## 25 ClinicCodeDNA_785 37 1.0399101 36.256324
## 26 ClinicCodeDNA_1274 36 1.0118044 37.268128
## 27 ClinicCodeDNA_456 34 0.9555930 38.223721
## 28 ClinicCodeDNA_635 33 0.9274874 39.151209
## 29 ClinicCodeDNA_1047 32 0.8993817 40.050590
## 30 ClinicCodeDNA_277 31 0.8712760 40.921866
## 31 ClinicCodeDNA_634 31 0.8712760 41.793142
## 32 ClinicCodeDNA_424 30 0.8431703 42.636313
## 33 ClinicCodeDNA_602 30 0.8431703 43.479483
## 34 ClinicCodeDNA_1113 30 0.8431703 44.322653
## 35 ClinicCodeDNA_641 28 0.7869590 45.109612
## 36 ClinicCodeDNA_718 28 0.7869590 45.896571
## 37 ClinicCodeDNA_763 28 0.7869590 46.683530
## 38 ClinicCodeDNA_1038 27 0.7588533 47.442383
## 39 ClinicCodeDNA_1175 27 0.7588533 48.201237
## 40 ClinicCodeDNA_269 26 0.7307476 48.931984
## 41 ClinicCodeDNA_1555 26 0.7307476 49.662732
## 42 ClinicCodeDNA_320 25 0.7026419 50.365374
## 43 ClinicCodeDNA_906 25 0.7026419 51.068016
## 44 ClinicCodeDNA_1117 25 0.7026419 51.770658
## 45 ClinicCodeDNA_1195 25 0.7026419 52.473300
## 46 ClinicCodeDNA_1369 25 0.7026419 53.175942
## 47 ClinicCodeDNA_404 24 0.6745363 53.850478
## 48 ClinicCodeDNA_800 24 0.6745363 54.525014
## 49 ClinicCodeDNA_979 24 0.6745363 55.199550
## 50 ClinicCodeDNA_1180 24 0.6745363 55.874087
## 51 ClinicCodeDNA_379 23 0.6464306 56.520517
## 52 ClinicCodeDNA_816 23 0.6464306 57.166948
## 53 ClinicCodeDNA_1550 23 0.6464306 57.813378
## 54 ClinicCodeDNA_472 22 0.6183249 58.431703
## 55 ClinicCodeDNA_1419 22 0.6183249 59.050028
## 56 ClinicCodeDNA_1458 22 0.6183249 59.668353
## 57 ClinicCodeDNA_1480 22 0.6183249 60.286678
## 58 ClinicCodeDNA_1591 22 0.6183249 60.905003
## 59 ClinicCodeDNA_150 21 0.5902192 61.495222
## 60 ClinicCodeDNA_493 21 0.5902192 62.085441
## 61 ClinicCodeDNA_1218 21 0.5902192 62.675660
## 62 ClinicCodeDNA_1481 21 0.5902192 63.265880
## 63 ClinicCodeDNA_414 20 0.5621135 63.827993
## 64 ClinicCodeDNA_786 20 0.5621135 64.390107
## 65 ClinicCodeDNA_932 20 0.5621135 64.952220
## 66 ClinicCodeDNA_1350 20 0.5621135 65.514334
## 67 ClinicCodeDNA_290 19 0.5340079 66.048342
## 68 ClinicCodeDNA_547 19 0.5340079 66.582350
## 69 ClinicCodeDNA_1078 19 0.5340079 67.116358
## 70 ClinicCodeDNA_1468 19 0.5340079 67.650365
## 71 ClinicCodeDNA_1452 18 0.5059022 68.156268
## 72 ClinicCodeDNA_448 17 0.4777965 68.634064
## 73 ClinicCodeDNA_761 17 0.4777965 69.111861
## 74 ClinicCodeDNA_1504 17 0.4777965 69.589657
## 75 ClinicCodeDNA_927 16 0.4496908 70.039348
## 76 ClinicCodeDNA_1204 16 0.4496908 70.489039
## 77 ClinicCodeDNA_787 15 0.4215852 70.910624
## 78 ClinicCodeDNA_1338 15 0.4215852 71.332209
## 79 ClinicCodeDNA_1479 15 0.4215852 71.753794
## 80 ClinicCodeDNA_314 14 0.3934795 72.147274
## 81 ClinicCodeDNA_929 14 0.3934795 72.540753
## 82 ClinicCodeDNA_1059 14 0.3934795 72.934233
## 83 ClinicCodeDNA_1249 14 0.3934795 73.327712
## 84 ClinicCodeDNA_1324 14 0.3934795 73.721192
## 85 ClinicCodeDNA_1389 14 0.3934795 74.114671
## 86 ClinicCodeDNA_874 13 0.3653738 74.480045
## 87 ClinicCodeDNA_1171 13 0.3653738 74.845419
## 88 ClinicCodeDNA_1390 13 0.3653738 75.210793
## 89 ClinicCodeDNA_1491 13 0.3653738 75.576166
## 90 ClinicCodeDNA_373 12 0.3372681 75.913435
## 91 ClinicCodeDNA_544 12 0.3372681 76.250703
## 92 ClinicCodeDNA_870 12 0.3372681 76.587971
## 93 ClinicCodeDNA_1150 12 0.3372681 76.925239
## 94 ClinicCodeDNA_1402 12 0.3372681 77.262507
## 95 ClinicCodeDNA_1447 12 0.3372681 77.599775
## 96 ClinicCodeDNA_1501 12 0.3372681 77.937043
## 97 ClinicCodeDNA_538 11 0.3091625 78.246206
## 98 ClinicCodeDNA_908 11 0.3091625 78.555368
## 99 ClinicCodeDNA_1121 11 0.3091625 78.864531
## 100 ClinicCodeDNA_1124 11 0.3091625 79.173693
## 101 ClinicCodeDNA_1210 11 0.3091625 79.482856
## 102 ClinicCodeDNA_1248 11 0.3091625 79.792018
## Total Value of Clinic Code W31[1] 3558
## Total Value of Clinic Code in 80% W31[1] 2839
## No.of Clinic Code W31[1] 322
## No.of Clinic Code in 80% W31[1] 1025.2.2 Clinic Type
- General Type has the highest No.of DNA, then Anti-Coagulation and Retina. According to the Pareto Principle, 80% of Patient Attendances come from “Vital Few” Clinic Types as in table (narrowed down from 139 to 27 Clinic Types).
## Pareto of No. DNA with selected weeks on Clinic Type
## Frequency table of Clinic Type W31 :
## nominalValue freq percent cum.percent
## 1 ClinicType_GEN : GENERAL 1639 46.0652052 46.06521
## 2 ClinicType_ACC : ANTI-COAGULATION CLINIC 169 4.7498595 50.81506
## 3 ClinicType_RET : RETINA CLINIC 108 3.0354132 53.85048
## 4 ClinicType_SBC : SYMPTOMATIC BREAST CLINIC 64 1.7987634 55.64924
## 5 ClinicType_MED : MEDICAL 61 1.7144463 57.36369
## 6 ClinicType_DRT : DIABETIC RETINA TREATMENT 59 1.6582350 59.02192
## 7 ClinicType_STW : SELF TESTING WARFARIN 51 1.4333895 60.45531
## 8 ClinicType_HFC : HUMPHREY FIELD 50 1.4052839 61.86060
## 9 ClinicType_PST : PREVENTATIVE SUPPORT CLINIC 48 1.3490725 63.20967
## 10 ClinicType_DSC : EYE SPECIALIST CLINIC 47 1.3209668 64.53064
## 11 ClinicType_VRC : VIRTUAL REVIEW CLINIC 41 1.1523328 65.68297
## 12 ClinicType_END : ENDOCRINOLOGY 40 1.1242271 66.80720
## 13 ClinicType_STD : STI CNS INFECTIOUS NURSE CLIN 39 1.0961214 67.90332
## 14 ClinicType_ANP : ADVANCED NURSE PRACTITIONER 38 1.0680157 68.97133
## 15 ClinicType_PRE : PRE. OP. ASSESSMENT CLINIC 37 1.0399101 70.01124
## 16 ClinicType_CON : CONGENITAL HEART DISEASE 36 1.0118044 71.02305
## 17 ClinicType_GNS : NURSE SPECIALIST CLINIC 31 0.8712760 71.89432
## 18 ClinicType_LIV : LIVER CLINIC 31 0.8712760 72.76560
## 19 ClinicType_RAP : RAPID ACCESS CLINIC 30 0.8431703 73.60877
## 20 ClinicType_VIR : VIRTUAL CLINIC 29 0.8150646 74.42383
## 21 ClinicType_NHF : NURSE HEART FAILURE CLINIC 28 0.7869590 75.21079
## 22 ClinicType_GOG : GYNAE ONCOLOGY GROUP REVIEW 27 0.7588533 75.96965
## 23 ClinicType_SPN : SPINAL CLINIC 27 0.7588533 76.72850
## 24 ClinicType_JNT : JOINT CLINIC 26 0.7307476 77.45925
## 25 ClinicType_FSC : FAMILY SCREENING CLINIC 25 0.7026419 78.16189
## 26 ClinicType_MSC : MULTIPLE SCLEROSIS 25 0.7026419 78.86453
## 27 ClinicType_POD : PODIATRY 25 0.7026419 79.56717
## Total Value of Clinic Type W31[1] 3558
## Total Value of Clinic Type in 80% W31[1] 2831
## No.of Clinic Type W31[1] 139
## No.of Clinic Type in 80% W31[1] 275.3 DNA vs. Specialty
- As Ophthamology, Haematology, Cardiology and Infectious Diseases have high Attendances, so as high DNAs. According to the Pareto Principle, 80% of No.of DNAs come from 20% of Specialties as in table (narrowed down from 29 to 14 specialties).
## Pareto of No. DNA with selected weeks on Specialty Mater
## Frequency table of Specialty Mater W31 :
## nominalValue freq percent cum.percent
## 1 SpecMater_Ophthalmology 507 14.249578 14.24958
## 2 SpecMater_Haematology 362 10.174255 24.42383
## 3 SpecMater_Cardiology 251 7.054525 31.47836
## 4 SpecMater_Infectious Diseases 238 6.689151 38.16751
## 5 SpecMater_Endocrinology 197 5.536818 43.70433
## 6 SpecMater_Orthopaedics 193 5.424396 49.12872
## 7 SpecMater_Dermatology 183 5.143339 54.27206
## 8 SpecMater_Gastro-Enterology 146 4.103429 58.37549
## 9 SpecMater_General Surgery: Breast 132 3.709949 62.08544
## 10 SpecMater_Urology 124 3.485104 65.57055
## 11 SpecMater_Respiratory Medicine 121 3.400787 68.97133
## 12 SpecMater_Neurology 120 3.372681 72.34401
## 13 SpecMater_Oncology 110 3.091625 75.43564
## 14 SpecMater_Otolaryngology (ENT) 109 3.063519 78.49916
## Total Value of Specialty Mater W31[1] 3558
## Total Value of Specialty Mater in 80% W31[1] 2793
## No.of Specialty Mater W31[1] 29
## No.of Specialty Mater in 80% W31[1] 146 Cancellations
6.1 Cancellations No.
With the count of CNAs in varying No.Patients weekly, u-control chart
is applied.
No.CNAs Covid Hospital: in control limit.
No.CNAs Covid Patient: The special causes are detected when violating
3 in five rules. - A single point outside the control limits (week
3, 27-29).
- Eight or more consecutive points below (week 10-25)
the centre line
- Six consecutive points decreasing (trend down) (week
27-31)
## No. CNAs Covid Hospital
## List of 11
## $ call : language qcc::qcc(data = df_uChart$sum, type = "u", sizes = df_uChart$size, labels = df_uChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "u"
## $ data.name : chr "df_uChart$sum"
## $ data : num [1:6, 1] 2 1 1 9 8 4
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:6] 0.000249 0.000121 0.000125 0.001143 0.001004 ...
## ..- attr(*, "names")= chr [1:6] "3" "9" "27" "28" ...
## $ sizes : num [1:6] 8048 8260 7998 7872 7967 ...
## $ center : num 0.000517
## $ std.dev : num 0.0227
## $ nsigmas : num 3
## $ limits : num [1:6, 1:2] 0 0 0 0 0 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"## No. CNAs Covid Patient
## List of 11
## $ call : language qcc::qcc(data = df_uChart$sum, type = "u", sizes = df_uChart$size, labels = df_uChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "u"
## $ data.name : chr "df_uChart$sum"
## $ data : num [1:29, 1] 6 19 25 7 7 11 11 8 13 3 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:29] 0.00113 0.002358 0.003106 0.000845 0.000861 ...
## ..- attr(*, "names")= chr [1:29] "1" "2" "3" "4" ...
## $ sizes : num [1:29] 5308 8056 8048 8284 8134 ...
## $ center : num 0.00123
## $ std.dev : num 0.0351
## $ nsigmas : num 3
## $ limits : num [1:29, 1:2] 0.00 5.84e-05 5.79e-05 7.47e-05 6.41e-05 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"6.2 Cancellations rate
With unequal subgroup size of classification CNAs, p-control chart is applied:
Percent.CNAs: in control limit
Percent.CNAs Hosital: in control limit
Percent.CNAs Patient: in control limit
Percent.CNAs Other: in control limit
## Percent. CNAs
## List of 11
## $ call : language qcc::qcc(data = df_pChart$per, type = "p", sizes = df_pChart$size, labels = df_pChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "p"
## $ data.name : chr "df_pChart$per"
## $ data : num [1:31, 1] 29.6 29.3 30.9 30.5 28.3 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:31] 0.00558 0.00364 0.00384 0.00368 0.00347 ...
## ..- attr(*, "names")= chr [1:31] "1" "2" "3" "4" ...
## $ sizes : num [1:31] 5308 8056 8048 8284 8134 ...
## $ center : num 0.00398
## $ std.dev : num 0.0629
## $ nsigmas : num 3
## $ limits : num [1:31, 1:2] 0.00139 0.00187 0.00187 0.0019 0.00188 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"## Percent. CNAs Hospital
## List of 11
## $ call : language qcc::qcc(data = df_pChart$per, type = "p", sizes = df_pChart$size, labels = df_pChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "p"
## $ data.name : chr "df_pChart$per"
## $ data : num [1:31, 1] 13.7 15.8 16.2 17 15.3 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:31] 0.00258 0.00196 0.00201 0.00205 0.00188 ...
## ..- attr(*, "names")= chr [1:31] "1" "2" "3" "4" ...
## $ sizes : num [1:31] 5308 8056 8048 8284 8134 ...
## $ center : num 0.00226
## $ std.dev : num 0.0475
## $ nsigmas : num 3
## $ limits : num [1:31, 1:2] 0.000303 0.000671 0.00067 0.000693 0.000679 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"## Percent. CNAs Patient
## List of 11
## $ call : language qcc::qcc(data = df_pChart$per, type = "p", sizes = df_pChart$size, labels = df_pChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "p"
## $ data.name : chr "df_pChart$per"
## $ data : num [1:31, 1] 11.4 10.7 11.5 10.4 10.2 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:31] 0.00215 0.00133 0.00143 0.00125 0.00126 ...
## ..- attr(*, "names")= chr [1:31] "1" "2" "3" "4" ...
## $ sizes : num [1:31] 5308 8056 8048 8284 8134 ...
## $ center : num 0.00135
## $ std.dev : num 0.0368
## $ nsigmas : num 3
## $ limits : num [1:31, 1:2] 0 0.000124 0.000124 0.000141 0.00013 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"## Percent. CNAs Other
## List of 11
## $ call : language qcc::qcc(data = df_pChart$per, type = "p", sizes = df_pChart$size, labels = df_pChart$timeUnit, plot = T, ax| __truncated__
## $ type : chr "p"
## $ data.name : chr "df_pChart$per"
## $ data : num [1:31, 1] 1.66 1.48 2.03 2.05 1.72 ...
## ..- attr(*, "dimnames")=List of 2
## $ statistics: Named num [1:31] 0.000312 0.000183 0.000252 0.000248 0.000212 ...
## ..- attr(*, "names")= chr [1:31] "1" "2" "3" "4" ...
## $ sizes : num [1:31] 5308 8056 8048 8284 8134 ...
## $ center : num 0.000225
## $ std.dev : num 0.015
## $ nsigmas : num 3
## $ limits : num [1:31, 1:2] 0 0 0 0 0 0 0 0 0 0 ...
## ..- attr(*, "dimnames")=List of 2
## $ violations:List of 2
## - attr(*, "class")= chr "qcc"