Addendum: Olympic Athlete Workbook

19 Dec


A bit of follow-up, if I may. My September 13 post (how quickly they forget) took up the matter of Olympic medal-winner birth-month distributions, and how these might compare with random, null-hypothesized percentages. The accompanying workbook was incomplete, and so I herewith make available an Excel adaptation of the Guardian’s current athlete census, appearing to number all Olympic competitors (10,384), along with medal attributions. I’ve also introduced my own birth month column to the mix, and you can get the workbook here:

 All London 2012 athletes Excel

Note that, as sorted here and as per my original Olympics piece, the last 37 Date of Birth records emobdy text, as opposed to numeric, format, and and had to be dealt with accordingly (see the relevant discussion in the September post). In any case, enjoy the data. I should add a preliminary thought-provoker or two: The August-born account for 11.6% of all medals, and I still can’t explain why 20.7% of the Chinese team members seem to have been born in January. Dodgy data? Hazy government agenda? Cohort cutoff point?

Get back to me – your guesses may be better than mine.

One Response to “Addendum: Olympic Athlete Workbook”


  1. Get the data: Olympic athletes | Help Me Investigate the Olympics - December 19, 2012

    […] Spreadsheet Journalism blog has published a set of data on all Olympic athletes from London 2012, including medals won, age, height, weight, […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: