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
- 3.1 Introduction
- 3.2 Capital Accumulation: KAcc.xls
- 3.3 The Golden Rule: GoldenRule.xls
- 3.4 Population Growth: Population.xls
- 3.5 Technological Progress: TechProgress.xls
- 4 Macro Data with FRED in Excel
- 5 The Keynesian Model
- References
3.5 - Technological Progress: TechProgress.xls
from 3 - The Solow Model
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
- 3.1 Introduction
- 3.2 Capital Accumulation: KAcc.xls
- 3.3 The Golden Rule: GoldenRule.xls
- 3.4 Population Growth: Population.xls
- 3.5 Technological Progress: TechProgress.xls
- 4 Macro Data with FRED in Excel
- 5 The Keynesian Model
- References
Summary
If a series of nuclear explosions were to wipe out the material equipment of the world but the educated citizens survived, it need not be long before former standards were reconstituted; but if it destroyed the educated citizens, even though it left the buildings and machines intact, a period longer than the Dark Ages might elapse before the former position was restored.
– Lionel RobbinsQuick Summary
To access TechProgress.xls, visit
http://www.depauw.edu/learn/macroexcel/excelworkbooks/SolowModel/TechProgress.xls
TechProgress.xls is the last of the workbooks in the Solow Model series. It includes population growth and exogenous, constant technological change. The EqPath sheet enables straightforward simulation to reveal clearly the steady-state solution in both efficiency and own units of per worker variables. Sophisticated comparative statics analyses, including transitional dynamics, can be easily performed. Real-world, Maddison data are used to calibrate and “test” the model. These applications are interesting, enjoyable, and thought provoking.
Screencasts
• http://vimeo.com/econexcel/techproginitial: introduction stressing imaginary (efficiency units) and real economies
• http://vimeo.com/econexcel/techprogcatchuptheory: catch-up growth and convergence; steady-state path as a magnet
• http://vimeo.com/econexcel/techprogcalibrateusa: Solow Model calibrated to match U.S. economic performance in the twentieth century
• http://vimeo.com/econexcel/techprogcatchupgermany: capital “destroyed” in the EqPath sheet and Germany's post–World War II performance replicated
• http://vimeo.com/econexcel/techprograndom: stochastic disturbance term added via NORMALRANDOM(mean, SD)
• http://vimeo.com/econexcel/techprogcompstatics: explores the effects of shocks in n, s, and g on the level and growth rate of steady-state y
• http://vimeo.com/econexcel/techproggoldenrule: the Golden Rule with g > 0; as g rises, the transition period gets shorter
• http://vimeo.com/econexcel/techprogconvergence: shows why CAGR as a function of log y is used; shows that the predicted relationship fails for large samples but is better for more similar countries
Introduction
Teaching and learning the Solow Model effectively and comprehensively is hard work. TechProgress.xls is the third (and final) step in a progression of models. Starting from the most primitive version of the model presented in KAcc.xls, a nonzero, constant rate of population growth was added in Population.xls.
- Type
- Chapter
- Information
- Teaching Macroeconomics with Microsoft Excel® , pp. 92 - 104Publisher: Cambridge University PressPrint publication year: 2016