Team Number _______

In this exercise, you will access Census Bureau’s "IDB Data Access - Spreadsheets" Web page in order to retrieve the mid-year populations of your two countries for 1950 through 2020, at five-year intervals. If data is not available for all of these years, get all the years you can. Then using the procedure described in class, create an Excel worksheet similar to the following table:

Next, have Excel draw line charts for the mid-year populations of both countries on the same set of axes, the horizontal axis being the years. If the populations of your two countries are drastically different, it may be more informative to plot the mid-year population graphs separately.

Next, create a "Rate of Change" column for country 1, and have Excel calculate the rate of change for each of the 5-year intervals and place them in the new column. Repeat this step to create a "Rate of Change" column for country 2. Now have Excel draw a line chart of the Rates of Change for both countries on the same set of axes.

Based on the data and these graphs, discuss the patterns for population change in your two countries. Can you relate these patterns to particular events?