Book contents
- Frontmatter
- Dedication
- Contents
- Preface
- Software Requirements and Opening a Macro-Enhanced Workbook
- Introduction:Why Simulation and Excel?
- 1 Charting in Excel
- 2 Economic Growth Literacy
- 3 The Solow Model
- 4 Macro Data with FRED in Excel
- 4.1 Introduction: FRED.xla
- 4.2 GDP: GDP.xls
- 4.3 Unemployment: Unem.xls
- 4.4 Inflation: Inflation.xls
- 4.5 Money: Money.xls
- 5 The Keynesian Model
- References
4.2 - GDP: GDP.xls
from 4 - Macro Data with FRED in Excel
Published online by Cambridge University Press: 05 May 2016
- Frontmatter
- Dedication
- Contents
- Preface
- Software Requirements and Opening a Macro-Enhanced Workbook
- Introduction:Why Simulation and Excel?
- 1 Charting in Excel
- 2 Economic Growth Literacy
- 3 The Solow Model
- 4 Macro Data with FRED in Excel
- 4.1 Introduction: FRED.xla
- 4.2 GDP: GDP.xls
- 4.3 Unemployment: Unem.xls
- 4.4 Inflation: Inflation.xls
- 4.5 Money: Money.xls
- 5 The Keynesian Model
- References
Summary
The NIPAs trace their origin back to the 1930s, when the lack of comprehensive economic data hampered efforts to develop policies to combat the Great Depression. In response to this need, the U.S. Department of Commerce commissioned future Nobel Laureate Simon Kuznets to develop estimates of national income.
– BEA DocumentationQuick Summary
To access GDP.xls, visit
http://www.depauw.edu/learn/macroexcel/excelworkbooks/Data/GDP.xls.
GDP.xls explains how to use the FRED Excel add-in to access GDP data and offers several simple analyses using GDP. The focus is on understanding basic national income accounting and becoming aware of a few facts about GDP, including the current state of the economy. Investment is highlighted as the most volatile of the major aggregate expenditure categories, and it is decomposed in two ways: (1) as replacement and net investment and (2) into its three main components, fixed nonresidential, residential, and changes in business inventories.
Screencasts
• http://vimeo.com/econexcel/gdpshares: download U.S. GDP data and show that GDP = C + I + G + NX; also computes shares of GDP for C, I, and G, showing that C is the largest of the three
• http://vimeo.com/econexcel/gdpfluctuations: download real and potential GDP and the FRED add-in's graphing tool plots the two series; percentage change data are used to better illustrate fluctuations and the fact that I is volatile and primarily responsible for variability in GDP
• http://vimeo.com/econexcel/gdpinvcomponents: download three components of investment: (1) tools, plant, and equipment; (2) housing; and (3) changes in business inventories in an attempt to find the source of volatility in investment; in addition to simply plotting the three over time, they are converted into standard units.
Introduction
Every macro book has definitions of various categories of aggregate spending, along with graphics of circular flows and descriptions of the system of national accounts used to produce familiar statistics on income and output. None of this is repeated here. Instead, the focus is on obtaining GDP and its components from FRED and gaining familiarity with the current state of the economy.
The GDP.xls workbook presents only the most fundamental concepts. FRED has an absolute treasure trove of national income aggregates. It makes sense to search FRED's database and develop your own exercises and examples. In fact, FRED is so easy to use that you can safely assign open-ended discovery and exploration tasks for your students.
- Type
- Chapter
- Information
- Teaching Macroeconomics with Microsoft Excel® , pp. 112 - 118Publisher: Cambridge University PressPrint publication year: 2016