I was surprised to find that the size of the U.S. federal government is smaller today, than in the past many decades - let's graph it out, so it's easy to analyze...

The way I got started on this little adventure was via Jishai's graph on dadaviz.com. Here's a snapshot of it:

It was an interesting graph, but I had a few ideas about ways to change it, so that it would be better for analytics. So I found the data, copied-n-pasted it into an Excel spreadsheetimported it into SAS, and created my own version (click this graph to see the interactive version with html hover-text).

First I changed the proportions, because I think a time-series graph better represents the data when it stretches out across the page. I decided to use a stacked bar chart, rather than line/area chart, so you are visually seeing the exact yearly data, rather than interpolated lines and curves joining one year to the next - the bar chart also allows html hover-text for each bar segment so you can easily see the exact yearly values. I also changed the stacking order of the bars, so that the small (orange) legislative and judicial bar was at the bottom instead of the top. Note that the order of the colors in the legend are the same as the order of the stacked bar segments (top-to-bottom). I used the actual number of employees on the response axis (such as 5,000,000 rather than '5M') in hopes that users will grasp the magnitude more quickly. I added several footnotes at the bottom of the page to help explain the data, and labeled the 'bump' in the graph so people would know that the increase in soldiers was due to the Vietnam War.

Now that you can see the data clearly, what factors do you think impacted the reduction in the number of federal employees over the years? (feel free to leave a comment!)

Share

The Graph Guy!

Robert has worked at SAS for over 25 years, and is perhaps the foremost expert in creating custom graphs using SAS/GRAPH. His educational background is in Computer Science, and he holds a BS, MS, and PhD from NC State University. He is the author of several conference papers, has won a few graphic competitions, and has written a book (SAS/GRAPH: Beyond the Basics).

1. Automation? (I would love to see a federal spending overlay and/or size- of -state government overlay!)

• Robert Allison on

Hmm ... so, perhaps they're replacing people with computers/money?

• Yes, that was my first thought. (It seems like automation has had its way in many other business sectors with a similar outcome.)

2. If you have time, you should show the size of the government as a percentage of the total US population.