All about Asthma in Adults with AB- Blood Type

There are two queries, one query with the sum of the statistics the other query featuring the exact data. The filters include elective admission, asthma, adult age, and AB- blood type which are the rarest. From the average billing amount of 24223$, we can see that despite being elective admission Asthma is still very costly to care. In addition, these patients are often treated with mixed medication such as Paracetamol, Penicillin, Lipitor, and Asprin without a single dominated medication. This varification is also showned in the test results(Normal, Inconclusive, Abnormal)where there is not a single standarlization and costs can vary largerly. Finally, there is only one extreme outlier with a negative cost of -1018$ on the billing which seems to be a credit/refund issue.

Group Stats

Total patients
23
Average age
52.3
Total billing (USD)
557131.27
Average bill (USD)
24223.10

Matching Records

Name Age Gender Medication Test Results Billing (USD)
Colton Strong 55 Male Paracetamol Normal 37,405.70
Robert Higgins 42 Male Ibuprofen Inconclusive 13,355.78
Christina Lawrence 80 Male Penicillin Inconclusive 47,433.28
Eric Duncan 43 Female Aspirin Normal 43,670.38
Andrea Willis 26 Male Ibuprofen Normal 30,676.44
Mrs. Sabrina Ball 63 Male Penicillin Abnormal 44,582.82
Jennifer Camacho 83 Male Ibuprofen Inconclusive 24,023.96
Roy Jones 47 Female Penicillin Inconclusive 6,252.08
Amanda Lucero 46 Male Paracetamol Abnormal 15,242.39
Christopher Weiss 49 Female Penicillin Inconclusive -1,018.25
Misty Williams 63 Male Penicillin Inconclusive 19,176.26
Jesse Jones 82 Female Penicillin Abnormal 38,397.02
Amanda Lawson 26 Male Aspirin Normal 5,778.25
Michael Duarte 60 Male Penicillin Inconclusive 25,999.13
Michael Ramos 82 Male Lipitor Inconclusive 14,168.50
Lee White 36 Female Ibuprofen Normal 49,675.01
Michelle Whitaker 84 Female Aspirin Abnormal 22,990.65
Justin Long 25 Male Ibuprofen Normal 6,948.14
John Curtis 25 Male Paracetamol Inconclusive 15,526.46
Christine Evans 42 Male Aspirin Normal 43,378.35
Robert Miranda 46 Male Paracetamol Inconclusive 6,995.90
Amy Maldonado 59 Female Penicillin Abnormal 38,441.51
Bryan Smith 40 Female Paracetamol Inconclusive 8,031.51