Evolution of statistical graphics and visual analytics at JSM 2012

At the Joint Statistical Meetings in San Diego this week, I attended a panel on The Evolution of Statistical Graphics and Visual Analytics.

The panelists, Antony Unwin, Hadley Wickham and Michael J. Kane all commented on this graphic from The New York Times.

 

 

There was a lot of discussion about what the graph represents (a projection of a non-parametric relationship) and how viewers might interpret it (they may initially think time is on the X axis), but I was disappointed that there wasn't an exploration of how the author, Hannah Fairfield, may have arrived at this representation.

I wanted to explore this data to see what other views of the relationships represented above look like.

I wasn't able to get the original source data, so I had to synthesize the data from the graph. As a result, my data may not line up exactly with the actual values, but it's close enough to see what the graphs show. You can download my JMP data table from the File Exchange (requires free SAS profile).

Usually, when looking at data with a time element, our first instinct is to put the time value on the X axis and the measures on the Y. Since we have two measures, miles driven and price of gas with very different scales, I initially thought that a graph with a dual Y axis would be a good way to compare the relationship between these measures over time.

I'm not really happy with this, though. The overlapping lines don't really tell the story. I could probably adjust the scales of the Y axes to provide some separation, but if I'm going to do that, I might as well show two graphs with a common X axis.

 

That's a little better. It's easier to see the two trends, but I'm not really seeing the relationship between miles driven and the price of gas. Perhaps I should graph these two variables directly.

During the panel, Antony Unwin thought it curious that the "response," miles driven, wasn't shown on Y axis in The New York Times graphic. As I began to explore the relationship, I thought of miles driven as the response as well and put it on the Y axis. I also added a smoother to help the pattern in this data.

Now, we're getting somewhere! The smoother shows that there's a relationship between the price of gas and the number of miles driven, but it's awfully noisy, and there are clearly two groups of points in this data. Also, this graph leaves out the time variable, so we're losing some potentially illuminating information.

What if I connect the points in time order?

 

 

Now, because I'm getting fairly familiar with this data, I'm able to see the time series trend moving upward along the Y axis, but I suspect that a casual observer won't spot that very quickly since we're not used to seeing time move vertically in a graph.

So, I should swap the X and Y axes, and that gets me to the original graph from The New York Times.

This is interesting data because there are two time series trends: Miles driven has generally been increasing over time, and the price of gas has mostly been falling over time with a few noticeable exceptional periods. Trying to visualize both of these trends and see the exceptions is the key to this graph.

A colleague who attended the panel discussion with me suggested that an animated bubble plot was an obvious choice for this data. I don't usually like animation when I only have one series of data over time since it just delays my ability to see the whole series. I've created that bubble plot below. What do you think?

tags: Data Visualization, JMP - General, Statistics

2 Comments

  1. Andrew
    Posted August 2, 2012 at 1:54 pm | Permalink

    I believe that having price on the x-axis makes more sense because one generally assumes that the price of gas affects the number of miles driven, not the opposite.

  2. Posted August 3, 2012 at 9:12 am | Permalink

    I think the two separate time series (graph #2) provide important context, showing that the two values have their own time trends and are largely independent. Miles driven keeps going up with only minor hiccups, regardless of gas price. There must be other factors more heavily influencing miles driven, such as economic growth, urbanization or fuel efficiency.

    The story of the NYT visual is hidden in the call-outs, which focus on the changes over smaller time intervals. If you look at the deltas for miles and price, there is a significant correlation between them except for one outlier, 2009. And that's the punchline of the story: the current swing is different.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <p> <pre lang="" line="" escaped=""> <q cite=""> <strike> <strong>