« 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.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Marketing analytics and data visualization expert. Author and Speaker. Currently at Columbia. See my full bio.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Good Books

Keep in Touch

follow me on Twitter