As a natural extension to the race prediction tool, http://fsgl.wni-sec.com/RacePredictions.aspx, I thought it would be good to be able to produce a figure that gives an indication of an athlete’s performance over a whole season. As a starting point, I decided on producing a theoretical average time for 10km based on a year’s results for distances 10km, 15km, 21.1km and marathon. Hence using the same algorithm as for the predictor tool but considering races for a whole season instead of just recent form, the following figures came up for some of the regular runners from the club. Also included is the 10 km figure from the race predictor tool.
A | B | C | |
---|---|---|---|
1 | Athlete | Predicted 10 km time based on recent form | 2010 form indicator (10km) |
2 | Jean Marc | 35.14 | 35.21 |
3 | James | 37.33 | 38.12 |
4 | Nico | 37.31 | 37.55 |
5 | Gerald | 36.37 | 37.54 |
6 | Mirelle | 37.21 | 37.41 |
For a first attempt, I’m quite pleased with the results as they are not a million miles away from what I would have guessed. The next race between James and Nico should be interesting, although Gerald should still be way out in front. I’m looking forward to the road season starting again so I can test and refine the algorithm.
One obvious future problem is that if someone jogs around a race, maybe to accompany a slower runner, the statistics will be distorted. A solution could be to exclude results that differ from an athlete’s average performance by more than 2 or 3 standard deviations. This is not too complicated to achieve but means I’ll have to start refining the SQL to ensure query speed is not affected.