Vibrant Healthcare: Chronic Illness & Demographic Analysis
Vibrant Healthcare has collected extensive admission data to analyze patterns in critical illnesses. The dataset encompasses various medical conditions (asthma, arthritis, cancer, diabetes, hypertension, obesity) and key demographic factors (blood type, age group, and sex).Data Points Covered Test results by age group, Discharge rates (annual, 2018–2023), Highest billing treatment amounts. Core Analytical Objectives:Identify Most Chronic Condition: Determine which medical condition is most chronic by correlating it with the highest billing treatment costs, Determine High-Risk Demographics:Identify which blood type is most likely to receive medication.

Validate the established age group medication rankings: 30 (Highest), 71+ (Second Highest), 31-40 (Third Highest), 51-60 (Medium), and 41-50 (Least).Gender Risk Assessment: Use the sex metric to depict which gender is more likely to be affected by these chronic illnesses, aiming to inform future preventive strategies and reduce elevated discharge rates.