An analysis of medical condition distribution and billing patterns across 660 hospital patients, exploring whether admission type and diagnosis meaningfully affect the cost of care.
Two subsets drawn from the dent_health hospital dataset. The first tracks patient volume per condition; the second compares average billing by admission pathway.
| Medical Condition | Patient Count |
|---|---|
| Cancer | 113 |
| Diabetes | 112 |
| Hypertension | 112 |
| Obesity | 109 |
| Arthritis | 108 |
| Asthma | 106 |
| Admission Type | Avg Billing ($) |
|---|---|
| Emergency | 25,823 |
| Elective | 25,234 |
| Urgent | 24,897 |
The horizontal bar chart reveals that all six medical conditions are represented at nearly identical rates — ranging from just 106 (Asthma) to 113 (Cancer) patients. This remarkably even distribution suggests the dataset is either demographically balanced by design, or that this hospital serves a population where no single chronic condition dominates admissions.
The bar chart format is effective here because it lets the eye instantly compare lengths across all six conditions simultaneously, making the near-uniformity impossible to miss.
The pie chart reinforces the bar chart's finding from a proportional perspective. Each condition holds a slice between 16.1% and 17.1% — essentially one sixth of the total patient population. While pie charts can sometimes obscure small differences, here they serve a narrative purpose: visually demonstrating that the hospital's caseload is almost perfectly segmented, with no condition overwhelming the others.
Together, Charts 1 and 2 build a compelling case that this dataset reflects a balanced chronic disease burden across the patient population.
Perhaps the most surprising finding: Emergency admissions cost only ~26 more on average than Urgent admissions ($25,823 vs $24,897). One might expect emergency care to carry dramatically higher costs due to unplanned resource use, but the data tells a different story — billing is nearly flat across all three admission types.
This challenges the assumption that how you arrive at the hospital determines how much you pay. It may suggest that diagnosis and treatment complexity, not admission pathway, drives cost — a finding worth further investigation.