Insight: Comparing female patients with Hypertension and Diabetes who have O+ blood type and were admitted as Emergency cases. Female diabetes patients on average have a higher billing amount, and are older than female hypertension patients. The total bills are not comparable as there are 7 more diabetes patients affecting the large difference.
The dataset contains a total of 15 patients across both conditions. The combined average age is 49.47 years. The total billing amount is $370,074.69.
Total Patients: 4
Average Age: 43.50
Total Billing Amount: $89,759.02
Average Bill per Patient: $22,439.75
| Name | Age | Gender | Blood Type | Insurance Provider | Billing Amount | Room Number |
|---|---|---|---|---|---|---|
| rYAn BRadforD DDS | 42 | Female | O+ | Cigna | $31,822.73 | 370 |
| mR. jaCk wIlliS | 46 | Female | O+ | Cigna | $7,704.30 | 331 |
| vIcToRiA brADy | 52 | Female | O+ | Medicare | $6,969.09 | 379 |
| JeSsIca booTh | 34 | Female | O+ | Medicare | $43,262.89 | 248 |
Total Patients: 11
Average Age: 51.64
Total Billing Amount: $280,315.67
Average Bill per Patient: $25,483.24
| Name | Age | Gender | Blood Type | Insurance Provider | Billing Amount | Room Number |
|---|---|---|---|---|---|---|
| KATRIna LOPEz | 69 | Female | O+ | Cigna | $37,905.96 | 368 |
| johN SIMmOns | 69 | Female | O+ | Blue Cross | $40,304.38 | 449 |
| joEl MOntgomeRY | 45 | Female | O+ | Cigna | $3,553.90 | 375 |
| liNda BUtler | 23 | Female | O+ | Medicare | $11,209.42 | 452 |
| jorGe singh | 37 | Female | O+ | Medicare | $8,656.28 | 193 |
| maRy beLl | 35 | Female | O+ | Blue Cross | $32,680.61 | 493 |
| JuliE rIvaS | 78 | Female | O+ | Medicare | $28,106.08 | 287 |
| mOrgaN peRRY Dds | 64 | Female | O+ | UnitedHealthcare | $15,579.67 | 219 |
| kaTHrYN yOuNg | 79 | Female | O+ | Blue Cross | $34,828.81 | 384 |
| DilLon joHnson | 49 | Female | O+ | Blue Cross | $32,801.72 | 381 |
| MiChaEL pRICe | 20 | Female | O+ | Aetna | $34,688.85 | 361 |