I think I'm taking this "dead horse" topic from a different angle. I'm not asking if my average speed is good, or trying to impress anybody with my speed (or lack there of). I'm analyzing my average speed with all of my bikes over a specific Strava segment. I'm posting this to find out if I'm leaving any holes in my 'logic' as I analyze bikes and there relative speeds. Please look it over and let me know your thoughts.

For starters, I selected a segment near my house that I ride a ton (354 times). The segment is long enough (1.4 miles) and diverse enough (hilly and twisty) to be a good caparison.

Here is what I came up with:



I forgot to include a header row, the right most column is number of rides over the segment; to the right of Total Dist is the sum of distances for the count; to the left of the Total Time is the sum of times for the count; and Ave Speed fields are calculated by dividing Total Dist by Total Time (not averaging the average speed).

For reference, here are the bikes in this analysis:


Left to right: Kona Dew Drop, Mondonico, Felt Z85, Marin Nail Trail, Surly Pugsley, Globe Daily

My surprising take away is that the Felt (newer AL frame) has such an advantage on the Mondonico (classic steel frame). The Mondonico is the new (to me) bike and that may be the fact that I haven't ridden it as many times. Plus I spent last summer making lots of little tweaks and upgrades, so many of the rides were shake-down rides, not aggressive rides.