In this exercise, you will demonstrate your ability to find macroeconomic data from public sources and to 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 the years 2015, 2016, and 2017:
- 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.
- Labor Force Statistics From the Current Population Survey. These unemployment numbers are monthly, not annual. Use the January number for each year.
- 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 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.
- 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.
Resources to Complete This Assignment
- Week 7 Macroeconomic Case Study with Excel Example [DOCX].
- Excel Essential Training – What Is Excel Used For?
- Excel Essential Training – Using the Quick Access Toolbar and Ribbon Menu.
- Excel Essential Training – Understanding Workbooks and Worksheets.
- Excel Essential Training – Using Excel Help.
- Excel Essential Training – Using Save or Save As.
- Excel Essential Training – Using Simple Formulas.
- Excel Essential Training – Exploring Font Styles and Effects.
- Excel Essential Training – Applying Borders and Color Backgrounds.
- Excel Quick Tips – Work with the New Stock and Geography Data Types.