« A matter of timing | Main | Turning in his grave 2 »


Jon Peltier

The problem with periodic percentage change is that the overall (cumulative) trends in the data are washed out by the periodic fluctuations.

Michael Galloy

I had to interpolate data values from your plots, so my data might be off.

Connecting the data points highlights the zig-zagging. A standard scatter plot and the correlation of -0.62 seem to indicate a fairly strong negative correlation between volume and crashes for this type of data.

Stephen Hampshire

I agree with Michael - why join the dots in the scatter plot?

Seems to me the scatter plot is both the correct and the most visually effective chart in this case.


I'm agreeing with Michael in the previous post's comments. Why not plot rates (crashes/volume)? Volume is an imperfect, but reasonable measure of exposure to the risk of a bicycle crash/fatality.

Michael Galloy

Yes, I like the idea to plot volume vs. crashes/volume. Here's the scatter plot, r = -0.84.


It's a matter of what question you're trying to answer. If we are looking for a functional relationship between accidents and volume, then yes, a scatter plot without lines works better. In this case, and in most social science situations, the time dimension is important. The line serves to expose any trends; in this case, it's hard to tell. Plus, the time series is too short.

Michael: great to see another reader making your own charts!


There's a reason to join the time points in the scatterplot. It does provide insight.

Note that the points primarily go counter-clockwise.

As Krider, et al. note (Marketing Science, 2005) the counter-clockwise pattern is associated with Y causing X -- or, more conservatively, evidence that it's not X [bike volume] causing Y [fewer bike accidents].

As a frequent bicyclist myself, I will make two non-graphical comments:

(1) Overall bicycle safety is likely to be improved with additional bicyclist volume -- vehicles are more likely to be aware of bicyclists.

(2) But, increased volume can lead to a bunch of newbys who THINK they know how to ride in traffic and end up running lights, passing trucks on the right and other forms of unsafe behavior.

The comments to this entry are closed.


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR.

See my Youtube and Flickr.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Keep in Touch

follow me on Twitter