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.5 - Money: Money.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
Inflation is always and everywhere a monetary phenomenon in the sense that it is and can be produced only by a more rapid increase in the quantity of money than in output.
– Milton FriedmanQuick Summary
To access Money.xls, visit
http://www.depauw.edu/learn/macroexcel/excelworkbooks/Data/Money.xls.
Money.xls explains how to use the FRED Excel add-in to examine a variety of measures of the money supply and explore their relationship with inflation. Money.xls contains a Hodrick–Prescott (HP) filter function to separate trend from cycle in macro aggregates. The workbook also has data from the International Financial Statistics (IFS) on a subset of countries from which seigniorage rates can be computed. The screencasts show how to download and examine data on interest rates (including the Fisher effect) and exchange rates.
Screencasts
• http://vimeo.com/econexcel/moneyinflation: downloads various monetary aggregates (M1, M2, and MZM) and tries (and fails) to show how inflation depends on the money supply (including a ten-year moving average)
• http://vimeo.com/econexcel/moneymsi: covers the rather advanced topic of Divisia monetary services indexes (MSI)
• http://vimeo.com/econexcel/moneyseigniorage: downloads data on base money and nominal GDP to compute seigniorage rates; has data from IFS for a small subset of countries
• http://vimeo.com/econexcel/moneyfftaylor: explains how the Taylor Rule versus the federal funds rate offers a window into how the Fed views the economy; evaluates the tenures of Fed chairs since 1970
• http://vimeo.com/econexcel/moneyfisher: downloads data on interest and inflation rates, showing that they move roughly together, and then explains the relationship via the Fisher Effect
• http://vimeo.com/econexcel/moneyxrates: downloads data on real effective exchange rates produced by the Fed and the OECD; looks at the trade share weights for the United States and comments on the relationship between money supply and exchange rates
• http://vimeo.com/econexcel/moneyhpfilter: shows how to use the HP array function in Excel to separate a variable into its trend and cyclical components using the Hodrick–Prescott algorithm
Introduction
As with GDP, unemployment, and inflation, the primary focus of this section is on awareness of historical trends and current economic conditions with respect to money, interest rates, and exchange rates. The task is complicated by the fact that the money supply is not easily measured, and a core theoretical result, that inflation depends on the rate of change of the money supply, is difficult to show with data.
- Type
- Chapter
- Information
- Teaching Macroeconomics with Microsoft Excel® , pp. 130 - 138Publisher: Cambridge University PressPrint publication year: 2016