The Wall Street Journal claims federal employment, excluding postal workers, is the “lowest total in seven years” and includes the following chart.
Because this is a surprising factoid, I posted it on Facebook. After receiving a comment that 1.6% is probably off by a decimal, I started to question the data. I headed off to the Bureau of Labor Statistics’ web site to see if I could duplicate the WSJ’s chart.
Here is the BLS chart of federal employment excluding postal workers.
This doesn’t match the Wall Street Journal’s chart, not even close. Yeah, there’s the huge bump for World War II, but the trends don’t match. This chart shows federal employment steadily increasing until the early ’90s instead of generally decreasing since the mid-’50s. That’s when I noticed that the Wall Street Journal plotted federal workers as a percentage of total non-farm employment, not as an absolute number.
So, what is total non-farm employment? Here is the BLS chart of non-farm employment, which shows a steady rise until the turn of the millennium.
Now, all I need is an easy way to divide the first chart by the second chart…
Getting both data series using the BLS series report tool wasn’t that hard. Nor was creating a spreadsheet that contained both and then dividing government employment by total non-farm employment. Surprise — the Wall Street Journal didn’t slip a decimal.1
Now for the chart I created:
Ha! Looks pretty close to the WSJ’s.2 Good to know.
2The blips every ten years in my chart are probably census employees, which the WSJ eliminated from its chart…somehow.