The primary goal of this project is to make Centers for Medicare & Medicaid Services' (CMS) Medical Loss Ratio (MLR) data regarding the Affordable Care Act (ACA) more easily accessible to the public. We started to achieve this goal by parsing each individual insurer's reported data and combining that into a large CSV output last semester. {Fall 2017 Code Repository}
A secondary goal of this project is to perform a prelimary statistical analysis of the data. Additionally, we attempt to duplicate CMS statistics on this ACA data. We search for statistical outliers and any correlations between premiums and transfers or spending and transfers, and we calculate year to year per person risk adjustment payment.
This project was undertaken as part of ORF 376: Independent Research Project in Spring 2018, under the guidance of Professor Mark Braverman. With thanks to Jeremie Lumbroso for helping scrape CMS data from their website.