• 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.

    Registration is fast, simple and absolutely free so please, join our community of 35,000+ people from around the world today!

    If you are already a member, simply login to hide this message and begin participating in the community!

Odd WCA stats/ Stats request Thread

Stefan

Member
Joined
May 7, 2006
Messages
7,287
WCA
2003POCH01
YouTube
StefanPochmann
Darn, speedcubing is getting worse again:

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
 

cubizh

Super Moderator
Staff member
Joined
Oct 2, 2011
Messages
602
Location
Portugal
WCA
2014GOME07
YouTube
cubizh
Darn, speedcubing is getting worse again:
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.
 

AvGalen

Premium Member
Joined
Jul 6, 2006
Messages
6,857
Location
Rotterdam (actually Capelle aan den IJssel), the N
WCA
2006GALE01
YouTube
arnaudvg
Darn, speedcubing is getting worse again:

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 wonder where you got that idea ;)
 

TMOY

Member
Joined
Jun 29, 2008
Messages
1,802
WCA
2008COUR01
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).
 

rj

Member
Joined
Mar 26, 2013
Messages
1,445
Location
Rochester, NY
WCA
2015PLAT03
YouTube
rjdayan
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).

Wait, WC 2013 was the biggest?
 

Stefan

Member
Joined
May 7, 2006
Messages
7,287
WCA
2003POCH01
YouTube
StefanPochmann
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).
No, no, no, my analysis and report are perfectly fine and clearly demonstrate the lack of competitiveness among today's cubers.

I wonder where you got that idea ;)
I have absolutely no idea what you're talking about.
 

cubizh

Super Moderator
Staff member
Joined
Oct 2, 2011
Messages
602
Location
Portugal
WCA
2014GOME07
YouTube
cubizh
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??" ).
s/You/I

Actually Stefan is correct up until now :)
 

Cubo largo

Member
Joined
Nov 14, 2012
Messages
99
Location
Italy
WCA
2013AZZI01
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?
 

cubizh

Super Moderator
Staff member
Joined
Oct 2, 2011
Messages
602
Location
Portugal
WCA
2014GOME07
YouTube
cubizh
Thank you cubizh, I may ask for some thing that has been replied yet, but I wonder... Is there any graph of growth of cubing population? Thanks ;-)
http://www.speedsolving.com/forum/showthread.php?26121-Odd-WCA-stats-Stats-request-Thread&p=893086&viewfull=1#post893086

Which comp had the least amount of competitors?
I believe this has been asked before.
There are two competitions with 3 competitors: ChinaFM2011Shenyang and ChinaFM2011Zhengzhou.
 
Last edited:

Sebastien

Premium Member
Joined
Apr 22, 2008
Messages
800
WCA
2008AURO01
All competitions with less than 10 competitors:

1. ChinaFM2011Shenyang 3
1. ChinaFM2011Zhengzhou 3
3. ChinaFM2011Guangzhou 6
4. DutchOpen2003 7
5. ValgaOpen2013 8
6. WaikatoAutumnOpen2010 9
6. AvalonOpen2013 9
6. JordanOpen2012 9
6. ChalmersOpen2005 9
6. BogorOpen2013 9
6. PuyDeDomeOpen2010 9
 

cubizh

Super Moderator
Staff member
Joined
Oct 2, 2011
Messages
602
Location
Portugal
WCA
2014GOME07
YouTube
cubizh

CompetitionID

Country

Competitors

Year

ValgaOpen2013

Estonia/Latvia(?)

8

2013

BogorOpen2013

Indonesia

9

2013

AvalonOpen2013

France

9

2013

BergshamraBlind2013

Sweden

10

2013

HaNoiBigCube2013

Vietnam

12

2013

CupcakeCubing2013

Australia

13

2013

MILOpen2013

France

15

2013

Bandungan2013

Indonesia

15

2013

Valparaiso2013

Chile

16

2013

ApogeeOpen2013

India

16

2013

TriesteOpen2013

Italy

16

2013

 
Top