Healthcare · Generic · Admissions · Billing Analysis
Executive Summary

Executive Summary

Key billing findings across medical conditions, admission types, and insurance providers.

n_admissions
4991
total_billed
126281079.45
mean_billing_amount
25301.76
n_billing_anomalies
0
los_billing_correlation
0.002
Across 4,991 hospital admissions, Asthma generated the highest average billing at $25,755. Urgent admissions carried the highest average cost at $25,323, while Blue Cross was the insurer associated with the highest average billed amount at $25,754. IQR-based anomaly detection (multiplier = 1.5) flagged 0 admissions (0%) as billing outliers.
Interpretation

Across 4,991 hospital admissions, Asthma generated the highest average billing at $25,755. Urgent admissions carried the highest average cost at $25,323, while Blue Cross was the insurer associated with the highest average billed amount at $25,754. IQR-based anomaly detection (multiplier = 1.5) flagged 0 admissions (0%) as billing outliers.

Visualization

Billing by Medical Condition

Average billing amount by medical condition (top 8 conditions).

Interpretation

Asthma is the most expensive condition with an average bill of $25,755, while Hypertension has the lowest average at $24,555. The spread between the highest and lowest-cost conditions is $1,200, indicating substantial variation in treatment costs across diagnoses. Condition-specific cost management strategies could yield significant savings.

Visualization

Cost by Admission Type

Average billing amount by admission type.

Interpretation

Urgent admissions carry the highest average cost at $25,323, compared to $25,281 for Emergency admissions. The billing premium between the most and least expensive admission type is $43. These cost differentials likely reflect differences in care intensity, staffing requirements, and resource utilization across admission categories.

Visualization

Insurance Provider Billing Patterns

Average billing amount per insurance provider.

Interpretation

Blue Cross is associated with the highest average billed amount at $25,754, versus $24,678 for Medicare. The billing spread across insurers is $1,076. Variation across insurers may reflect negotiated contract rates, patient case-mix differences, or utilization patterns tied to plan types.

Visualization

Length of Stay vs Billing Amount

Scatter of billing amount by length of stay (days), colored by admission type.

Interpretation

The Pearson correlation between length of stay and billing amount is 0.002 (weak relationship). Longer stays accumulate more charges across room, nursing, and ancillary services. Emergency admissions may show steeper per-day costs due to intensive initial care, while Elective admissions typically have more predictable, planned cost structures.

Visualization

Patient Age vs Billing Amount

Scatter of billing amount by patient age, colored by medical condition.

Interpretation

Age and billing amount have a correlation of 0.0056. Older patients may incur higher bills due to complex comorbidities and longer recovery times. Analyzing cost by condition across age groups identifies high-cost demographic segments that may benefit from targeted care management programs.

Visualization

Billing Amount Distribution

Frequency histogram of total billing amounts across all admissions.

Interpretation

The billing distribution is approximately symmetric (skewness = 0.047). The middle 50% of charges falls between $13,345 and $37,169. The mean bill is $25,302 while the median is $25,008. High-end outliers pull the mean above the median, confirming the skew direction.

Data Table

Billing Anomalies

Admissions with extreme billing amounts flagged via Z-score threshold (|z| > 2; IQR method found no outliers at current multiplier).

ageadmission_typebilling_amountmedical_conditioninsurance_provider
74Urgent5.237e+04CancerUnitedHealthcare
18Urgent5.221e+04DiabetesAetna
21Elective5.202e+04ObesityCigna
41Elective5.163e+04AsthmaBlue Cross
58Emergency5.131e+04ObesityBlue Cross
51Elective5.109e+04CancerMedicare
76Urgent5.108e+04CancerAetna
63Urgent5.104e+04ArthritisUnitedHealthcare
78Emergency5.094e+04CancerMedicare
43Urgent5.088e+04ArthritisBlue Cross
30Emergency5.083e+04HypertensionMedicare
38Urgent5.082e+04HypertensionBlue Cross
58Elective5.081e+04ArthritisBlue Cross
44Elective5.078e+04DiabetesUnitedHealthcare
33Urgent5.076e+04CancerCigna
71Urgent5.074e+04HypertensionAetna
29Emergency5.068e+04AsthmaBlue Cross
54Urgent5.065e+04CancerBlue Cross
37Urgent5.063e+04DiabetesAetna
27Urgent5.057e+04AsthmaAetna
31Urgent5.056e+04CancerCigna
32Urgent5.053e+04CancerAetna
46Emergency5.051e+04HypertensionMedicare
64Urgent5.05e+04DiabetesUnitedHealthcare
73Urgent5.041e+04DiabetesMedicare
66Elective5.04e+04ArthritisCigna
31Emergency5.039e+04HypertensionCigna
62Elective5.036e+04HypertensionAetna
53Elective5.034e+04AsthmaUnitedHealthcare
51Elective5.034e+04AsthmaUnitedHealthcare
49Urgent5.033e+04HypertensionUnitedHealthcare
65Elective5.031e+04ObesityAetna
71Urgent5.028e+04DiabetesBlue Cross
46Elective5.026e+04ObesityCigna
55Urgent5.025e+04ObesityCigna
28Urgent5.021e+04DiabetesUnitedHealthcare
27Urgent5.02e+04AsthmaBlue Cross
29Elective5.017e+04ArthritisMedicare
71Urgent5.014e+04CancerBlue Cross
41Elective5.013e+04ArthritisAetna
66Elective5.012e+04DiabetesCigna
63Urgent5.009e+04CancerMedicare
54Urgent5.008e+04HypertensionMedicare
73Emergency5.007e+04CancerCigna
69Elective5.007e+04ObesityAetna
34Emergency5.004e+04DiabetesUnitedHealthcare
32Emergency5e+04AsthmaCigna
65Elective4.995e+04DiabetesBlue Cross
38Elective4.995e+04ArthritisAetna
53Emergency4.995e+04AsthmaMedicare
22Emergency1465HypertensionAetna
20Elective1463ArthritisCigna
80Emergency1459CancerUnitedHealthcare
78Urgent1455CancerBlue Cross
65Elective1421CancerAetna
26Emergency1419HypertensionBlue Cross
31Urgent1403AsthmaUnitedHealthcare
42Emergency1399DiabetesAetna
71Urgent1389HypertensionCigna
47Elective1371AsthmaMedicare
71Emergency1348HypertensionMedicare
48Urgent1345HypertensionCigna
42Urgent1303AsthmaMedicare
31Urgent1266HypertensionCigna
28Elective1209ArthritisMedicare
47Elective1168ObesityUnitedHealthcare
68Emergency1120ArthritisUnitedHealthcare
47Emergency1118ArthritisMedicare
49Elective1093HypertensionCigna
46Urgent1089ObesityUnitedHealthcare
26Emergency1082DiabetesAetna
75Urgent1074HypertensionMedicare
58Elective1027ArthritisCigna
64Urgent1000ArthritisUnitedHealthcare
64Elective967.3ArthritisUnitedHealthcare
68Emergency940.7ArthritisUnitedHealthcare
61Urgent935.5ObesityMedicare
34Elective929.9CancerMedicare
57Elective900HypertensionUnitedHealthcare
71Urgent895.3AsthmaCigna
21Emergency870.3ObesityUnitedHealthcare
34Urgent856.6ArthritisBlue Cross
81Elective850ObesityBlue Cross
28Emergency846.7DiabetesAetna
82Urgent843.1ArthritisBlue Cross
61Elective830ArthritisCigna
26Elective738.6ObesityCigna
55Urgent651.9HypertensionCigna
67Elective584.8AsthmaMedicare
55Emergency574.5AsthmaBlue Cross
25Elective552.5AsthmaMedicare
60Elective539.5DiabetesUnitedHealthcare
36Elective480.1AsthmaAetna
62Emergency436.3DiabetesBlue Cross
54Elective314.1CancerAetna
73Elective280.4HypertensionCigna
71Urgent238.8ArthritisUnitedHealthcare
80Emergency236.1AsthmaUnitedHealthcare
65Urgent162.2HypertensionMedicare
25Emergency53.26DiabetesCigna
Interpretation

100 admissions (2% of total) were flagged as billing outliers using Z-score threshold (|z| > 2; IQR method found no outliers at current multiplier). The highest anomalous bill was $52,373. Hypertension is the most over-represented condition among anomalies, warranting clinical audit to verify billing accuracy and coding compliance.

Your data has more stories to tell. Run any analysis on your own data — 60+ validated R modules, interactive reports, AI insights, and PDF export. 2,000 free credits on signup.
Try Free — No Signup Sign Up Free

Report an Issue

Tell us what's wrong. You'll get a free re-run of this analysis so you can try again with different parameters. If the re-run still doesn't meet your expectations, we'll refund your credits.

Want to run this analysis on your own data? Upload CSV — Free Analysis See Pricing