Subject: RE: HITS Triathlon Series: Napa Valley - Olympic Course : Official ThreadI took the data from last year's race and put it into Excel and did some analysis. I don't think it will let me attach the file here, it's probably too big, but I'll try. The main thing I was looking to do was find finishing times by percentile for overall, men, and women, and same for the overall time and then for the individual events. As an example, looking at the overall finish time for men and women combined: Percentile | Approximate Finish Time | 5 | 2:16:25 | 10 | 2:22:17 | 15 | 2:28:08 | 20 | 2:34:00 | 25 | 2:39:51 | 30 | 2:45:43 | 35 | 2:51:34 | 40 | 2:57:26 | 45 | 3:03:17 | 50 | 3:09:09 | 55 | 3:15:01 | 60 | 3:20:52 | 75 | 3:38:27 |
So basically my analysis shows what finishing times it took to be in the top 5%, 10%, etc. overall and individually in the swim, bike, and run, broken down by males, females, and then all competitors combined. I don't think I can attach it here so if you are interested shoot me a pm with your email and I'll email it to you. |