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 |