Odd WCA stats/ Stats request Thread

Evan Liu said:
I've successfully calculated the full lists for the sum of single and average ranks (done with Excel). :D
I omitted the magics since they will be removed starting next year. Also, the rankings do not reflect the changes following the SESC/Santos 2012 results which were posted earlier today. Those should be the only discrepancies you see between my lists and the top 10 available on the WCA site.
If anyone finds others, please do point them out, and I'll try to fix them.

http://dl.dropbox.com/u/16017198/Final_Single.txt
http://dl.dropbox.com/u/16017198/Final_Avg.txt

Edit: Added ranking numbers down the left side for easier viewing (not taking into account ties, though).
Click to expand...

Cool! Magics were killing me. Now I'm #39 (with the updated results from SESC Santos) for single and #68 for average.
 
Last edited:
Odd is not the right word for this i guess, but after my last competition my 3x3 singles and avgs are virtually the same all over the line. NR singel is 71 Nr avg is 71, CR singel is 1468 CR avg is 1444, WR singel is 5498 WR avg is 5385. Singel time is 19.52 and avg 23.12.
 
Evan Liu said:
I've made the versions with names instead of IDs, but it's not as neat/pretty - those with long names will have their row offset by a bit. Oh well, at least it's still the same order of events...
Click to expand...

You could format it so that the name is the last column, that should fix the alignment issue.
 
Hi guys. I have the 7/24 version of the db and I'm ready to rock...

Ninja Storm said:
fastest people whose first competition was in 2012?
Click to expand...
Assuming you mean "in 3x3x3", here's the top 25:
Code: 
personId      competitionId           average    personName
2012YUTA01    IrishOpen2012             10.18    Tao Yu
2012ROQU01    Uberlandia2012            10.36    Pedro Henrique Da Silva Roque
2012CHOS01    DixonOpen2012             11.57    SeungBeom Cho
2012KALE01    PolishOpen2012            11.84    Przemysław Kaleta
2012LIYA01    ShanghaiSummer2012        11.84    Yang Li
2012OKUY01    KyushuOpen2012            12.04    Shunsuke Okuyama
2012JINJ01    HefeiSpring2012           12.24    Jie Jin
2012KOBA01    MatsudoSpring2012         12.25    Masato Kobayashi
2012ITOR01    KansaiStar2012            12.63    Ryo Ito
2012MAGI01    OficinaOpen2012           12.65    Leandro Noguti Magiori
2012JANG02    ColoradoSprings2012       12.69    Jun-Hyuk Jang
2012PHAI01    Bangkok2012               12.82    Natthasit Phaisalrittiwong
2012ELLI01    RiverHillWinter2012       12.94    Keaton Ellis
2012MCNE01    MelbourneSummer2012       13.09    Jayden McNeill
2012TAKA01    RabbitAndTurtle2012       13.1     Shunnosuke Takahashi
2012GRUB01    AustrianOpen2012          13.14    Matthias Gruber
2012TRIV01    IVBogota2012              13.28    Andres Felipe Triviño
2012KIMT01    CubingKoreaJanuary2012    13.31    Taeyang Kim
2012WEIL01    MalaysiaCubeOpen2012      13.38    Liow Ying Wei
2011WEIW01    ShanghaiSummer2012        13.61    Wei Wei
2012DOOF02    JordanOpen2012            13.62    Zeid Doofesh
2012PETR01    BucharestOpen2012         13.64    Nikolai Petrov
2012YANG06    InnerMongolia2012         13.64    Baokun Yang
2012CUIX01    GuangzhouSCAU2012         13.65    Xicheng Cui
2012RAMA07    JogjaCubesama2012         13.65    Bryan Ramadan

q query:
processName:{rtrim ((x?"(")-count x)_x:string x}
25#0!`average xasc select from
 (select first competitionId, (min average)%100, processName first personName by personId from results where eventId=`333)
where competitionId in
 (exec id from competitions where year=2012),
average>0

mDiPalma said:
out of all the people who have competed in 3BLD, feet, AND 4x4, how many have their fastest time in 3BLD (that is, their 3BLD time is less than their feet time and is less than their 4x4 time), how many have their fastest time in feet, and how many have their fastest time in 4x4?
Click to expand...

Code: 
Best time in BLD: 14
Best time in feet: 11
Best time in 4x4x4: 235

q query:
bff:ej[`personId;(select personId, bld:best from ranksSingle where eventId=`333bf);
 ej[`personId;(select personId, four:best from ranksSingle where eventId=`444);
  (select personId, feet:best from ranksSingle where eventId=`333ft)]]
count select from bff where bld<feet, bld<four
count select from bff where feet<bld, feet<four
count select from bff where four<bld, four<feet

antoineccantin said:
The venue with the most competitions?
Click to expand...

Top 25:
Code: 
venue                                                         n
California Institute of Technology                           19
Seneca College's Residence and Conference Centre             10
Novotel Les Halles                                            9
Northwestern Polytechnical University                         8
Stanford University                                           8
Massachusetts Institute of Technology                         7
Messe Essen                                                   7
Norwegian University of Science and Technology                7
Captain's Cove Seaport                                        6
Discovery Science Center                                      6
IT Mall Fortune                                               6
Reuben H. Fleet Science Center                                6
University of California, Berkeley                            6
Carnegie Mellon University                                    5
Exploratorium, Museum of science, art and human perception    5
Indian Institute of Technology Kanpur                         5
Mikrocentrum                                                  5
Peking University                                             5
Seneca College’s Residence and Conference Centre              5
VIII Liceum Ogolnoksztalcace                                  5
Zonnewende                                                    5
Berkeley University of California                             4
CEZ Aréna                                                     4
Centro Municipal La Nave                                      4
Chattahoochee High School                                     4

q query:
processLinks:{rtrim("}"vs'1_'1_"["vs string x)[;0]}
25#`n xdesc select n:count(i) by venue from
 (ungroup select processLinks each venue from competitions)
 
qqwref said:
Top 25:
Code: 
venue                                                         n
California Institute of Technology                           19


Seneca College's Residence and Conference Centre             10


Novotel Les Halles                                            9
Northwestern Polytechnical University                         8
Stanford University                                           8
Massachusetts Institute of Technology                         7
Messe Essen                                                   7
Norwegian University of Science and Technology                7
Captain's Cove Seaport                                        6
Discovery Science Center                                      6
IT Mall Fortune                                               6
Reuben H. Fleet Science Center                                6
University of California, Berkeley                            6
Carnegie Mellon University                                    5
Exploratorium, Museum of science, art and human perception    5
Indian Institute of Technology Kanpur                         5
Mikrocentrum                                                  5
Peking University                                             5


Seneca College’s Residence and Conference Centre              5


VIII Liceum Ogolnoksztalcace                                  5
Zonnewende                                                    5
Berkeley University of California                             4
CEZ Aréna                                                     4
Centro Municipal La Nave                                      4
Chattahoochee High School                                     4

q query:
processLinks:{rtrim("}"vs'1_'1_"["vs string x)[;0]}
25#`n xdesc select n:count(i) by venue from
 (ungroup select processLinks each venue from competitions)
Click to expand...

their likely the different rooms, but still the same venue
 
kinch2002 said:
I've requested this before, but I don't think anyone managed to do it:
Sum of single/average ranks but for countries rather than individuals. So for each event you would take the NR holder and look at their world rank in that event, and then sum the ranks.
I'm still failing to set up the database on my computer, otherwise I'd give it a go myself :(
Click to expand...
This was way harder than I thought it'd be. Here is the top 25.
Code: 
id       sum of ranks
Poland            172
Hungary           216
China             240
Germany           270
Japan             301
Indonesia         380
United Kingdom    440
Netherlands       449
Thailand          522
Sweden            617
Italy             670
Canada            690
USA               702
Russia            867
Spain            1179
Australia        1290
Taiwan           1355
Brazil           1376
Malaysia         1400
Korea            1536
Denmark          1556
Austria          1904
Philippines      1985
Finland          2099
Mexico           2260

My ridiculously ugly queries:
Code: 
t:update countryId:((1!select id, countryId from persons)@/: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)
rSums:flip (enlist `rsum)!enlist raze {?[x;();0b;(enlist `sum)!enlist(sum;`worldRank)]`sum} each w2
`rsum xasc (select id from countries) ,' rSums
 
Last edited:
It seemed strange to me to see USA with a score so high (702), so I checked manually single ranks:

3x3 Anthony(10), 4x4 Dan(11), 5x5 Dan(3), 2x2 Rowe/Vincent(4), 3x3 BLD Alexander(16), 3x3 OH Rowe(10), 3x3 FM Tim(4), 3x3 WF Timothy(21), Megaminx Jonathan(6), Pyraminx Drew(8), Square-1 Andrew(5), Clock David(6), 6x6 Kevin(1), 7x7 Dan(4), Magic Patrick(6), Master Magic Ernie(1), 4x4 BLD Chris(5), 5x5 BLD Chris(8), 3x3 Multi BLD Mike(19) = 148

Am I right, or I misunderstood this stat?
 
Pro94 said:
It seemed strange to me to see USA with a score so high (702), so I checked manually single ranks:

3x3 Anthony(10), 4x4 Dan(11), 5x5 Dan(3), 2x2 Rowe/Vincent(4), 3x3 BLD Alexander(16), 3x3 OH Rowe(10), 3x3 FM Tim(4), 3x3 WF Timothy(21), Megaminx Jonathan(6), Pyraminx Drew(8), Square-1 Andrew(5), Clock David(6), 6x6 Kevin(1), 7x7 Dan(4), Magic Patrick(6), Master Magic Ernie(1), 4x4 BLD Chris(5), 5x5 BLD Chris(8), 3x3 Multi BLD Mike(19) = 148

Am I right, or I misunderstood this stat?
Click to expand...

This is also what I thought he meant.
 
Oh, I see what's going on. Some people are listed as being from multiple countries and my query was apparently choosing the OLDEST one, so for our 3x3x3 rank it found Kamaru-Deen Lawal listed as from the USA but having a country rank of 1. His world rank was over 500 :p

OK, updated list:
Code: 
id               rsum    222    333  333bf  333fm  333ft 333mbf 333oh    444  444bf    555 555bf    666    777  clock  magic   minx mmagic  pyram    sq1
USA               148      4     10     16      4     21     19    10     11      8      3     5      1      4      6      6      6      1      8      5
Poland            172      9      2      3     12     23      1     1     44     12      5    10      3      2     13      8      7     11      4      2
Hungary           216     62     27      1      2     14      3    28     14      1     16     1      6      5     11      8      2      3      1     11
China             240     52     28      2      8     18      8    11      8     15     22     8      4      1      1      1     10      2     40      1
Germany           270     10      6     26      4     31      6    15      2     10     19     6     15     22     18      8     17      6     27     22
Japan             301     78      6     35      1      6     28     4      5     33      1    24      5      7      4     18     13     28      2      3
Indonesia         380     54      6      7     17      1      7    18     18     14     35     4     62     30     12      6     37     12      3     37
United Kingdom    440     23     14     22     12     41      5    70     30      2     10     2     16     15      4     77     29     44     20      4
Netherlands       449      4      4     61      4     13     38     8      1     47     14    51     18     18      7     35     23     76     19      8
Thailand          522     13      3     15     61      5     26     9     13    135      4    59     19     14     25     18     10     48     17     28
France            604     28     20     23      4     53     20    35     44     19     43    17     57    105      3     51     56      7      6     13
Sweden            617     78     42     32     17     28     13    51     17     17     26    19     37     32     49      2      1    117     27     12
Italy             670      1     26     11     47     54     11    76     10      5     15    21     23     56     84     18      5     52     78     77
Canada            690     12     17     33     30     19     21    30     39     99      6    59     22      8     47     89     12     22     89     36
Russia            867     38     45     69     17     72     27     7    109     11    114    15     66     68     53      2     89      7     43     15
Spain            1179      7     34     10     30    209     59    89     24     65     96    59     31     64      2     51    110     57     81    101
Australia        1290     17      1      6    108    522      2     5      4      3      2     7      2     12     59     62     15    384     33     46
Taiwan           1355     85      9     20     84     36    213    29     38     72     21    37     11     16     27    177     72    176    200     32
Brazil           1376    138     42     43     61     11     23     3     35     43     65    59    129     59     23    177     59    283     96     27
Malaysia         1400    150     71     13     61    183      4    98     26      4     47    13     75     62    247     89      3    186     62      6
Korea            1536     95     51    110    308      4    178    30     20    135     12    59     12     10    194     51     46     63    139     19
Denmark          1556     89    367    175     17      2     66    12    146     31    146    14     58     86     95     35      4    132      5     76
Austria          1904    343     94     67     84    521     10    40     63      9    120    12     35     29    189    130      8     42     53     55
Philippines      1985    215     90     85    385     22    382    56     16     53     29    59    116     81     48     43     21    202     48     34
Norway           2054    102     37     86     47     16     55    47     83    113     53    59    121    174    133    528     63    104     64    169

query:
Code: 
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)
rSums:flip (enlist `rsum)!enlist raze {?[x;();0b;(enlist `sum)!enlist(sum;`worldRank)]`sum} each w2
countrySums2:`rsum xasc (select id from countries) ,' rSums ,' {x2:flip 0!x;(x2`eventId)!x2`worldRank} each w2


And average...
Code: 
id               rsum    222   333  333ft  333oh   444    555    666    777  clock  magic   minx mmagic  pyram    sq1
USA               111      2     4     25      5     5      3      1      7     17     10     14      1     11      6
Japan             136     21     3      9      3     7      2      4      6      6     29     15     19      2     10
China             138     14    25     22     11    15      8      5      1      2      1      5      2     26      1
Thailand          167     11     6      6      4     6      4     12     11     12      7      7     22     46     13
Poland            168      7     9     34      1    46      6      3      2      8      4     13     21     10      4
Hungary           175      9    26     14     37    11     16      9      4     18      4      2      3      5     17
Germany           231     13     2     30     18     1     29     34     22     11      2     12      3      3     51
Indonesia         298     31    29      2     18    10     30     58     40      1     10     30      7      4     28
Netherlands       336      5     5     11     22     2     11     27     15      4     47     16    112     30     29
Canada            341     12    14     13     30    16     12     15      8     64     32      4     69     47      5
United Kingdom    359     16    10     29     38    26     10     14     49      5     51     33     51     25      2
Sweden            431     25    49     26     51    37     27     20     28     44      4      1     71     30     18
France            519     32    11     69     34    38     52     48     93      7     47     60     10      7     11
Korea             566     29    92      1     21    27     18      8     14    139     35     50     90     33      9
Russia            618     44    21     51     15    65     79     70     67     27     15     82     28      6     48
Italy             690     71     8     75    100     4     34     30     55     90     18      9     53     53     90
Taiwan            760     40    66     31      9    22     17     16     17     26    128    109    136    122     21
Australia         819      1     1    325      2     3      1      2     12     98     42     21    231     45     35
Brazil            842     19    31      7     35    39     49    126     70     34    135     69    175     29     24
Spain            1015     20    39    214     57    68    109     41     56      3     35    133     82     78     80
Philippines      1028    194    37     20     45    17     61    109    145     25     58     20    245      9     43
Malaysia         1057     35    44    153     53    36     46     87     51    200     98     11    153     71     19
Austria          1304    182    43    325    159    57    117     29     25    176     98     10     23     24     36
Norway           1542     38    39     23     13    84     53     92    201    192    422     65     62    111    147
 
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).
 
What...the first think I see in the tables is, that Asian contries obviously suck in singles compared to average. Possibly because of a lower competition density over there?
 
Last edited:
Sebastien said:
What...the first think I see in the tables is, that Asia contries obviously suck in singles compared to average. Possibly because of a lower competition density over there?
Click to expand...
But Japan have 15 competitions this year up until September...that seems like a very high density. They are 'bad' at singles because they have no great bld solvers, and because they presumably haven't had a lucky enough 2x2 scramble yet. Thailand don't even have a 4/5bld yet.
 
Asia has lower competition density? Not really. It's probably about their results, not about competition density.

Code: 
January 1, 2012 - July 29,2012

Asia 		61 competitions
Europe  	57 competitions
North America	35 competitions
South America	16 competitions
Oceania		 3 competitions

It's also worth to notice that most of Asian competitors only competes in their home countries. So density to the whole continent seems doesn't affect their ranks.
 
Last edited:
You must log in or register to reply here.

Similar threads

Minetoucubing
Odd or fake QJ megaminx?
Replies
0
Views
188
Minetoucubing
Minetoucubing
MrCubert
SS Oddballs Redemption 2026
Replies
2
Views
434
MrCubert
MrCubert
J
Special Characters in my name appear odd in the weekly competitions
Replies
0
Views
485
J:org
J
D
reduction parity on odd cubes vs even cubes
Replies
5
Views
3,047
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,504
Discomantis
Discomantis
Back
Top