Skip to main content Accessibility help

We use cookies to distinguish you from other users and to provide you with a better experience on our websites. Close this message to accept cookies or find out how to manage your cookie settings.

Close cookie message
×
Hostname: page-component-76fb5796d-45l2p Total loading time: 0 Render date: 2024-04-25T10:58:48.667Z Has data issue: false hasContentIssue false

3.5 - Technological Progress: TechProgress.xls

from 3 - The Solow Model

Published online by Cambridge University Press:  05 May 2016

Humberto Barreto
Humberto Barreto
Affiliation:
DePauw University, Indiana
Get access

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 Robbins

Quick 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

  1. • http://vimeo.com/econexcel/techproginitial: introduction stressing imaginary (efficiency units) and real economies

  2. • http://vimeo.com/econexcel/techprogcatchuptheory: catch-up growth and convergence; steady-state path as a magnet

  3. • http://vimeo.com/econexcel/techprogcalibrateusa: Solow Model calibrated to match U.S. economic performance in the twentieth century

  4. • http://vimeo.com/econexcel/techprogcatchupgermany: capital “destroyed” in the EqPath sheet and Germany's post–World War II performance replicated

  5. • http://vimeo.com/econexcel/techprograndom: stochastic disturbance term added via NORMALRANDOM(mean, SD)

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

  7. • http://vimeo.com/econexcel/techproggoldenrule: the Golden Rule with g > 0; as g rises, the transition period gets shorter

  8. • 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 - 104
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 Robbins, L., The Robbins Report, Higher Education Report of the Committee appointed by the Prime Minister under the Chairmanship of Lord Robbins, Cmnd. 2154 (London: Her Majesty's Stationery Office, 1963), 205, http://www.educationengland.org.uk/documents/robbins/robbins1963.html.
Barro, R., and Sala-i-Martin, X.. 1992. “Convergence.” Journal of Political Economy 100, no. 2: 223–51, http://www.jstor.org/stable/2138606. Since this seminal paper is often cited by papers on convergence at various political and geographic levels, using it to find “items that cited this item” in JSTOR (or other databases) will produce papers on convergence with examples for the classroom, such as convergence in European states and Japanese prefectures.Google Scholar
Cowen, T., and Tabarrok., A. 2011. Modern Principles: Macroeconomics. 2nd ed. Worth.
Jones, C., and Romer., P. 2010. “The New Kaldor Facts: Ideas, Institutions, Population, and Human Capital.” American Economic Journal: Macroeconomics, 2, no. 1: 224–45, http://www.aeaweb.org/articles.php?doi=10.1257/mac.2.1.224.Google Scholar
Mankiw, N. 2013. Macroeconomics. 9th ed. Worth.
Novales, A., Fernández, E., and Ruíz., J. 2009. Economic Growth: Theory and Numerical Solution Methods. Springer.

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.

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.

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.

Available formats
×