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.4 - Population Growth: Population.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
In 1830, no general work in economics would omit a discussion of population, and in 1930, hardly any general work said anything about population.
– George StiglerQuick Summary
To access Population.xls, visit
http://www.depauw.edu/learn/macroexcel/excelworkbooks/SolowModel/Population.xls
Population.xls extends the basic model used in KAcc.xls and GoldenRule.xls by adding population growth. The basic framework remains the same, so the canonical graph is used again and the EqPath sheet continues to offer quick simulation to reveal clearly the steady-state solution and perform sophisticated comparative statics analyses. The workbook also contains data on population from three sources, including direct access (from within Excel) to a website with international data from the U.S. Census Bureau.
Screencasts
• http://vimeo.com/econexcel/popworld: world population growth since 1950 and log scale to show it has not grown at a constant rate
• http://vimeo.com/econexcel/popvariouscountries: population growth in various countries with log scale to show differences in growth; effect of European conquest on indigenous peoples
• http://vimeo.com/econexcel/popmalthus: data on England's population; direct editing of SERIES formula to modify a chart
• http://vimeo.com/econexcel/poppyramid: creating a population pyramid chart by accessing U.S. Census data directly from within Excel; animating chart; sex ratio at birth
• http://vimeo.com/econexcel/popproject: forecasting via extrapolation; PivotTable to do a cohort component projection (including how the population pyramid chart is made); conditional formatting; discussion of carrying capacity
• http://vimeo.com/econexcel/popsolowmodel: steady-state solution via simulation and comparative statics using the Scenario Manager
• http://vimeo.com/econexcel/popfastslown: exploring the ratio of output per worker in two countries with different n, ceteris paribus
• http://vimeo.com/econexcel/popgoldenrulepopgrowth: the Golden Rule in the Solow Model with n > 0
• http://vimeo.com/econexcel/popconvergence: speed of convergence and half-life via Excel's MATCH function
Introduction
The basic model in KAcc.xls showed that capital accumulation produces growth while catching up to the steady-state but cannot explain the persistent growth in real GDP per person enjoyed by some countries over the last few hundred years. Population.xls, the basic model with positive population growth, will show that differences in population growth can explain some of the variation in real GDP per person observed across countries.
When a constant population growth rate parameter, n, is added to the model, the canonical graph retains its basic look and feel, but now the intersection of (n + δ)k (instead of simply δk) and sf(k) yields the steady-state solution.
- Type
- Chapter
- Information
- Teaching Macroeconomics with Microsoft Excel® , pp. 81 - 91Publisher: Cambridge University PressPrint publication year: 2016