Health Data Visualization Lab

What Does Patient Data Tell Us About Healthcare Costs & Conditions?

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.

Original Dataset

Two subsets drawn from the dent_health hospital dataset. The first tracks patient volume per condition; the second compares average billing by admission pathway.

Patient Count by Medical Condition

Medical ConditionPatient Count
Cancer113
Diabetes112
Hypertension112
Obesity109
Arthritis108
Asthma106

Average Billing by Admission Type

Admission TypeAvg Billing ($)
Emergency25,823
Elective25,234
Urgent24,897

Three Visualizations, One Argument

Bar chart: Patient Count vs Medical Condition
01
Disease Burden is Strikingly Equal

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.

Key Insight: No dominant condition
Pie chart: Patient Count vs Medical Condition
02
Each Condition Claims an Equal Share

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.

Key Insight: Uniform proportional distribution
Bar chart: Avg Billing vs Admission Type
03
Admission Type Has Little Impact on Cost

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.

Key Insight: Costs are pathway-independent