Comparison of Hospital Performance
Comparison of Hospital Performance
(Comparison of Hospital Performance)
Alesix Tieku
Dr. Hossein Zare,
Research and Data Analysis
HMGT 400 (7980)
March 20, 2019
Week 1, Exercise:
The attached dataset, provides some information about hospitals in 2011 and 2012, download the data and then complete the descriptive table. Please use the following format to report your findings.
Table 1. Descriptive statistics between hospitals in 2011 & 2012
Variables | 2011 | 2012 | p-value | ||||
N | Mean | St. Dev | N | Mean | St. Dev | ||
Hospital beds | 1505 | 376.6086 | 560.8998 | 1525 | 376.8 | 579.8366 | < 2.2e-16 |
Number of paid Employee | 1498 | 1237.276 | 1615.797 | 1515 | 1491.121 | 1961.637 | < 2.2e-16 |
Number of non-paid Employee | 30 | 39.973 | 72.58805 | 30 | 44.76976 | 81.29861 | 6.653e-05 |
Total hospital cost | 1505 | 216873322 | 304570722 | 1525 | 214748023 | 294143536 | < 2.2e-16 |
Total hospital revenues | 1505 | 228706319 | 323339811 | 1525 | 229978391 | 321273114 | < 2.2e-16 |
Available Medicare days | 1499 | 16739.16 | 19214.29 | 1516 | 17110.14 | 19765.74 | < 2.2e-16 |
Available Medicaid days | 1484 | 5301.199 | 9207.699 | 1501 | 5366.333 | 9340.373 | < 2.2e-16 |
Total Hospital Discharge | 1500 | 9492.326 | 10898.6 | 1517 | 9544.051 | 10994.17 | < 2.2e-16 |
Medicare discharge | 1499 | 3230.624 | 3388.957 | 1516 | 3598.248 | 3785.675 | < 2.2e-16 |
Medicaid discharge | 1481 | 1130.727 | 1757.158 | 1498 | 1119.547 | 1740.423 | < 2.2e-16 |
Based on your findings in which years hospitals had better performance? Please write a short paragraph and describe your findings.
The hospitals had better performance in 2012 compared to 2011. The mean number of hospital beds in 2012 was slightly higher than the mean number of hospital beds in 2011. In terms of revenue, the mean revenue in 2012 was higher than the mean revenue in 2011. The total cost in 2011 was also higher than the total cost in 2012. For these variables, the p. Value is less than 0.05 hence the null hypothesis is not rejected at 95% confidence interval. This implies that the means between the two groups are not different.
solution
Comparison of Hospital Performance: 2011 vs. 2012
Based on the descriptive statistics provided in the dataset, hospitals performed slightly better in 2012 than in 2011. The mean number of hospital beds in 2012 (376.8) was marginally higher than in 2011 (376.6), suggesting that hospitals maintained or slightly increased their capacity. Additionally, the mean number of paid employees rose notably from 1,237 in 2011 to 1,491 in 2012, reflecting an increase in staffing, which could contribute to improved care delivery and operational efficiency.
Moreover, total hospital revenues increased slightly in 2012, rising from an average of $228.7 million to $229.9 million, while total hospital costs slightly decreased from $216.9 million to $214.7 million. This favorable shift in financial indicators suggests improved cost management and potentially higher profitability. Available Medicare and Medicaid days also increased, along with the number of discharges, indicating higher patient throughput and greater service utilization.
Despite all p-values being less than 0.05—specifically noted as less than 2.2e-16—this statistical significance does not necessarily imply a large or meaningful practical difference. Rather, it shows that the observed differences in means between 2011 and 2012 are statistically significant due to the large sample size. Therefore, even slight changes can appear statistically significant.
In conclusion, the descriptive data suggest slightly improved hospital performance in 2012, characterized by increased revenue, more paid staff, and higher service output, despite minimal differences in some variables.