Reference no: EM131743733

This question requires you to use some real live data and generate some statistics and graphics. Visit the OECD website and look up information on health care. The direct URL is https://www.oecd.org/health/health-data.htm. At that site you can find all sorts of data related to health care and health care systems. The data can be downloaded as an Excel file that you can then open and use the data.

(a) Plot a time-series graph of health care expenditure as a percentage of GDP in Canada from 2000 to 2015. What does that suggest about the growth of health care expenditures in Canada? Is the system "out of control"? Explain.

(b) Using the data on health expenditure as a percentage of GDP for 2015, which country has the highest expenditure (as a share of GDP)? What are the top-five countries? Where does Canada rank in that list?

(c) Now, download data on health status. Download the data for life expectancy and look at "life expectancy at birth" for the total population. Extract just the OECD countries and create a scatterplot for life expectancy at birth against expenditure on health care as a share of GDP. Do this for 2015. For any countries with missing data, use the most recent estimate. What does this suggest? Are there any countries that stand out as unusual?