One-shot Economic Mobility via Microsoft Excel

Humberto Barreto (hbarreto@depauw.edu)

No 2023-01, Working Papers from DePauw University, School of Business and Leadership and Department of Economics and Management

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.

Keywords: teaching; pedagogy; simulation; intergenerational; transition matrix; Chetty (search for similar items in EconPapers)
JEL-codes: A10 A20 D63 I3 (search for similar items in EconPapers)
Date: 2023-06-06
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
https://www.depauw.edu/site/learn/dew/wpaper/worki ... EconomicMobility.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:dew:wpaper:2023-01

Access Statistics for this paper

More papers in Working Papers from DePauw University, School of Business and Leadership and Department of Economics and Management Contact information at EDIRC.
Bibliographic data for series maintained by Humberto Barreto (hbarreto@depauw.edu).