In this exercise, you will demonstrate your ability to find macroeconomic data from public sources and display it in an Excel spreadsheet.
Start by choosing one of these three macroeconomic variables: Real GDP, the unemployment rate, or the inflation rate.
Follow these instructions to find numbers for your macroeconomic variable for three consecutive years:
Real GDPLinks to an external site.. Click on “SECTION 1 – DOMESTIC PRODUCT AND INCOME.” Then click on “Table 1.1.6 Real Gross Domestic Product, Chained Dollars (A) (Q)” Next, click on the curved arrow for “Modify.” Choose 2015 as the first year, select the radio button for Series as “Annual” and then click on “Refresh Table.” Line 1 for “Gross domestic product” has the data.
Labor Force Statistics From the Current Population SurveyLinks to an external site.. These unemployment numbers are monthly, not annual. Use the January number for each year.
CPI for All Urban Consumers (CPI-U)Links to an external site.. These inflation numbers are monthly, not annual. Use the January number for each year.
Prepare an Excel spreadsheet that has two columns and four rows. In cells A3, A4, and A5 descending below this heading, type the three years that you have chosen.
In the heading for cell B2, type the name of the variable you chose (Real GDP, Unemployment Rate, or Inflation Rate). In the cells below this heading, type the values for each of the three years.
Underneath your table, type “Source:” and then paste the URL of the source where you found your data.