I’m finishing up revisions for the second edition of The Family, and that means it’s time to update the population pyramids.
Because it’s not so easy (for me) to find population by age and sex for single years of age for the current year, and because there is a little trick to making population pyramids in Excel, and because I’m happy to be nearing the end of the revision, I took a few minutes to make one to share.
The data for single year population estimates for July 1, 2016 are here, and more specifically in the file called NC-EST2016-AGESEX-RES.csv, here. To make the pyramid in Excel, you multiply one of the columns of data by -1 and then display the results as absolute values by setting the number to a custom format, like this: #,###;#,###. Then in the bar graph you set the two series to overlap 100%.*
In this figure I highlighted the Baby Boom so you can see the tsunami rolling into the 70s now. Unlike when I discuss cohorts previously, when I let it slide, here I actually adjusted this from what you would get applying the official Baby Boom years (1946-1964) with subtraction from 2016. That would give you ages 52 to 70, but the boom obviously starts ate age 69 and ends at age 51 here, so that’s what I highlighted. Maybe this has to do with the timing within years (nine months after the formal end of WWII would be May 2, 1946). Anyway, this is not the official Baby Boom, just the boom you see.
Click to enlarge:
* I put the data file, the Census Bureau description, and the Excel file on the Open Science Framework here: https://osf.io/qanre/.