Statistical Methods - Text Mining Techniques for Healthcare Provider Quality Determination - page 147

Table 17. Predicted versus actual mortality by hospital (given as percent)

Hospital Actual Mortality Predicted Mortality

1 1.23 15.08

2 0 0

3 4.46 25.89

4 0.79 11.86

5 1.14 15.91

6 0.57 16.00

7 3.53 26.15

8 2.22 20.00

9 1.28 15.38

10 3.13 16,67

Table 18. Length of stay and total charges by procedure

Principal procedure N Obs Variable Mean Std Dev Minimum Maximum

3610 8 TOTCHG

LOS

65496.75
5.8750000

20519.46
1.3562027

39277.00
3.0000000

99584.00
7.0000000

3611 5112 TOTCHG

LOS

90656.52
8.9047340

68257.93
7.5870299

84.0000000
0

829195.00
161.0000000

3612 13449 TOTCHG

LOS

96585.12
9.3835973

73855.08
7.4754109

534.0000000
0

997836.00
153.0000000

3613 13176 TOTCHG

LOS

101269.45
9.5980571

75537.11
7.3233339

2029.00
0

998991.00
188.0000000

3614 7208 TOTCHG

LOS

103371.69
9.6594062

74343.53
7.4100765

839.0000000
0

918286.00
155.0000000

3615 6419 TOTCHG

LOS

92813.63
8.7963857

66991.61
6.6919820

484.0000000
0

898653.00
114.0000000

3616 508 TOTCHG

LOS

89716.19
8.1909449

56349.01
6.1948121

20786.00
1.0000000

461205.00
78.0000000

3617 3 TOTCHG

LOS

78057.33
6.3333333

56807.84
2.3094011

43820.00
5.0000000

143632.00
9.0000000

3619 24 TOTCHG

LOS

88172.17
8.0833333

56691.47
7.6437907

20741.00
1.0000000

282273.00
32.0000000

is less risky compared to the other procedures. Interestingly, hospital #7, while performing higher risk
procedures, also tends to charge a lower amount.
Next, we examine the length of stay by procedure for a specific hospital. We contrast hospital #7 to
hospital #6. For hospital #6, there is a natural hierarchy in the kernel density estimators, demonstrating
the severity of each of the procedures. Procedure 3613 has the highest probability of a long length of
stay; Procedures 3611 and 3616 have the highest probability of a short length of stay. Figure 42 shows
the length of stay for hospital #7. Figures 43 and 44 show additional hospitals.
First, hospital #6 does only four of the procedures. In contrast to hospital #7, procedure 3611 has the
lowest probability of a short length of stay for hospital #6; procedure 3613 has the highest probability