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:
Table 1.1.6. https://apps.bea.gov/iTable/?reqid=19&step=3&isuri=1&nipa_table_list=6 (Real Gross Domestic Product, Chained Dollars). Select Modify and choose 2015-A&Q as the First Year. Under Series, select Annual. The Real GDP numbers for each year are in Line 1.
https://data.bls.gov/timeseries/LNS14000000 (Labor Force Statistics From the Current Population Survey). These unemployment numbers are monthly, not annual. Use the January number for each year. https://data.bls.gov/timeseries/CUUR0000SA0L1E?output_view=pct_12mths
(CPI for All Urban Consumers (CPI-U)). 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.
Copy & Paste https links because it’s needed to complete the assignment
