-------------------- Admission count per hospital, by specialty, in a certain period of time --------------------
Hospital Class count
General Hospital E65B 50
St Elsewhere E65B 44
General Hospital E69B 9
St Elsewhere E69B 16
General Hospital F62B 51
St Elsewhere F62B 42
General Hospital F67B 3
St Elsewhere F67B 5
General Hospital F74B 35
St Elsewhere F74B 49
General Hospital G07B 78
St Elsewhere G07B 87
General Hospital G10B 83
St Elsewhere G10B 103
General Hospital I04B 89
St Elsewhere I04B 69
General Hospital I74B 75
St Elsewhere I74B 58
-------------------- Average length of stay by hospital --------------------
Hospital average_length_of_stay
General Hospital 2.2368
St Elsewhere 2.1205
-------------------- Average length of stay by class --------------------
Class average_length_of_stay
E65B 2.8085
E69B 1.9200
F62B 3.8925
F67B 2.6250
F74B 1.0119
G07B 1.6848
G10B 0.9785
I04B 4.9557
I74B 0.2857
-------------------- Average length of stay by MO --------------------
Hospital average_length_of_stay
123456_CAR 2.0645
147258_ORT 2.1600
159487_RES 2.5161
258369_ORT 3.3596
321654_SUR 1.7609
357241_RES 2.5000
369852_ORT 2.5984
456789_CAR 2.3936
654987_SUR 1.1705
753869_RES 2.9375
789123_CAR 2.9833
987654_SUR 1.1308
-------------------- Average Cost by Hospital --------------------
Hospital Average_Cost
General Hospital 6812.080482241018
St Elsewhere 6037.75042558139
-------------------- Average Cost by Class --------------------
Class Average_Cost
General Hospital 6812.080482241018
St Elsewhere 6037.75042558139
-------------------- Average Cost by Age --------------------
Age Average_Cost
2 2482.7387
3 3527.548025
4 1883.9322777777775
5 2499.415285714286
6 2457.9114
7 3522.0465875000004
8 3747.3476000000005
9 3190.099290909091
10 3292.4528999999998
11 3094.9129636363637
12 2994.8262187500004
13 4068.79200625
14 4092.1127699999997
15 4030.289366666666
16 4114.10346
17 5050.470725
18 5468.6603625
19 4074.3834285714283
20 3389.8373307692304
21 3437.275755555556
22 4689.2196
23 2953.6513800000002
24 4784.933766666666
25 4334.200075000001
26 5793.145042857143
27 2213.1588666666667
28 4553.5698
29 5916.237950000001
30 3978.135577777778
31 6034.059833333333
32 4236.605680000001
33 2412.8187799999996
34 5441.888066666666
35 3254.691135714286
36 4067.9336000000003
37 2694.54935
38 4455.808028571429
39 4349.929718181819
40 3483.3554500000005
41 3249.7463200000007
42 3376.7146999999995
43 4652.608119999999
44 3666.837090909091
45 4998.72268
46 3805.3042874999996
47 8157.1834818181815
48 2573.748742857143
49 3637.8829875
50 5470.72521
51 7429.044471428571
52 6069.29754
53 8480.2003875
54 4930.971100000001
55 6890.3219500000005
56 9244.338038461538
57 10783.495385714285
58 6075.266641666666
59 13644.211919999998
60 9228.20999
61 5031.172633333333
62 8237.934554545454
63 7102.825319999999
64 10498.38915625
65 8868.314880952381
66 7626.3720600000015
67 8396.035795454545
68 9225.51483888889
69 9239.289916
70 10929.934329411763
71 10801.665010526314
72 9590.106995652173
73 8586.436393333333
74 12294.932105263159
75 7260.082080952381
76 7568.619316666666
77 10489.50705833333
78 10882.801821428571
79 4085.0863166666663
80 13533.963325
81 6235.823600000001
82 10069.930431249999
83 5173.973605882354
84 4111.418983333333
85 6788.641288888888
86 6005.125766666667
87 7457.293961538461
88 3807.5741399999997
89 5444.9021999999995
90 4649.6082
91 6125.863466666667
92 3256.5584
93 2548.547
95 2618.09285
-------------------- Average Cost by Age Group --------------------
Age_Group Average_Cost
0-16 3312.8338729032266
17-38 4165.463966666667
39-60 6291.936471717175
> 60 8366.730365454541
