Showing posts with label time series. Show all posts
Showing posts with label time series. Show all posts

Tuesday, June 11, 2013

Assignment 2: Substance over Methodology — Freedom in the World

"Graphical displays should … induce the viewer to think about substance rather than about methodology, graphic design, the technology of graphic production, or something else"
— Edward Tufte, The Visual Display of Quantitative Information


I'm using one of my favorite data sets today to explore a particular challenge: How do you clearly illustrate meaning in data that don't have intrinsic meaning? Put another way, how do you explain the methodology behind data without distracting from what the data have to say?

The data in this case come from an index — Freedom House's annual Freedom in the World index, which scores every country in the world based on civil liberties and political rights. It's a very popular and useful tool for foreign policy writers and researchers who want to compare different governments to each other or look at governance trends over time.

Like any scoring system, though, it uses a manufactured scale to rank qualities that are not easily quantifiable. In order to understand what the scores say about freedom, first you have to understand how the scores are created.

I've seen (and tried) several different approaches to graphing Freedom House scores, and every approach has pros and cons. Trend lines are most common for charting scores over time, although the Washington Post recently opted for columns to show scores for Iraq and Afghanistan. One drawback is that we're used to associating upward-sloping trend lines with positive changes, and in Freedom House's index higher scores actually mean less freedom. If you keep an ascending scale on the y axis, it might take readers a moment to realize a downward dip in scores is really a good thing.

When I was in graduate school I made a lot of these:



I liked this approach because the inverted y-axis values give gains in freedom an upward-sloping line. The colored regions show clearly whether a country is classified as "Free," "Partly Free" or "Not Free" without leaving the reader to interpret the scores. If I were making this chart today, I might leave the scores off the y axis entirely since they draw attention to Freedom House's methodology when the real take-away is the trend line. But, if you're really interested in how Freedom House rated Ukraine each year, the scores are there to see.

Back to the chart at the top of the post. Like everything on this blog, it's an experiment. Instead of an up-and-down trend line (does freedom go up and down? I guess it does when you assign scores to it), I wanted to try showing different levels of freedom by color only. The red-yellow-green scheme is widely recognized and familiar — green is good, red is not good, yellow is somewhere in the middle.

It's still hard to graph Freedom House's index without some explanation of the scoring methodology. See all the notes I added to the top chart just to feel like I was being thorough? And they don't even go into all the changes Freedom House has made to its methodology over the years.

One thing I might have done differently: The green, yellow and red areas on this chart don't correspond exactly to Freedom House's "Free," "Partly Free" and "Not Free" classifications. Freedom House's "Partly Free" rating encompasses scores of 3.0 to 5.0. On my chart, 3.0 is still pretty green and the true yellow doesn't show up until 4.0. Looking at it now, I feel it might be more important to show the three broad classifications more clearly than to show a continuous and symmetrical color gradient.

Data Source: Freedom House Freedom in the World data, 1972-2012.

Chart Tools: Adobe Illustrator (top chart), Microsoft Excel and Word.

Tuesday, May 21, 2013

Assignment 1: Show the Data — U.S. Federal Budget

There have been a lot of stories coming out of Washington lately, and the federal budget really hasn't been one of them. That will likely change soon. As of May 15 Congress can begin considering appropriations bills for the 2014 fiscal year, meaning between now and September we can expect to hear more about how much money federal agencies will have to spend in the coming year.

Despite its seemingly unlimited pockets, Congress is required to abide by specific spending limits each year. Who sets these limits? The President's Budget gets a lot of attention when it's released each February (or April as was the case this year), but these budget recommendations are just that — recommendations. Congress actually sets its own spending limits with an annual budget resolution, usually passed in April.

By law, once the president has released a recommended budget, both the Senate and the House of Representatives draw on that document and their own priorities to draft separate budget resolutions. Once each house approves its own resolution, they swap notes and hammer out their differences in a report that becomes a binding outline of next year's spending. The final budget resolution is the basis for appropriations bills that portion out money to specific agencies.

Of course nothing's straightforward in the Congress, and lawmakers have failed to agree on a final budget resolution for the last three fiscal years. A budget resolution for 2014 also appears to be dead in the water. 

So how much does Congress have to spend in 2014? Well, it depends where you look.

Fiscal Year 2014 Outlays by Category (in millions of dollars)
Technically, when Congress fails to pass a budget resolution the previous year's resolution remains in effect. The last successful budget resolution was Senate Concurrent Resolution 13 (S.Con.Res. 13 ENR). It was passed for the 2010 fiscal year but includes spending levels for 2011 through 2014. In years when no final budget resolution is passed, the House sometimes formally adopts its own resolution as binding for the purposes of making appropriations.

The charts above show spending levels for 2014 outlined in S.Con.Res. 13 alongside those proposed by the House and the Senate in separate resolutions this spring. None of these is a definitive guideline for next year's appropriations, but it's fun to compare them.

It's also fun to compare spending levels for each category over time.

Notice how Homeland Security got its own spending category in 2005. The Overseas Contingency Operations/Global War on Terror category was originally called Overseas Deployments and Other Activities when it showed up in the 2008 budget.

U.S. Federal Budget Outlays by Category, 2000-2012 (in millions of dollars)

Data Sources: 2014 - S.Con.Res. 13 ENR (111th Congress), H.Con.Res. 25 PCS, (113th Congress); S.Con.Res. 8 ES (113th Congress); 2012 - H.Con.Res. 34 (112th Congress); 2011 - H.Res. 1493 (111th Congress); 2010 - S.Con.Res. 13 ENR (111th Congress); 2009 - S.Con.Res. 70 ENR (110th Congress); 2008 - S.Con.Res. 21 ENR (110th Congress); 2007 - H.Con.Res. 376 EH (109th Congress); 2006 - H.Con.Res. 95 ENR (109th Congress); 2005 - S.Con.Res. 95 (108th Congress); 2004 - H.Con.Res. 95 ENR (108th Congress); 2003 - H.Con.Res. 353 EH (107th Congress); 2002 - H.Con.Res. 83 ENR (107th Congress); 2001 - H.Con.Res. 290 ENR (106th Congress); 2000 - H.Con.Res. 68 ENR (106th Congress).
Accessed through THOMAS between May 14, 2013, and May 20, 2013.

Chart Tool: Google Docs