Skip to main content Accessibility help
×
Hostname: page-component-8448b6f56d-t5pn6 Total loading time: 0 Render date: 2024-04-19T00:39:15.078Z Has data issue: false hasContentIssue false

4.2 - GDP: GDP.xls

from 4 - Macro Data with FRED in Excel

Published online by Cambridge University Press:  05 May 2016

Humberto Barreto
Affiliation:
DePauw University, Indiana
Get access

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 Documentation

Quick 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

  1. • 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

  2. • 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

  3. • 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
Publisher: Cambridge University Press
Print publication year: 2016

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

References

The epigraph is from “Concepts and Methods of the U.S. National Income and Product Accounts,” November 2012, 1–2, http://www.bea.gov/methodologies/index.htm, and answers the question, How did the NIPAs originate? It is noteworthy that the person instrumental in setting up British national income accounts, Richard Stone, also received a Nobel Prize in Economic Sciences. Establishing a coherent, reliable methodology for aggregate measures of economic performance is not trivial.
There are many sources that explain categories and computation of GDP, but an especially clear exposition can be found in Landefeld, J., Seskin, E., and Fraumeni, B., “Taking the Pulse of the Economy: Measuring GDP,” Journal of Economic Perspectives 22, no. 2 (2008): 193–216.Google Scholar
Smith, A. (1776) 1904. An Inquiry into the Nature and Causes of the Wealth of Nations. Methuen. http://www.econlib.org/library/Smith/smWN.html.

Save book to Kindle

To save this book to your Kindle, first ensure coreplatform@cambridge.org is added to your Approved Personal Document E-mail List under your Personal Document Settings on the Manage Your Content and Devices page of your Amazon account. Then enter the ‘name’ part of your Kindle email address below. Find out more about saving to your Kindle.

Note you can select to save to either the @free.kindle.com or @kindle.com variations. ‘@free.kindle.com’ emails are free but can only be saved to your device when it is connected to wi-fi. ‘@kindle.com’ emails can be delivered even when you are not connected to wi-fi, but note that service fees apply.

Find out more about the Kindle Personal Document Service.

  • GDP: GDP.xls
  • Humberto Barreto, DePauw University, Indiana
  • Book: Teaching Macroeconomics with Microsoft Excel®
  • Online publication: 05 May 2016
  • Chapter DOI: https://doi.org/10.1017/CBO9781316451014.018
Available formats
×

Save book to Dropbox

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Dropbox.

  • GDP: GDP.xls
  • Humberto Barreto, DePauw University, Indiana
  • Book: Teaching Macroeconomics with Microsoft Excel®
  • Online publication: 05 May 2016
  • Chapter DOI: https://doi.org/10.1017/CBO9781316451014.018
Available formats
×

Save book to Google Drive

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Google Drive.

  • GDP: GDP.xls
  • Humberto Barreto, DePauw University, Indiana
  • Book: Teaching Macroeconomics with Microsoft Excel®
  • Online publication: 05 May 2016
  • Chapter DOI: https://doi.org/10.1017/CBO9781316451014.018
Available formats
×