ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This workbook explains population pyramids with hypothetical and real-world data.
2
It accompanies "Let’s Put Demography Back into Economics: Population Pyramids in Excel," published in The Journal of Economic Education:
3
https://www.tandfonline.com/doi/full/10.1080/00220485.2017.1397577
4
5
Software Requirements:
6
You need Microsoft Excel, Windows version 2007 or greater to get full functionality from this file.
7
The file can be opened with Mac Excel, but it uses Visual Basic code that may not be fully supported on a Mac.
8
9
You must be sure to enable macros or the buttons and scroll bars in this macro-enabled workbook will not work.
10
If you did not do so, please close the workbook and open it again, enabling macros.
11
Search "enable macros" in Excel's Help for more information on how to do this.
12
13
Key Ideas:
14
A population pyramid is an eye-catching, thought-provoking way to develop demographic literacy.
15
Simulation enables evolution of the pyramid and provides comparison of scenarios and policies.
16
17
Contents:
18
Fake: a hypothetical population is displayed and analyzed to highlight the properties of the pyramid.
19
PopPyr: directly download US Census Bureau population data by age and sex.
20
LFPR: incorporates labor force participation into the pyramid.
21
Mig: pyramids of total, native, immigrant populations
22
Lessons: offers takeway ideas and a final example of a pyramid of college-educated people in the United States.
23
24
This workbook also contains hidden sheets and Visual Basic code modules.
25
26
Thanks to Frank Howland for early conversations and discussion, especially on Cuba, and for solving for the long run rate of growth;
27
Andrew Pinney for help on understanding estimates of Afghanistan’s population; Peter Johnson for alerting me to the API call;
28
and Guangjun Qu, Guglielmo Volpe, Jonathan Lhost and two anonymous JEE referees for comments and suggestions.
29
30
All questions, comments, and suggestions welcome.
31
Humberto Barreto
37
32
hbarreto@depauw.edu
33
7-Aug-17
34
Updated (IDB changed API)
35
31-Jul-19
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100