Previous chapter
Case StudiesCreate Gapminder report in Excel
Next chapter


In this exercise we would like to create an Excel report including plots and tables for life expectancy (lifeExp), population (pop) and GDP per capita (gdpPercap) from the the gapminder data set in the package gapminder. More specifically, we would like to create a function which should

  1. Take a country as a parameter argument and a file path and creates the Excel report at the new path location.
  2. Create an Overview sheet showing the country in question in comparision to other countries on the same continent. Optional: Include continent aggregates in comparison 2.2. Optional: Create a world map to represent respective variables.
  3. Create a Detail sheet showing life expectancy and GDP per capita over time. Optional: Include continent aggregates for comparison
  4. Include data on CO2 Emissions as obtained from You directly download the data set here.