First, I decided to look around to see what's already out there. I found the following graph in a Kaiser Family Foundation (KFF) publication. It was generally what I was looking for, but only showed a handful of countries, and wasn't the easiest to read.
I did a little digging, and found that similar data were available for several other countries too. So I downloaded the csv from the Organisation for Economic Co-operation and Development webpage (oecd.org), and read it into SAS.
Since I was including more countries in my graph, I knew that having a different color for each country was not going to work (it was already difficult to discern the 6 colors used in the original graph). Instead of using colors and a color legend, I added html hover-text with the country names to each line (you'll need to click the snapshot below, to see the interactive version), and labeled certain countries to provide some quick/easy reference points.
I liked my graph better than the original, but it was still difficult to compare the values in the 1970s and 80s. Since the graph showed current-dollar values, the more recent years had much higher values (because of inflation), which squished the values on the left side of the graph. I tried using the consumer price index (cpi) and converting all the values to constant (~1983) dollars, but I wasn't really confident that applying the US cpi to other countries was a valid thing to do. Also, I wasn't sure whether to use the cpi for all items, medical care, or something else.
Let's take a little intermission, while we think of a different way to visualize this data. Here's a picture that my friend Margie made for me (special, just for this blog). What better way to take a "closer look" at data, than to use a magnifying glass!?! Thanks Margie!
And now, with my mind cleared and thinking outside the box, I came up with a different way to graph the data. What I really wanted to do was compare the other countries with the US, therefore why not do something more direct, such as calculate the other countries' spending as a percent of the US spending! This way, I have a number that I can compare from year to year much more easily.
This graph shows that since about 1990, the other countries have spent less than 75% of what the US spent on per capita healthcare (most of them way less). If the US spends more, do we get more? If other countries spend less, do they get worse healthcare? I guess those are the big questions ... and hopefully I will find some data to answer those questions in an upcoming blog!
So, what are your theories and thoughts on healthcare, and why the US spends so much more per capita than the other countries? I wonder if there's a lot of variance on the per capita spending, depending on income level, and such? What's the "right amount" to spend, for an acceptable level of health care? Feel free to share your thoughts and suggestions in the comments section!