Lies, Damned Lies, and Excel Charts!

I provide links to many sources that collect data on various political phenomena because I think that describing and measuring are extremely useful tools in helping us understand politics. As Mark Twain was well aware, and as I mentioned in PLSC240 today, often-times researchers (and especially!) politicians use data and statistics to obfuscate reality rather than to illuminate. No sooner had I returned to my office than I saw the following chart on the web (courtesy of Here is a typical example of “massaging” the data to promote a preferred interpretation of political reality. Here’s the original chart:


The inference that the creators of the chart want the observer to make is that the number of instances of applause from Bush’s State-of-the-Union (SOTU) speeches has, except for a spike in the immediate pre-Iraq invasion period of January 2003, been dropping, and significantly. Notice the range of the y-axis. Why did the chart creators decide to make 55 the minimum value? I have to give them the benefit of the doubt, however, as this seems to be a built-in feature of Excel (that’s why I encourage students to start using R for graphing capabilities). When I created the chart above myself in Excel, the program chose 55 as the minimum value of the y-axis. What would the chart look like if one were to make the y-axis minimum value zero? Here’s the result:


Now, the impression made upon the observer is that the drop in applause is not that great at all, and most likely within the range of what is called “random error”. Which chart is the correct one? Well, one way of determining the right answer to this would be to compare the SOTU applause trends of other presidents. Is every president guaranteed 40 or 50 bursts of applause no matter how lame the speech is or how unpopular the president is amongst those present? If so, then a minimum value on the y-axis of 40 or 50 would be more appropriate than zero, but I don’t know the answer off-hand.