Odd WCA stats/ Stats request Thread

Just some more and code.

Using data from WCA_export502_20141104 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]cuber[/TD][TD]met[/TD][TD]%[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD="align:right"]3632[/TD][TD="align:right"]10.62%[/TD][/TR]
[TR][TD]François Courtès[/TD][TD="align:right"]3615[/TD][TD="align:right"]10.57%[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD="align:right"]3500[/TD][TD="align:right"]10.23%[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD="align:right"]3487[/TD][TD="align:right"]10.19%[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD="align:right"]3462[/TD][TD="align:right"]10.12%[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD="align:right"]3435[/TD][TD="align:right"]10.04%[/TD][/TR]
[TR][TD]Chris Krueger[/TD][TD="align:right"]3434[/TD][TD="align:right"]10.04%[/TD][/TR]
[TR][TD]Takao Hashimoto (橋本貴夫)[/TD][TD="align:right"]3338[/TD][TD="align:right"]9.76%[/TD][/TR]
[TR][TD]Anders Larsson[/TD][TD="align:right"]3314[/TD][TD="align:right"]9.69%[/TD][/TR]
[TR][TD]István Kocza[/TD][TD="align:right"]3255[/TD][TD="align:right"]9.52%[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD="align:right"]3122[/TD][TD="align:right"]9.13%[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]3111[/TD][TD="align:right"]9.09%[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD="align:right"]3111[/TD][TD="align:right"]9.09%[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD="align:right"]3002[/TD][TD="align:right"]8.78%[/TD][/TR]
[TR][TD]Fangyuan Chang (常方圆)[/TD][TD="align:right"]2998[/TD][TD="align:right"]8.76%[/TD][/TR]
[TR][TD]Adam Zamora[/TD][TD="align:right"]2994[/TD][TD="align:right"]8.75%[/TD][/TR]
[TR][TD]Dave Campbell[/TD][TD="align:right"]2983[/TD][TD="align:right"]8.72%[/TD][/TR]
[TR][TD]Clément Gallet[/TD][TD="align:right"]2943[/TD][TD="align:right"]8.60%[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD="align:right"]2825[/TD][TD="align:right"]8.26%[/TD][/TR]
[TR][TD]Bence Barát[/TD][TD="align:right"]2817[/TD][TD="align:right"]8.24%[/TD][/TR]
[TR][TD]Hanneke Rijks[/TD][TD="align:right"]2804[/TD][TD="align:right"]8.20%[/TD][/TR]
[TR][TD]Breandan Vallance[/TD][TD="align:right"]2760[/TD][TD="align:right"]8.07%[/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD="align:right"]2729[/TD][TD="align:right"]7.98%[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD="align:right"]2705[/TD][TD="align:right"]7.91%[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD="align:right"]2700[/TD][TD="align:right"]7.89%[/TD][/TR]
[TR][TD]Devin Corr-Robinett[/TD][TD="align:right"]2680[/TD][TD="align:right"]7.83%[/TD][/TR]
[TR][TD]Lucas Garron[/TD][TD="align:right"]2680[/TD][TD="align:right"]7.83%[/TD][/TR]
[TR][TD]Timothy Sun[/TD][TD="align:right"]2631[/TD][TD="align:right"]7.69%[/TD][/TR]
[TR][TD]Anthony Brooks[/TD][TD="align:right"]2627[/TD][TD="align:right"]7.68%[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD="align:right"]2603[/TD][TD="align:right"]7.61%[/TD][/TR]
[TR][TD]Kian Barry[/TD][TD="align:right"]2563[/TD][TD="align:right"]7.49%[/TD][/TR]
[TR][TD]Olivér Perge[/TD][TD="align:right"]2519[/TD][TD="align:right"]7.36%[/TD][/TR]
[TR][TD]Jesús Masanet García[/TD][TD="align:right"]2471[/TD][TD="align:right"]7.22%[/TD][/TR]
[TR][TD]Ming Zheng (郑鸣)[/TD][TD="align:right"]2468[/TD][TD="align:right"]7.21%[/TD][/TR]
[TR][TD]Michał Halczuk[/TD][TD="align:right"]2443[/TD][TD="align:right"]7.14%[/TD][/TR]
[TR][TD]Tyson Mao (毛台勝)[/TD][TD="align:right"]2355[/TD][TD="align:right"]6.88%[/TD][/TR]
[TR][TD]Dan Dzoan[/TD][TD="align:right"]2322[/TD][TD="align:right"]6.79%[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD="align:right"]2299[/TD][TD="align:right"]6.72%[/TD][/TR]
[TR][TD]Cornelius Dieckmann[/TD][TD="align:right"]2285[/TD][TD="align:right"]6.68%[/TD][/TR]
[TR][TD]Maria Oey[/TD][TD="align:right"]2256[/TD][TD="align:right"]6.60%[/TD][/TR]
[TR][TD]Helmut Heilig[/TD][TD="align:right"]2250[/TD][TD="align:right"]6.58%[/TD][/TR]
[TR][TD]Louis Cormier[/TD][TD="align:right"]2205[/TD][TD="align:right"]6.45%[/TD][/TR]
[TR][TD]Sarah Strong[/TD][TD="align:right"]2183[/TD][TD="align:right"]6.38%[/TD][/TR]
[TR][TD]Stefan Pochmann[/TD][TD="align:right"]2144[/TD][TD="align:right"]6.27%[/TD][/TR]
[TR][TD]Javier Tirado Ortiz[/TD][TD="align:right"]2125[/TD][TD="align:right"]6.21%[/TD][/TR]
[TR][TD]Corey Sakowski[/TD][TD="align:right"]2116[/TD][TD="align:right"]6.19%[/TD][/TR]
[TR][TD]Tomasz Żołnowski[/TD][TD="align:right"]2111[/TD][TD="align:right"]6.17%[/TD][/TR]
[TR][TD]Michał Pleskowicz[/TD][TD="align:right"]2097[/TD][TD="align:right"]6.13%[/TD][/TR]
[TR][TD]Sanio Kasumovic[/TD][TD="align:right"]2095[/TD][TD="align:right"]6.12%[/TD][/TR]
[TR][TD]Bruce Norskog[/TD][TD="align:right"]2090[/TD][TD="align:right"]6.11%[/TD][/TR]
[TR][TD]Henrik Buus Aagaard[/TD][TD="align:right"]2072[/TD][TD="align:right"]6.06%[/TD][/TR]
[TR][TD]Jean-Louis Mathieu[/TD][TD="align:right"]2070[/TD][TD="align:right"]6.05%[/TD][/TR]
[TR][TD]Jasmine Lee[/TD][TD="align:right"]2069[/TD][TD="align:right"]6.05%[/TD][/TR]
[TR][TD]Edward Lin[/TD][TD="align:right"]2066[/TD][TD="align:right"]6.04%[/TD][/TR]
[TR][TD]Jan Bentlage[/TD][TD="align:right"]2051[/TD][TD="align:right"]6.00%[/TD][/TR]
[TR][TD]Brúnó Bereczki[/TD][TD="align:right"]2046[/TD][TD="align:right"]5.98%[/TD][/TR]
[TR][TD]Chris Dzoan[/TD][TD="align:right"]2043[/TD][TD="align:right"]5.97%[/TD][/TR]
[TR][TD]Shotaro Makisumi (牧角章太郎)[/TD][TD="align:right"]2028[/TD][TD="align:right"]5.93%[/TD][/TR]
[TR][TD]Justin Jaffray[/TD][TD="align:right"]2015[/TD][TD="align:right"]5.89%[/TD][/TR]
[TR][TD]Oscar Roth Andersen[/TD][TD="align:right"]2012[/TD][TD="align:right"]5.88%[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT cuber,
       count(distinct other)-1 met,
      (count(distinct other)-1) / (SELECT count(distinct personId)-1 FROM Results) '%[%]'
FROM (SELECT distinct competitionId, personId cuber FROM Results) a natural join
     (SELECT distinct competitionId, personId other FROM Results) b
GROUP BY cuber
HAVING met >= 2000
ORDER BY met desc;[/NOPARSE]
 
Last edited:
Jakube said:
[table="class:grid,align:left"]
[tr][td]Ron van Bruchem[/td][td]3632[/td][/tr]
[tr][td]François Courtès[/td][td]3615[/td][/tr]
[tr][td]Tim Reynolds[/td][td]3500[/td][/tr]
[tr][td]Bob Burton[/td][td]3487[/td][/tr]
[tr][td]Arnaud van Galen[/td][td]3462[/td][/tr]
[tr][td]Shelley Chang[/td][td]3435[/td][/tr]
[tr][td]Chris Krueger[/td][td]3434[/td][/tr]
[tr][td]Takao Hashimoto (橋本貴夫)[/td][td]3338[/td][/tr]
[tr][td]Anders Larsson[/td][td]3314[/td][/tr]
[tr][td]István Kocza[/td][td]3255[/td][/tr]
[tr][td]Lars Vandenbergh[/td][td]3122[/td][/tr]
[tr][td]Rowe Hessler[/td][td]3111[/td][/tr]
[tr][td]Sébastien Auroux[/td][td]3111[/td][/tr]
[tr][td]Jeremy Fleischman[/td][td]3002[/td][/tr]
[tr][td]Fangyuan Chang (常方圆)[/td][td]2998[/td][/tr]
[tr][td]Adam Zamora[/td][td]2994[/td][/tr]
[tr][td]Dave Campbell[/td][td]2983[/td][/tr]
[tr][td]Clément Gallet[/td][td]2943[/td][/tr]
[tr][td]Mats Valk[/td][td]2825[/td][/tr]
[tr][td]Bence Barát[/td][td]2817[/td][/tr]
[/table]

So your correct, Ron has met around 10% of all cubers. Little bit more in fact.

[table="class:grid,align:left"]
[tr][td]Tarek Lukasha (طارق لوكاشه)[/td][td]8[/td][/tr]
[tr][td]Therese Ericsson[/td][td]8[/td][/tr]
[tr][td]Munif Khalid Barghouti (منيف خالد البرغوثي)[/td][td]8[/td][/tr]
[tr][td]Tareq alFar (طارق الفار)[/td][td]8[/td][/tr]
[tr][td]Yazan Doofesh (يزن دوفش)[/td][td]8[/td][/tr]
[tr][td]Liv Gjøsæther[/td][td]8[/td][/tr]
[tr][td]Mahmoud Issis (محمود عسعس)[/td][td]8[/td][/tr]
[tr][td]Thibaut Brice[/td][td]8[/td][/tr]
[tr][td]Karl Wassholm[/td][td]8[/td][/tr]
[tr][td]Fauzan Asrian[/td][td]8[/td][/tr]
[tr][td]Andreas Johansson[/td][td]8[/td][/tr]
[tr][td]Rakan Eid (ركان عيد)[/td][td]8[/td][/tr]
[tr][td]Dorian Cron[/td][td]8[/td][/tr]
[tr][td]Taufan Ahadiat[/td][td]8[/td][/tr]
[tr][td]Nick Hunt[/td][td]9[/td][/tr]
[tr][td]Sean Eller[/td][td]9[/td][/tr]
[tr][td]Sergio Garcia Gonzalez[/td][td]9[/td][/tr]
[tr][td]John Shown[/td][td]9[/td][/tr]
[tr][td]Owen Brydon[/td][td]9[/td][/tr]
[tr][td]James Adams[/td][td]9[/td][/tr]
[/table]
Click to expand...

One slight issue with that, and I'm not sure this can be accounted for: by that metric, it's probably me who's met the fewest cubers, because while I was at FMC USA 2014, I was at a location where 6 people competed, and I was the only one who went to FMC USA 2014 as their first comp. I wonder if there's a way to account for multi-location competitions?
 
supercavitation said:
One slight issue with that, and I'm not sure this can be accounted for: by that metric, it's probably me who's met the fewest cubers, because while I was at FMC USA 2014, I was at a location where 6 people competed, and I was the only one who went to FMC USA 2014 as their first comp. I wonder if there's a way to account for multi-location competitions?
Click to expand...

Hmm, good point. Can't be done with the WCA database alone, as that one doesn't know it was multi-location and who was where. Also, you could have been at the same competition as someone else but never met because you were there on different days. Or you actually did meet someone at a competition but at least one of you didn't compete there.

In that sense, we have both false positives and false negatives and we should probably put quotes around "met" like Walker actually did in his request, or write what we actually mean.
 
There are 34209 persons in the database & 32907 have a 3x3 single, another 136 have just DNFs = 1166 that have never done 3x3x3.

WCA_export502_20141104
 
Randomno said:
List of countries by number of WRs set?
Click to expand...
Code: 
65      USA
37      Poland
36      Hungary
34      Australia
32      Japan
32      Netherlands
30      China
26      Germany
16      Sweden
12      Finland
10      France
9       United Kingdom
7       Belgium
5       Denmark
4       Canada
3       Korea
3       Israel
3       Italy
2       Brazil
2       Malaysia
2       Taiwan
2       Czech Republic
2       Spain
2       Indonesia
1       Russia
1       Thailand
1       Philippines
1       Romania
1       Mexico
1       India
1       Hong Kong
Code: 
60      USA
41      Japan
36      Poland
32      Australia
27      Netherlands
27      China
21      Hungary
16      Germany
12      Sweden
11      France
8       Belgium
7       Finland
5       Canada
4       Denmark
4       Taiwan
4       Korea
3       Italy
2       Hong Kong
1       Indonesia
1       India
1       Thailand
1       Czech Republic
1       United Kingdom
1       Brazil
Code: 
125     USA
73      Japan
73      Poland
66      Australia
59      Netherlands
57      Hungary
57      China
42      Germany
28      Sweden
21      France
19      Finland
15      Belgium
10      United Kingdom
9       Denmark
9       Canada
7       Korea
6       Italy
6       Taiwan
3       Czech Republic
3       Hong Kong
3       Brazil
3       Indonesia
3       Israel
2       India
2       Spain
2       Malaysia
2       Thailand
1       Russia
1       Romania
1       Philippines
1       Mexico
 
Lid said:
Code: 
65      USA
37      Poland
36      Hungary
34      Australia
32      Japan
32      Netherlands
30      China
26      Germany
16      Sweden
12      Finland
10      France
9       United Kingdom
7       Belgium
5       Denmark
4       Canada
3       Korea
3       Israel
3       Italy
2       Brazil
2       Malaysia
2       Taiwan
2       Czech Republic
2       Spain
2       Indonesia
1       Russia
1       Thailand
1       Philippines
1       Romania
1       Mexico
1       India
1       Hong Kong
Code: 
60      USA
41      Japan
36      Poland
32      Australia
27      Netherlands
27      China
21      Hungary
16      Germany
12      Sweden
11      France
8       Belgium
7       Finland
5       Canada
4       Denmark
4       Taiwan
4       Korea
3       Italy
2       Hong Kong
1       Indonesia
1       India
1       Thailand
1       Czech Republic
1       United Kingdom
1       Brazil
Code: 
125     USA
73      Japan
73      Poland
66      Australia
59      Netherlands
57      Hungary
57      China
42      Germany
28      Sweden
21      France
19      Finland
15      Belgium
10      United Kingdom
9       Denmark
9       Canada
7       Korea
6       Italy
6       Taiwan
3       Czech Republic
3       Hong Kong
3       Brazil
3       Indonesia
3       Israel
2       India
2       Spain
2       Malaysia
2       Thailand
1       Russia
1       Romania
1       Philippines
1       Mexico
Click to expand...

Thanks, UK has 9 singles but only 1 average? o.O
 
Rcuber123 said:
Best average to not make podium for each event
Click to expand...
Code: 
event   avg      comp
333     8.61     Euro2014
444     33.45    Euro2014
555     1:10.09  Euro2014
222     2.54     USNationals2014
333oh   14.55    USNationals2014
333ft   47.20    Euro2014
minx    54.63    WC2013
pyram   4.49     JakartaSpeedcubing2013
sq1     15.07    CubeSplashing2014
clock   8.35     Euro2014
skewb   5.10     Wiscube2014
666     2:18.12  Euro2014
777     3:06.98  WC2013
 
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
433
MrCubert
MrCubert
J
Special Characters in my name appear odd in the weekly competitions
Replies
0
Views
484
J:org
J
D
reduction parity on odd cubes vs even cubes
Replies
5
Views
3,045
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,502
Discomantis
Discomantis
Back
Top