World Population.xlsx
is included in the Chapter 08
directory. It contains one record for each country for each year from 1960 to 2015, measuring population. Using this data set, let's take a look at the historical trends of various countries. Create a view similar to the following, which shows the change in population over time for Afghanistan and Australia. You'll notice that Country Name has been filtered to include only Afghanistan and Australia and the field has additionally been added to the Color and Label shelves:
From this visualization alone you can make several interesting observations. The growth of the two countries' populations was fairly similar up to 1980. At that point the population of Afghanistan went into decline until 1988 when the population of Afghanistan started to increase recover. At some point around 1996 the population of Afghanistan exceeded that of Australia. The gap has grown wider ever since.
While we have a sense of the two trends, they become even...