Homework: Macroeconomics Case Study
Instructions
In this exercise, you will demonstrate your ability to find macroeconomic data from public sources and to display it in an Excel spreadsheet.
A. Start by choosing one of these three macroeconomic variables: Real GDP, the unemployment rate, or the inflation rate.
B. Follow these instructions to find numbers for your macroeconomic variable for the years 2015, 2016, and 2017:
a. Table 1.1.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.
b. Labor Force Statistics From the Current Population Survey. These unemployment numbers are monthly, not annual. Use the January number for each year.
c. CPI for All Urban Consumers (CPI-U). These inflation numbers are monthly, not annual. Use the January number for each year.
C. Prepare an Excel spreadsheet that has two columns and four rows. In cell A1 type in the variable you selected and bold the text. In the heading for cell A2, type, "Year." In cells A3, A4, and A5 descending below this heading, type the years 2015, 2016, and 2017.
D. In the heading for cell B3, 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.
Format your homework according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.