2016 U.S. population pyramid, with Baby Boom

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:

2016 pop pyramid


* I put the data file, the Census Bureau description, and the Excel file on the Open Science Framework here: https://osf.io/qanre/.

2 Comments

Filed under Me @ work

2 responses to “2016 U.S. population pyramid, with Baby Boom

  1. Vijay

    Until I saw this chart, I have never heard of the second peak around birthyear 1991.

    This figure also clearly shows the reason for the reducing “Civilian labor force participation rate (defined as 16 years and over)”. The reduction from 66% in 2007 to 63% in 2016 is shown clearly here, and that number will drop to 60% in 2025.

    Like

  2. Vijay

    also, page not found in OSf.

    Like

Comments welcome (may be moderated)

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s