I ran statistical tests on 4,500 healthcare insurance claims worth $22.5M, half-expecting patient...I ran statistical tests on 4,500 healthcare insurance claims worth $22.5M, half-expecting patient...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Mwanahamisi's avatar
Mwanahamisi Juma
• Sep 18
I ran statistical tests on 4,500 healthcare insurance claims worth $22.5M, half-expecting patient demographics to explain at least some of the cost variation.
They didn't. Age, income, gender, provider specialty, even claim type — none of it came back statistically significant against claim amount or status.
What actually stood out was Pediatrics. $4.9M in claims, the highest average claim amount of any specialty. Not a "who's filing the claim" problem — a specialty-specific one.
I built four Power BI dashboards (Executive, Patient Insights, Provider Performance, Claims Analysis) so this kind of pattern shows up as it happens, not just in a one-off report six months later.
If your team is still reviewing claims by demographic segment, this might be worth a second look.
Completed work
Healthcare ITPythonSQLData AnalysisMicrosoft Power BI
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started