The question you are asked is – in which year (2011 or 2012) did hospitals have better performance? To determine that you would need to use the data to calculate a measure of performance for each hospital.  So, for example, you could calculate Hospital Cost per Discharge = Total Hospital Cost/Total Hospital Discharges, for each hospital (see the last row in Table 1 template above).

The data file may be downloaded with the numbers in some data columns (e,g,: Total Hospital Cost and Total Hospital Revenue) expressed or presented in scientific notation. Please, re-format all such data columns from scientific format (e.g.: 4.823 X 10e2) to regular number format (482.3). Another example is 4.5×10e−3 reformated to 0.0045.

Table 1 attached

NOTE: Please note how the t Value and the (Pr<|t|) values are presented in the last column. The format should be the same for each hospital characteristic.

Figure E.1 –

Attached

In your Summary Report:

Findings: Please write a short paragraph to describe your findings. Make sure to attach any plotted graph(s).
Performance – Conclusion: Based on your findings in which year did US hospitals have better performance? What is that based on?

The question you are asked is – in which year (2011 or 2012) did hospitals have better performance? To determine that you would need to use the data to calculate a measure of performance for each hospital.  So, for example, you could calculate Hospital Cost per Discharge = Total Hospital Cost/Total Hospital Discharges, for each hospital (see the last row in Table 1 template above). Then you can comment on which year the hospitals had better performance, based on the values in that row.  This is an example. You could combine other sets of hospital data to create a different measure of performance. Insert that measure as another row in the Table, and determine if the difference in hospital performance for the 2 years is statistically significant for that measure.

 

 

HMGT400HOSPITAL.csv

 

 

ScreenShot2024-04-28at10.11.13AM.png

 

 

ScreenShot2024-04-28at10.10.35AM.png

stata_name
stcd
year
total_hosp_cost
total_hosp_revenue
hospital_beds
bedsize_cat
teaching_hospital
system_member
level_trauma
white
rural_area
herf_cat
herf_index
non_white
log_hosp_cost
log_hosp_revenue
total_hospital_beds
total_hospital_medicare_days
total_hospital_medicaid_days
interns_and_residents
total_hospital_employees_on_payr
total_hospital_non_paid_workers
total_hospital_medicare_discharg
total_hospital_medicaid_discharg
total_hospital_discharges
own

Arizona
86
2012
1.89E+07
1.73E+07
19
1
0
0
0
58.7
0
1
0
41.3
16.75435
16.66785
168.92
11551.5
8206.92

855.048

2695.488
2867
8879
0

Arizona
86
2012
8.01E+07
7.94E+07
88
3
0
0
0
58.5
0
1
2
41.5
18.19875
18.19
138.02
14629.86
2423.52

1209.024

4117.736
697
6998
1

Arizona
86
2012
1.47E+08
1.33E+08
134
4
0
0
0
82
0
1
2
18
18.80468
18.70265
74.16
3784.2
4354.38

490.464

1305.488
1253
4320
0

Arizona
86
2012
7.74E+07
8.81E+07
72
3
0
0
0
82
0
1
2
18
18.16424
18.29439
25.75
306
225.42

132.84

74.504
66
257
0

Arizona
86
2012
1.53E+08
1.41E+08
187
4
0
0
0
58.7
0
1
2
41.3
18.84588
18.76257
19.57
1545.3
98.94

139.608

259.096
18
429
2

Arizona
86
2012
1.60E+07
1.70E+07
21
1
0
0
0
20.4
1
0
2
79.6
16.58738
16.65044
20.6
1042.44
235.62

185.148

160.128
77
366
2

Arizona
86
2012
7.02E+08
7.55E+08
460
7
0
0
1
55.3
0
1
2
44.7
20.36947
20.4425
493.37
28329.48
46840.44
356.34
4570.98

5216.392
9139
26341
2

Arizona
86
2012
2.07E+07
2.29E+07
14
1
0
0
3
58.5
0
1
2
41.5
16.84361
16.94799
237.93
5724.24
11063.94
95.39
1073.82

1195.4
1481
6836
0

Arizona
86
2012
1.67E+08
1.72E+08
163
4
0
0
3
55.3
0
1
2
44.7
18.93446
18.96016
14.42
961.86
255

154.62

151.232
98
356
1

Arizona
86
2012
2.32E+07
2.06E+07
56
3
0
1
0
16
0
1
2
84
16.95965
16.84255
61.8
3816.84
1180.14

307.2

1159.816
312
2738
0

Arizona
86
2012
9.60E+07
1.20E+08
3550
4
0
1
0
58.7
0
1
0
41.3
18.37936
18.59896
37.08
1138.32
2433.72

315.804

433.68
660
2426
0

Arizona
86
2012
1.31E+08
1.49E+08
110
4
0
1
0
82
0
1
2
18
18.68941
18.82107
101.97
8494.56
3713.82
8
882.924

2048.304
934
4332
1

Arizona
86
2012
1.81E+08
1.99E+08
460
5
0
1
0
58.7
0
1
0
41.3
19.01667
19.10902
360.5
12812.22
9098.4

1110

3155.856
2109
10925
1

Arizona
86
2012
5.37E+07
3.92E+07
3550
2
0
1
0
58.7
0
1
2
41.3
17.79862
17.48499
210.12
10312.2
9235.08

1303.464

2696.6
2715
12235
0

Arizona
86
2012
2.28E+08
2.45E+08
3550
6
0
1
0
58.7
0
1
0
41.3
19.24457
19.31838
354.32
27260.52
9731.82

1711.284

7236.896
2559
18413
1

Arizona
86
2012
3.15E+08
3.79E+08
267
5
0
1
1
55.2
0
2
2
44.8
19.56899
19.7525
252.35
16108.86
15733.5

1894.188

3968.728
3487
12895
2

Arizona
86
2012
2.64E+08
2.81E+08
460
5
0
1
1
58.7
0
1
0
41.3
19.39099
19.45325
273.98
17960.16
16340.4

1704.816

4232.272
3447
16298
2

Arizona
86
2012
4.70E+08
5.17E+08
3550
8
0
1
1
58.7
0
1
0
41.3
19.96899
20.06368
273.98
17960.16
16340.4

1704.816

4232.272
3447
16298
1

Arizona
86
2012
3.94E+08
4.35E+08
3550
7
0
1
1
58.7
0
1
0
41.3
19.79191
19.89182
273.98
17960.16
16340.4

1704.816

4232.272
3447
16298
1

Arizona
86
2012
3.48E+07
3.67E+07
25
2
0
1
3
65.9
0
1
2
34.1
17.36395
17.41857

0

Arizona
86
2012
5.24E+07
5.62E+07
49
2
1
0
0
52.3
0
2
2
47.7
17.77366
17.8452
507.79
29487.18
40869.36
44.66
3096.06

7225.776
8762
29644
1

Arizona
86
2012
4.28E+08
4.54E+08
553
8
1
0
0
55.3
0
1
2
44.7
19.8756
19.9329
50.47
2233.8
2249.1

500.772

563.784
654
2095
0

Arizona
86
2012
1.22E+08
1.23E+08
89
3
1
0
3
43.9
1
1
2
56.1
18.61977
18.62993
91.67
4144.26
5121.42

788.256

1223.2
1544
3712
0

Arizona
86
2012
2.23E+08
2.16E+08
3550
4
1
1
0
58.7
0
1
0
41.3
19.22436
19.19189
244.11
29369.88
2147.1
89.71
5149.536

6878.832
264
12315
2

Arizona
86
2012
2.27E+08
2.68E+08
3550
6
1
1
0
58.7
0
1
0
41.3
19.24058
19.40528
397.58
38496.84
4977.6
1.88
2182.056

9723.328
1340
22069
1

Arizona
86
2012
9.23E+08
9.84E+08
244
5
1
1
0
58.7
0
1
0
41.3
20.64341
20.70665
327.54
32268.72
11889.12

1869.108

8493.456
2780
20464
2

Arizona
86
2012
2.72E+08
2.95E+08
3550
7
1
1
0
58.7
0
1
0
41.3
19.42014
19.50291
169.95
8433.36
12750

1059.324

2466.416
4690
13654
0

Arizona
86
2012
6.06E+08
6.80E+08
3550
8
1
1
1
58.7
0
1
0
41.3
20.22179
20.33736
585.04
37101.48
53716.26
129.3
4415.16

7460.408
10624
36275
0

Arizona
86
2012
1.98E+08
2.41E+08
3550
5
1
1
2
58.7
0
1
0
41.3
19.1031
19.30064
220.42
12159.42
24371.88

1554.48

3299.304
5620
18796
2

Arkansas
71
2012
8125045
7994666
49
2
0
0
0
84
0
1
2
16
15.91046
15.89429
111.24
8150.82
1690.14

717.768

2257.36
803
4634
2

Arkansas
71
2012
7.38E+07
7.72E+07
125
4
0
0
0
95.2
0
2
2
4.800003
18.11635
18.16157
120.51
11514.78
1907.4

704.808

2766.656
561
4925
1

Arkansas
71
2012
7.12E+07
7.71E+07
124
4
0
0
0
89
0
1
2
11
18.08072
18.16073
13.39

1.02

1
1
2

Arkansas
71
2012
2.28E+07
2.36E+07
33
2
0
0
0
68.2
1
0
2
31.8
16.9437
16.97513
25.75
1785
57.12

103.896

394.76
26
502
1

Arkansas
71
2012
1.05E+07
1.03E+07
85
3
0
0
0
71
1
0
2
29
16.16907
16.143
25.75
1164.84
44.88

178.392

306.912
22
395
1

Arkansas
71
2012
1.62E+07
1.88E+07
25
2
0
0
0
40.3
1
0
2
59.7
16.60155
16.75008
25.75
1051.62
194.82

117.936

259.096
62
414
2

Arkansas
71
2012
9525674
8233617
25
2
0
0
0
92.2
1
0
2
7.800003
16.0695
15.92374
25.75
2970.24
762.96

180.468

760.608
429
1243
2

Arkansas
71
2012
2.08E+07
2.22E+07
72
3
0