GaryvdM Posted January 16, 2014 Share I allways wonder where I am on the results bell curve. So I hacked up a racetec screen scraper, import csv to libreoffice calc, and vola, a bell curve:I also thought that it would interesting to see each group on the bell curve, but unfortunately it's unreadable. (Dito for age groups)One thing you can see from this is that the earlier groups have much bigger bunches. Looking at only a few groups at a time is quite interesting though: I'll see if I can come up with a way for you to turn individual groups on/off.Each data point is 2 minutes. e.g. the for the first data point, 26 riders finished between 2:08:00 and 2:09:59. P.s. Agteros: Sorry I cut your time off the graph, but otherwise it would have to be 3 times bigger Edited January 16, 2014 by GaryvdM Agteros, DPLot, Gavmeister and 1 other 4 Link to comment Share on other sites More sharing options...
Zatek Posted January 17, 2014 Share Nice work. Nice to know I am faster than the avg cyclist. Link to comment Share on other sites More sharing options...
kennyg Posted January 17, 2014 Share cycle nerd.... but interesting none the less, GaryvdM 1 Link to comment Share on other sites More sharing options...
Ryinc Posted January 17, 2014 Share Gary this is really cool, I have a few suggestions.1. Increase the 2 min bin width to smooth the data a bit.2. Change the y-axis to be a percentage- easier to interpret and compare e.g across groups3. Show another version of the graph which shows cumulative distribution I.e total % of people finished by x time- would make it nice to see for example if I improve my time by say 5 minutes my position in distribution would change by say 6%.4. It would be really cool to see the distribution for a couple of years. GaryvdM 1 Link to comment Share on other sites More sharing options...
Cav' Posted January 17, 2014 Share Cool man Link to comment Share on other sites More sharing options...
rouxtjie Posted January 17, 2014 Share good stuff.... Link to comment Share on other sites More sharing options...
Agteros Posted January 17, 2014 Share As far as I know there were only two times slower than 10 hours. Could you do a bar graph on group sizes? Link to comment Share on other sites More sharing options...
Squier Posted January 17, 2014 Share Cool stuff! Thanks Link to comment Share on other sites More sharing options...
Capricorn Posted January 17, 2014 Share voila.. Link to comment Share on other sites More sharing options...
Pure Savage Posted January 17, 2014 Share May as well do one for us guys in Cape Town and do the same for the Argust Would be interesting to see! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now