Wednesday, June 20, 2018

Medicare Payment and Value of Care Analysis by State 2013-2016

Using publicly available data from Medicare, I analyzed the payment and value of care data for Heart Attack, Heart Failure, Hip/Knee Replacement, and Pneumonia. The data I downloaded were intended for public use and it was downloaded from the following link on 6/20/2018. https://data.medicare.gov/data/hospital-compare. The data was collected from 2013 through 2016 and it collected the payment data for each hospital. If you would like to see my analysis in detail, you may click here to Download my analysis in Excel spreadsheet. The file works best in Microsoft Excel 2016 version.

According to the analysis, average medicare payment were higher in New Jersey, Nevada, Florida, Connecticut, Massachusetts, Rhode Island, and Texas. In contrast, the payments were lower in Alaska, Montana, New Mexico, Oregon, Wyoming, North Dakota, and South Dakota.

The value of care (measured by better mortality and complications) was better in Delaware, Massachusetts, DC, Rhode Island, Connecticut, New Jersey, and California, but lower in Arkansas, Nevada, Alabama, Tennessee, And Mississippi.

The value of care per payment was better in Alaska, Montana, New Mexico, South Dakota, Oregon, North Dakota, and Minnesota. However, the value of care per payment was lower in Nevada, New Jersey, Florida, Texas, Connecticut, and Pennsylvania.

Graph-1 Medicare Average Payment for Heart Attack, Heart Failure, Hip/Knee Replacement, and Pneumonia (2013-2016)
Graph-2 Medicare Average Payment for Heart Attack (2013-2016)




Graph-3 Medicare Average Payment for Heart Failure (2013-2016)



Graph-4 Medicare Average Payment for Hip/Knee Replacement (2013-2016)


Graph-5 Medicare Average Payment for Pneumonia (2013-2016)



Graph-6 Medicare value of care by state Average for Heart Attack, Heart Failure, Hip/Knee Replacement, and Pneumonia (2013-2016). Greener the better mortality/complications.







Graph-7 Medicare value of care by state Average for Heart Attack (2013-2016). Greener the better mortality/complications.





Graph-8 Medicare value of care by state Average for Heart Failure (2013-2016). Greener the better mortality/complications.






Graph-9 Medicare value of care by state Average for Hip/Knee Replacement (2013-2016). Greener the better mortality/complications.






Graph-10 Medicare value of care by state Average for Pneumonia (2013-2016). Greener the better mortality/complications.



Graph-11 Medicare Value Per Payment for Heart Attack, Heart Failure, Hip/Knee Replacement, and Pneumonia (2013-2016). Over 100 is better than average Value per Payment




Graph-12 Medicare Value Per Payment for Heart Attack (2013-2016). Over 100 is better than average Value per Payment







Graph-13 Medicare Value Per Payment for Heart Failure (2013-2016). Over 100 is better than average Value per Payment





Graph-14 Medicare Value Per Payment for Hip/Knee Replacement (2013-2016). Over 100 is better than average Value per Payment



Graph-15 Medicare Value Per Payment for Pneumonia (2013-2016). Over 100 is better than average Value per Payment





















Source:
https://data.medicare.gov/data/hospital-compare

Disclaimer
I am not to be liable for direct, indirect, or consequential damages or for any loss of money, revenue, profits, or data in connection with using this website, including, but not limited to, medical, physical, and psychological effects. The information contained within this website is provided 'as-is', without warranties as to its accuracy whether expressed or implied and is intended for educational purposes only.

No comments:

Post a Comment