 |
Re: [RC] [AERC-Members] Multiday/Single day ride speed analysis - Truman PrevattThe rides were different days - hence different rides as recorded in the database. So the ride results don't use the same ride repeately. It may turn out that the multiple days of a specific pioneer event show which was the case - but they were different rides on different days. In the spread sheet this was taken from the ride ID and distance ID were included. For a pioneer ride the ride ID is the same for each day but the distance ID is different. That is the ride ID and distance ID map one to one to a physical ride on a specific day. I eliminated these columns in order to get the data across the sheet. I can forward the original spread sheet if you want to see which days it was.There is no way from the database to know what trail is used or if the same trail is used twice, etc., terrain or any other ancillary data on the rides. I do know that for example the BSF uses completely different trail on the second day than the first and the two days are totally different types of trail and different types of rides. One clearification on "fastest times." Although the whole study was concerned with average ride time and the verbage in the paragraph at least one person took it to mean finishing time for the fastest ride. It was based on average ride time not winning ride time. To some extend the data is what the data is and on the average you would expect the terrain, weather, etc. over that many rides in the same geographic areas to average out. If the there is some fundamental difference on the trails for all the multidays or single days, the database does not reflect this. There may be some merit in combining days of a ride if the trail is exactly the same and all the riders are the same. But different trail same riders or different riders same trail need to be taken as unique. However, none of that would have changed the overall average ride times since the average pioneer ride time was on every riders that finished a pioneer day (module the condition stated in the study) and likewise for single day. The only place that would have made any difference at all is in the chart. Truman renegade12@xxxxxxxx wrote: Truman, When I reviewed your 50 fastest times, I see that 9 of the 50 different rides are rides I manage. I suspect the 9 ride results are probably are the same trails or combinations of those trails, but for different rides I manage...that being the case, it would seem that your statistics are kind of skewed. It think it would be more accurate to use entirely different ride results than repeating results for the same trails - what I mean - by using my ride results repeatedly, which equal nearly 20% of your total data, that you are not getting a true picture of the information (Desert Moon, EP-LC I&II, Cow Tanks I-II-III, NMRR, etc). Statistics can show whatever the statistician wishes and I know that is not what you are trying to do, but using the same basic ride results repeatedly may not accurately reflect what you really want to show. Randy Eiland On Wed, 09 Jul 2003 13:13:51 -0400 Truman Prevatt <tprevatt@xxxxxxxxxxxxxx> writes:An analysis of the ride speeds of multiday rides vs. signal day rides has bee concluded and there are some surprises lurking in the official ride times. The report is located at: http://www.homestead.com/qsendurance/files/MDSDridetimes2002.pdf Truman-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=- -= Discussion List Archives: http://www.goldhill.com/members/index.html =- -= Subscribe/Unsubscribe: mailto: AERCMembersForum-moderator@xxxxxxxxxxxx =- -= Rules of Usage: http://www.goldhill.com/members/index.html =- -= Terms of Usage & Liability: http://www.goldhill.com/members/liability.html =--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-
|