Odd WCA stats/ Stats request Thread

TMOY · Jul 29, 2012

It's also worth to notice that Asia is much larger than Europe. From Paris I only have to travel a couple of hours by train to reach most of the comps I'm attending. Things may not be that easy for someone living in Asia.

qqwref · Jul 29, 2012

Stefan said:
How about such a ranking but you don't take each country's best person's rank but only consider countries? For example for 2x2x2 single, Italy would score 1, Netherlands 2, USA 3 and so on (ignoring that Italy has the top three persons).

Sounds good.

Singles:

Code:

id               rsum   222   333 333bf 333fm 333ft 333mbf 333oh   444 444bf   555 555bf   666   777 clock magic  minx mmagic pyram  sq1
USA               117     2     9    12     4    13     12     8     7     8     3     5     1     3     6     5     6      1     7    5
Hungary           120    16    14     1     2     9      3    13     9     1    11     1     6     4     8     7     2      3     1    9
Poland            125     5     2     3    10    15      1     1    20    12     5     9     3     2    10     7     7      7     4    2
China             144    14    15     2     8    11      8     9     5    14    14     8     4     1     1     1    10      2    16    1
Japan             165    17     5    21     1     6     18     3     4    18     1    17     5     5     4    11    13     11     2    3
Germany           181     6     5    17     4    17      6    11     2    10    12     6     9    13    11     7    15      4    11    15
Indonesia         213    15     5     6    12     1      7    12    12    13    17     4    26    16     9     5    21      8     3    21
United Kingdom    215    10    10    15    10    20      5    24    16     2     7     2    10    10     4    22    19     15    10    4
Netherlands       217     2     4    23     4     8     20     6     1    20     9    20    11    12     7    15    17     22     9    7
Thailand          233     8     3    11    22     5     16     7     8    31     4    22    12     9    13    11    10     16     8    17
Australia         252     9     1     5    27    46      2     4     3     3     2     7     2     8    22    21    14     39    15    22
Sweden            276    17    18    19    12    16     11    21    11    15    15    15    20    17    19     2     1     26    11    10
Italy             277     1    13     8    20    23     10    25     6     5    10    16    15    18    23    11     5     18    23    27
France            284    11    12    16     4    22     13    17    20    16    18    14    24    29     3    18    25      5     6    11
Canada            297     7    11    20    17    12     14    15    19    26     6    22    14     6    17    24    12      9    26    20
Russia            333    12    20    25    12    25     17     5    30    11    28    13    27    22    20     2    29      5    17    13
Malaysia          369    26    24    10    22    32      4    28    15     4    20    11    28    20    39    24     3     32    21    6
Spain             373     4    16     7    17    34     24    27    14    23    26    22    16    21     2    18    31     19    24    28
Denmark           383    21    37    31    12     2     25    10    34    17    30    12    25    26    24    15     4     27     5    26
Taiwan            383    20     8    14    25    19     34    14    18    24    13    19     7    11    14    31    28     30    36    18
Brazil            392    25    18    22    22     7     15     2    17    19    22    22    32    19    12    31    26     37    28    16
Korea             392    22    21    29    37     4     30    15    13    31     8    22     8     7    36    18    24     20    33    14
Austria           421    37    27    24    25    45      9    18    24     9    29    10    19    15    35    28     8     14    20    25
Philippines       441    29    25    27    42    14     38    22    10    21    16    22    29    24    18    17    16     33    19    19
Finland           448    37    23     9     8     3     26    23    29     6    35     3    18    28    37    29    36     34    35    29

Average:

Code:

id               rsum   222   333 333ft 333oh   444   555   666   777 clock magic  minx mmagic pyram  sq1
USA                86     2     4    14     5     5     3     1     5    11     7    13      1    10    5
China              87     9    13    12     7    10     6     5     1     2     1     5      2    13    1
Japan              92    13     3     7     3     7     2     4     4     6    12    14      8     2    7
Poland            108     4     8    19     1    21     5     3     2     8     3    12     10     9    3
Thailand          109     6     6     5     4     6     4     8     7    10     6     6     11    21    9
Hungary           110     5    14    10    17     9    10     7     3    12     3     2      3     5    10
Germany           133     8     2    17    10     1    14    18    12     9     2    11      3     3    23
Indonesia         158    17    15     2    10     8    15    25    15     1     7    19      5     4    15
Netherlands       158     3     5     8    13     2     8    14    10     4    18    15     27    15    16
Canada            160     7    11     9    14    11     9    10     6    21    13     4     19    22    4
United Kingdom    175    10     9    16    18    14     7     9    16     5    20    21     16    12    2
Australia         187     1     1    37     2     3     1     2     8    24    17    17     37    20    17
Sweden            197    14    22    15    20    18    13    13    14    18     3     1     20    15    11
Korea             211    16    25     1    12    15    12     6     9    31    14    24     23    17    6
France            224    18    10    24    15    19    20    21    26     7    18    25      6     7    8
Italy             249    24     7    25    28     4    16    16    19    23    11     8     17    24    27
Russia            259    23    12    23     9    23    25    26    22    15    10    29     14     6    22
Taiwan            265    21    24    18     6    13    11    11    11    14    30    32     30    31    13
Brazil            279    11    16     6    16    20    19    31    23    17    31    27     34    14    14
Philippines       288    30    17    11    19    12    23    30    29    13    21    16     38     8    21
Spain             303    12    18    34    22    24    29    20    20     3    14    33     22    27    25
Austria           310    29    20    37    31    22    32    15    13    34    27     9     12    11    18
Malaysia          314    19    21    30    21    17    18    27    18    37    27    10     31    26    12
Denmark           327    22    41     3    24    37    36    29    25    28    14     3     25     1    39
Hong Kong         328    28    30    33    32    26    17    12    17    40     7    22      7    38    19

Query:

Code:

ranks:{1+sum each x</:x}
t:update countryId:((1!select id, countryId from persons where subid=1)@/:personId)`countryId from ranksSingle
w:{?[y,'([]x:(count y)#x);((=;`countryId;`x);(=;`countryRank;1));0b;(`eventId`worldRank!`eventId`worldRank)]}[;t]
w2:(select worldRank:1+count(i) by eventId from ranksSingle) &/: 1!/:(w each exec id from countries)
eventRanks:flip ranks each flip {x2:flip 0!x;(x2`eventId)!x2`worldRank} each w2
rSums:flip (enlist `rsum)!enlist sum each eventRanks
countrySums2:`rsum xasc (select id from countries) ,' rSums ,' eventRanks

irontwig · Jul 29, 2012

TMOY said:
It's also worth to notice that Asia is much larger than Europe. From Paris I only have to travel a couple of hours by train to reach most of the comps I'm attending. Things may not be that easy for someone living in Asia.

Well, not's like the competitions are spread fairly evenly across the continent like in the case of Europe:

http://worldcubeassociation.org/res...regionId=_Asia&years=current&pattern=&map=Map

ardi4nto · Jul 29, 2012

irontwig said:
Well, not's like the competitions are spread fairly evenly across the continent like in the case of Europe:

http://worldcubeassociation.org/res...d=®ionId=_Asia&years=current&pattern=&map=Map

In 2012:
http://worldcubeassociation.org/res...gionId=_Asia&years=only+2012&pattern=&map=Map
More distributed than "current" one. But still not spread anywhere like in Europe.

TMOY · Jul 29, 2012

Speaking about the map of European competitions, what the *** is GEL Open doing in Costa Rica ?

qqwref · Jul 29, 2012

Well, here's the number of competitions vs the number of actual events held (counting multiple rounds of a single event as 1) in 2012 from January until July:

Code:

continent      comps   events   ratio
_Asia             61    538     8.819672
_Europe           58    777    13.39655
_North America    35    329     9.4
_Oceania           3     20     6.666667
_South America    16    173    10.8125

query:
nEvents:{count" "vs string x}
t:update continent:((1!select id, continentId from countries)@/:countryId)`continentId from competitions
w:update ratio:events%comps from select comps:count(i), events:sum nEvents each eventSpecs by continent from t where year=2012, month<8

Even though Asia has more comps, they have significantly fewer events per competition and thus much less attempts on the less common events. It's interesting to me that Europe is way ahead of everyone else in this respect...

irontwig · Jul 29, 2012

For some reason lame one day comps are more popular outside Europe.

kinch2002 · Jul 29, 2012

UK averages 18.5 events per comp this year

qqwref · Jul 30, 2012

I was curious about what types of rounds have been used (on an event basis), so I ran up a query:

Code:

f     5481
c     1896
1f    1781
12f    954
df     636
d2f     95
01f     36
0f      23
012f     7
123f     5
1b2f     4
1bf      4
0c       2
def      2
h1f      2

Note:
 f = final
 c = combined final
 1, 2, 3 = first round, second round, third round
 d, e = combined first round, combined second round
 0 = qualification
 h = combined qualification
 b = b final

query:
`c xdesc select c:count(i) by r from
 0!select r:distinct raze string roundId by competitionId, eventId from results

About the rare events:
- first -> b final -> second -> final used in Caltech Spring 2006, Cornell 2007, Japan 2006, and US Open 2007 for 3x3x3
- first -> b final -> final used in Belgian Open 2006, Chalmers Open 2006, Finnish Open 2007, and Vastervik 2008 for 3x3x3
- quals -> co. final used in Asian Championships 2010 for 6x6x6 and 7x7x7
- co. first -> co. second -> co. final used in Alania Open 2001 for 4xx4 and Magic Open 2011 for OH
- co. quals -> first -> final used in Hungarian Open 2009 for 4x4x4 and 5x5x5

ben1996123 · Jul 31, 2012

qqwref said:
stats n stuff

What is the difference between a final and a combined final anyway? :/

cubernya · Jul 31, 2012

ben1996123 said:
What is the difference between a final and a combined final anyway? :/

Combined final is when you get 2 solves (1 in best of) to get under a certain result

qqwref · Jul 31, 2012

Yeah, in a combined round you get some number of solves, and if you do well enough you get to continue and finish the average.

ilikecubing · Jul 31, 2012

Which single is shared by the most number of people? for 3x3...a list would be cool.

For example,6.84 is shared by 3 people,7.91 by 2..in that way

qqwref · Aug 1, 2012

All with >15 people:

Code:

best	x
13.93	19
13.21	18
17.15	18
15.84	17
16.21	17
17.09	17
17.16	17
18.31	17
18.38	17
18.4	17
20.34	17
24	17
13.28	16
13.5	16
14.22	16
15.02	16
15.15	16
19.34	16
21.06	16
25.05	16

query:
`x xdesc select count(i) by best%100 from ranksSingle where eventId=`333

Extras:
- most-shared under 10 seconds? 9.84 with 9 people
- most-shared under 9 seconds? 8.77 and 8.83 with 5 people
- most-shared over a minute? 1:00.27 and 1:00.53 with 7 people
- fastest time shared by 10+ people? 10.81

ben1996123 · Aug 1, 2012

What about doing that but counting each result as 1 instead of each person, eg. 6.65 would be 3 instead of 1.

qqwref · Aug 1, 2012

In that case,

Code:

solve	x
14.72	435
16.18	421
16.11	418
15.8	415
15.15	412
16.43	410
15.34	409
15.59	409
15.06	408
15.55	406
14.71	405
14.68	403
15.83	403
14.78	400
15.18	398
15.44	398
16.78	398
15.4	397
16.71	396
13.91	395
15.84	395
16.34	395
14.84	394
15.31	393

query:
`x xdesc select count(i) by solve from
 (ungroup select solve:filterEach[0<;value1,'value2,'value3,'value4,'value5]%\:100 from results where eventId=`333)

qqwref · Aug 1, 2012

Something cool: Jorge Leonardo Sánchez Salazar has won every 3x3 final he ever gotten to - all 5 of them. Nobody else with this property has gotten to more than two final rounds.

Robert-Y · Aug 1, 2012

Poor Feliks :'(

cubernya · Aug 1, 2012

Yeah...I was just looking at this, Feliks has been #1 in every round of 3x3 he has ever competed in, minus Worlds 2011 finals

qqwref · Aug 6, 2012

This isn't really a statistic, but here are some profiles with weird things in 'em:

2007CHAN03 - WTF is that last 3x3 average? This guy is the only person out there with a CR worse than a WR in an event. I'm almost thinking someone else's results got put on his profile.
2011KOEB01 - a 5:38:00.00 5x5x5 time! Surely that's an error.
2011LIJI04 - a 1:07:51.00 3x3x3 time, same as above.
2012FAZD01 - 36:26.00 3x3x3 time, same as above.
2010DOLP01 - I dunno what it is, but I think this guy's name might be fake

2009BINK01 - three 10.00s in one Pyraminx round :O

Bonus: Here are all the averages, with at least two successful solves, such that all of the successful solves are divisible by a second and under 10 minutes:

Code:

personId      event   solves
2009SPAR01    444     8:15.00  5:35.00
2003BURT01    333bf   4:08.00      DNF  3:27.00
2009RAOS01    222       21.00  1:04.00
2010ZHAO15    333     1:20.00      DNF  1:39.00  1:21.00  2:57.00
2010GARC05    clock     33.00    30.00
2010YIDA01    444     2:14.00  2:05.00
2009MURA02    444     3:34.00  2:45.00  3:29.00  3:20.00  3:00.00
2009MURA02    333oh   1:51.00  1:04.00
2011BALA01    333oh   3:59.00  2:45.00
2009SIUN01    333bf   1:23.00      DNF  2:03.00
2010RUIZ03    444     2:00.00  1:54.00  1:42.00
2011KART01    pyram     10.00    13.00 
2012GITH01    333bf   3:20.00  3:57.00      DNF
2012RAHM01    333ft       DNF  3:33.00  2:44.00
2012BALA01    333     1:46.00  1:29.00  1:15.00  1:17.00  1:44.00
2012MAHE01    333     1:58.00  1:57.00  2:00.00  1:35.00  1:37.00
2012VFIV01    333     1:53.00  2:08.00  1:55.00  2:02.00  1:56.00
2012MARA01    333     2:35.00  2:01.00      DNF  1:46.00  2:09.00
2012RAVI01    333     2:34.00      DNF  3:12.00  2:23.00  2:29.00
2012JOHN01    333     4:03.00  1:46.00  2:17.00  3:07.00  5:01.00
2012DIVA01    333     2:12.00  4:17.00      DNF  6:09.00  3:30.00
2010MAYE01    444     1:34.00  1:39.00
2011BRAV02    333     1:32.00  1:58.00  2:13.00  2:08.00  1:28.00

Amusingly(?), 7 of these are from the Amrita Cube Championship 2012.

Odd WCA stats/ Stats request Thread

Veteran

Legend

Veteran

Regular

Veteran

Legend

Veteran

Premium Member

Legend

Banned

Premium Member

Legend

Veteran

Legend

Banned

Legend

Legend

Legend

Premium Member

Legend

Similar threads