Welcome to the Speedsolving.com, home of the web's largest puzzle community! You are currently viewing our forum as a guest which gives you limited access to join discussions and access our other features.

Average of everybody's best average at the competition:

Code:

WC2003 21.45
WC2005 19.59
WC2007 27.62
WC2009 25.61
WC2011 22.45
WC2013 24.02
SELECT competitionId, sum(bestAverage)/count(*)/100 FROM
(SELECT competitionId, min(average) bestAverage FROM Results
WHERE competitionId like 'WC20%' and eventId='333' and average>0
GROUP BY competitionId, personId) tmp
GROUP BY competitionId
ORDER BY competitionId

I'm not sure that claim can be made with this ammount of data, for a specific competition. You should probably widen that average of averages calculation to the entire number of competitions that take place every year (like "Average of averages recorded in 20??" ). But still on the (WC* - WC1982), you should post the standard deviation for these results also.

Average of everybody's best average at the competition:

Code:

WC2003 21.45
WC2005 19.59
WC2007 27.62
WC2009 25.61
WC2011 22.45
WC2013 24.02
SELECT competitionId, sum(bestAverage)/count(*)/100 FROM
(SELECT competitionId, min(average) bestAverage FROM Results
WHERE competitionId like 'WC20%' and eventId='333' and average>0
GROUP BY competitionId, personId) tmp
GROUP BY competitionId
ORDER BY competitionId

Also don't forgert that there were twice more competitors at WC 2013 than at the previous WCs, and since the fast guys will always be there, more competitors means slower competitors on average.

(And WC 2003 and 2005 results are meaningless because only the fastest people got an average (first two rounds in 2003 and first round in 2005 were best of 3).

Also don't forgert that there were twice more competitors at WC 2013 than at the previous WCs, and since the fast guys will always be there, more competitors means slower competitors on average.

(And WC 2003 and 2005 results are meaningless because only the fastest people got an average (first two rounds in 2003 and first round in 2005 were best of 3).

I'm not sure that claim can be made with this ammount of data, for a specific competition. You should probably widen that average of averages calculation to the entire number of competitions that take place every year (like "Average of averages recorded in 20??" ). But still on the (WC* - WC1982), you should post the standard deviation for these results also.

Also don't forgert that there were twice more competitors at WC 2013 than at the previous WCs, and since the fast guys will always be there, more competitors means slower competitors on average.
(And WC 2003 and 2005 results are meaningless because only the fastest people got an average (first two rounds in 2003 and first round in 2005 were best of 3).

You should probably widen that average of averages calculation to the entire number of competitions that take place every year (like "Average of averages recorded in 20??" ).

Hi!
It's possible to create a stat that show a mean of the singles progressions of all the 4BLDer in the official WCA table? I'l read "in 1 year, in average the PB are broken by x minutes" or something like this. It's difficult to say in english for me. Like the "misc" zone in the WCAs site but with a mean of all the 3BLD/4BLD and 5BLD personal records, not only the WR. It's possible?