Health Data Presentation
IDSN530 — Yifan Chen
Aspirin Ibuprofen Lipitor Penicillin Paracetamol
Slide 1 — Medication Snapshot
Continue →
This slide shows how patient counts and age ranges vary by medication. Click a medication button above to update this slide instantly.
Slide 2 — Research Focus
Continue →
Topic: Female Diabetes patients (Age 30–40).
Total Patients
39
Average Age
34.28
Total Billing
$843,092
Average Bill
$21,618
Driving question: What does the billing cost look like for this demographic slice, and how might admission type relate?
Slide 3 — Patient Records (max 40)
Continue →
Below are the raw records for the same filter (female, diabetes, age 30–40).
Name Age BloodType Medication AdmissionType BillingAmount TestResults
mr. KenNEth MoORE 34 A+ Lipitor Emergency $18,834.80 Abnormal
NicOlE RodriGUEz 30 AB+ Lipitor Emergency $8,408.95 Normal
apRil SANTIAgO 33 B- Penicillin Emergency $2,305.14 Inconclusive
TAyLoR howeLl Dds 35 B+ Ibuprofen Elective $30,358.19 Inconclusive
roBYn miRaNDa 30 A- Ibuprofen Elective $42,792.24 Abnormal
jOHN GarciA 39 A+ Penicillin Urgent $1,150.87 Abnormal
NIcholAs haLl 31 A- Ibuprofen Urgent $3,730.00 Abnormal
CArOl GOMEz 31 B- Paracetamol Elective $11,469.39 Abnormal
TONi fAULKNer 39 AB- Penicillin Urgent $20,105.03 Normal
TiMoThY lOpeZ 33 A- Ibuprofen Urgent $22,257.61 Abnormal
stePHANIe ROdRigueZ 40 O+ Penicillin Elective $31,063.56 Normal
caTheriNe sMitH 38 AB+ Lipitor Elective $1,656.55 Abnormal
CArLOS lOPEz 38 O+ Penicillin Elective $2,547.91 Inconclusive
JaMIE bAKEr 37 AB+ Lipitor Elective $41,548.15 Inconclusive
johN becKEr 30 O- Penicillin Urgent $46,717.95 Inconclusive
aPRil MaRTIN 39 AB+ Penicillin Emergency $10,556.98 Abnormal
DonNa SMitH 36 B+ Lipitor Emergency $38,276.36 Normal
gEoRge mason 30 AB- Penicillin Emergency $42,500.59 Abnormal
jorGe singh 37 O+ Penicillin Emergency $8,656.28 Normal
jAMES NGuyEn 39 AB+ Lipitor Urgent $24,977.27 Inconclusive
cLiFfOrD lEe 32 A- Paracetamol Emergency $44,695.26 Abnormal
KImBeRLy wElcH 37 AB- Ibuprofen Elective $22,039.68 Abnormal
lARry SinGleTOn 31 A- Ibuprofen Urgent $2,924.47 Normal
chrISTOpheR GReEn 37 AB- Paracetamol Elective $14,265.81 Normal
maRy beLl 35 O+ Paracetamol Emergency $32,680.61 Abnormal
zaCHaRy riCE 37 AB- Paracetamol Emergency $37,152.65 Abnormal
JILL sErRaNO 35 AB+ Ibuprofen Elective $19,769.29 Inconclusive
mICHAel hIll 33 O+ Penicillin Elective $15,832.56 Normal
lOGAN torres 33 AB- Penicillin Emergency $22,261.42 Abnormal
aShleY KIM 38 A+ Aspirin Emergency $14,415.58 Inconclusive
cHRISTiNa MeDiNa 34 AB- Paracetamol Elective $14,274.97 Inconclusive
lISA FIsHER 36 A- Aspirin Elective $8,797.41 Inconclusive
PatriCia HeRNaNdEz 30 AB- Penicillin Urgent $49,101.00 Abnormal
reNEe MYers 32 B+ Aspirin Emergency $43,090.66 Inconclusive
THOmAs GonZaLes 32 AB+ Paracetamol Emergency $662.61 Normal
marY JAmeS 33 B+ Penicillin Urgent $24,792.17 Normal
mIcHAeL PhaM 31 AB+ Aspirin Emergency $2,134.99 Abnormal
KeNneth CrAWFORd DdS 30 B- Penicillin Elective $42,230.59 Normal
jAmes gaRcIa 32 AB+ Lipitor Urgent $22,056.68 Abnormal
Observation idea: scan whether Emergency admissions appear to have higher bills than Urgent/Elective.
Slide 4 — Insight by Admission Type
Finish →
Next step: compare AdmissionType to see which category appears most often and which has higher average billing.
AdmissionType Patients Avg Bill
Emergency 15 $21,776
Elective 14 $21,332
Urgent 10 $21,781
If one admission type shows both high volume and higher average bill, it’s a strong candidate driver for deeper analysis.
Slide 5 — Conclusion
Restart ↺
Conclusion: For female diabetes patients age 30–40, the dataset shows measurable cost outcomes (total + average billing), and the breakdown by admission type provides a quick direction for deeper analysis.

Next steps: compare billing by Medication or TestResults to look for factors that correlate with higher cost.