IDEAS home Printed from https://ideas.repec.org/p/dew/wpaper/2023-01.html
   My bibliography  Save this paper

One-shot Economic Mobility via Microsoft Excel

Author

Listed:
  • Humberto Barreto

    (School of Business and Leadership, DePauw University)

Abstract

This paper explains how to use a macro-enabled Excel workbook, Mobility.xlsm, to teach basic concepts about intergenerational mobility as a standalone, one-time class or assignment at the undergraduate level. The focus is on explaining the results from Chetty et al. (2014) which tracks the parent’s place in the income distribution and then their adult children’s income ranking. Simulation is used to explain the bottom-to-top transition probability and the transition matrix with strong visuals and concrete numbers. The workbook is entirely self-contained and has a series of questions to lead students through the material. This paper has suggested answers and further areas of study. Download the freely-available Excel workbook at tiny.cc/mobilityexcel.

Suggested Citation

  • Humberto Barreto, 2023. "One-shot Economic Mobility via Microsoft Excel," Working Papers 2023-01, DePauw University, School of Business and Leadership and Department of Economics and Management.
    • Handle: RePEc:dew:wpaper:2023-01
    as

    Download full text from publisher

    File URL: https://www.depauw.edu/site/learn/dew/wpaper/workingpapers/DePauw2023-01-Barreto-OneShotEconomicMobility.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Raj Chetty & Nathaniel Hendren & Maggie R Jones & Sonya R Porter, 2020. "Race and Economic Opportunity in the United States: an Intergenerational Perspective [“Intergenerational Mobility of Immigrants in the US Over Two Centuries,”]," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 135(2), pages 711-783.
    2. Barnes, William & Easton, Todd & Hanig, Ross Leupp, 2019. "Student preconceptions and reality: A survey exercise to teach wealth inequality," International Review of Economics Education, Elsevier, vol. 30(C), pages 1-1.
    3. Raj Chetty & Nathaniel Hendren & Patrick Kline & Emmanuel Saez, 2014. "Where is the land of Opportunity? The Geography of Intergenerational Mobility in the United States," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 129(4), pages 1553-1623.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Bratu, Cristina & Bolotnyy, Valentin, 2023. "Immigrant intergenerational mobility: A focus on childhood environment," European Economic Review, Elsevier, vol. 151(C).
    2. Marie Connolly & Catherine Haeck, 2024. "Intergenerational income mobility trends in Canada," Canadian Journal of Economics/Revue canadienne d'économique, John Wiley & Sons, vol. 57(1), pages 5-26, February.
    3. Katie M Jajtner, 2020. "Work‐Limiting Disability and Intergenerational Economic Mobility," Social Science Quarterly, Southwestern Social Science Association, vol. 101(5), pages 2001-2016, September.
    4. Ran Abramitzky & Leah Platt Boustan & Dylan Connor, 2020. "Leaving the Enclave: Historical Evidence on Immigrant Mobility from the Industrial Removal Office," Working Papers 2020-35, Princeton University. Economics Department..
    5. Campos-Vazquez, Raymundo M. & Krozer, Alice & Ramírez-Álvarez, Aurora A. & de la Torre, Rodolfo & Velez-Grajales, Roberto, 2022. "Perceptions of inequality and social mobility in Mexico," World Development, Elsevier, vol. 151(C).
    6. Patricia Funjika & Rachel M. Gisselquist, 2020. "Social mobility and inequality between groups," WIDER Working Paper Series wp2020-12, World Institute for Development Economic Research (UNU-WIDER).
    7. Raj Chetty & John N. Friedman & Nathaniel Hendren & Maggie R. Jones & Sonya R. Porter, 2018. "The Opportunity Atlas: Mapping the Childhood Roots of Social Mobility," Working Papers 18-42, Center for Economic Studies, U.S. Census Bureau.
    8. Elisa Jácome & Ilyana Kuziemko & Suresh Naidu, 2021. "Mobility for All: Representative Intergenerational Mobility Estimates over the 20th Century," Working Papers 302, Princeton University, Department of Economics, Center for Economic Policy Studies..
    9. Alberto Alesina & Sebastian Hohmann & Stelios Michalopoulos & Elias Papaioannou, 2021. "Intergenerational Mobility in Africa," Econometrica, Econometric Society, vol. 89(1), pages 1-35, January.
    10. García-Peñalosa, Cecilia & Petit, Fabien & van Ypersele, Tanguy, 2023. "Can workers still climb the social ladder as middling jobs become scarce? Evidence from two British cohorts," Labour Economics, Elsevier, vol. 84(C).
    11. Jason Fletcher & Katie M. Jajtner, 2021. "Intergenerational health mobility: Magnitudes and Importance of Schools and Place," Health Economics, John Wiley & Sons, Ltd., vol. 30(7), pages 1648-1667, July.
    12. Ran Abramitzky & Leah Platt Boustan & Dylan Connor, 2020. "Leaving the Enclave: Historical Evidence on Immigrant Mobility from the Industrial Removal Office," NBER Working Papers 27372, National Bureau of Economic Research, Inc.
    13. Claudia Goldin & Lawrence F. Katz, 2024. "The Incubator of Human Capital: The NBER and the Rise of the Human Capital Paradigm," NBER Chapters, in: The Economic History of American Inequality: New Evidence and Perspectives, National Bureau of Economic Research, Inc.
    14. Katie Jajtner & Matt Messel & Jason Fletcher, 2023. "Social Security Disability Insurance and intergenerational economic mobility," Contemporary Economic Policy, Western Economic Association International, vol. 41(4), pages 575-593, October.
    15. Martina Viarengo & Ugo Panizza & Enrico Nano, 2021. "A Generation of Italian Economists," CID Working Papers 400, Center for International Development at Harvard University.
    16. Kurnaz, Musab & Soytas, Mehmet A., 2019. "Intergenerational Income Mobility and Income Taxation," GLO Discussion Paper Series 409, Global Labor Organization (GLO).
    17. De Giorgi, Giacomo & Gambetti, Luca & Naguib, Costanza, 2020. "Life-Cycle Inequality: Blacks And Whites Differentials In Life Expectancy, Savings, Income, And Consumption," CEPR Discussion Papers 15182, C.E.P.R. Discussion Papers.
    18. Raymundo M. Campos-Vazquez & Eduardo M. Medina-Cortina, 2019. "Skin Color and Social Mobility: Evidence From Mexico," Demography, Springer;Population Association of America (PAA), vol. 56(1), pages 321-343, February.
    19. Marie Connolly & Miles Corak & Catherine Haeck, 2019. "Intergenerational Mobility Between and Within Canada and the United States," Journal of Labor Economics, University of Chicago Press, vol. 37(S2), pages 595-641.
    20. Erin Cottle Hunt & Frank N. Caliendo, 2023. "Social security and risk sharing: the role of economic mobility across generations," International Tax and Public Finance, Springer;International Institute of Public Finance, vol. 30(5), pages 1374-1407, October.

    More about this item

    Keywords

    teaching; pedagogy; simulation; intergenerational; transition matrix; Chetty;
    All these keywords.

    JEL classification:

    • A10 - General Economics and Teaching - - General Economics - - - General
    • A20 - General Economics and Teaching - - Economic Education and Teaching of Economics - - - General
    • D63 - Microeconomics - - Welfare Economics - - - Equity, Justice, Inequality, and Other Normative Criteria and Measurement
    • I3 - Health, Education, and Welfare - - Welfare, Well-Being, and Poverty

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:dew:wpaper:2023-01. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Manu Raghav or Humberto Barreto (email available below). General contact details of provider: https://edirc.repec.org/data/emdepus.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.