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.

Advertisements

One Response to “Addendum: Olympic Athlete Workbook”

Trackbacks/Pingbacks

  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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: