Odd WCA stats/ Stats request Thread

[Tim Reynolds]

Well Tim's streak is over now, with his win at La Montagne Open, so I guess this gives way for someone else to take the record.

Yeah, John and I fail at failing.

Michał Halczuk, Erik Johnson, Darren Kwong, and Luchen Zhang are tied at 8. Kare Krig, Rowan Kinneavy, and Michael Young have 7. Karthik Putraya, Howard Wong Jun Yen, Dhanayush Raninga, Philippe Virouleau, and Filippo Brancaleoni have 6. No clear leaders right now.

Most distinct events won:
Bence Barat: 18 (everything but 4x4 BLD)
Timothy Sun: 17 (everything but 6x6 and 5x5 BLD)
Erik Akkersdijk: 17 (everything but 4x4 BLD and 5x5 BLD)
Simon Westlund: 16 (3x3 BLD, 3x3 OH, 4x4 BLD)
Feliks Zemdegs: 16 (Magic, Master Magic, Feet)
Milan Baticz: 16 (4x4 BLD, 5x5 BLD, Feet)
Henrik Buus Aagard: 15 (4x4, Pyraminx, 7x7, 5x5 BLD)
Dan Cohen: 15 (Feet, 4x4 BLD, 5x5 BLD, Multi BLD)
Bernett Orlando: 15 (Clock, 6x6, Magic, Master Magic)

[uberCuber]

Ninja Storm is well aware of that. If you average above 30 seconds on 3x3, you shouldn't expect to average sub-5 at 2x2.

thats not all ways true

^ After this happened in the OAQT, now I'm curious, are there people with official 2x2 results that are absurdly good compared to their 3x3 results?

[Stefan]

are there people with official 2x2 results that are absurdly good compared to their 3x3 results?

Top 50 by ratio between 3x3 average record and 2x2 average record:

mysql> SELECT round(a3/100,2) avg3, round(a2/100,2) avg2, round(a3/a2,2) ratio, personName name FROM
    -> (SELECT personId, personName, min(average) a2 FROM Results WHERE eventId='222' and average between 1 and 999 GROUP BY personId) t2,
    -> (SELECT personId, min(average) a3 FROM Results WHERE eventId='333' and average>0 GROUP BY personId) t3
    -> WHERE t2.personId = t3.personId
    -> ORDER BY a3/a2 desc
    -> LIMIT 50;
+-------+------+-------+---------------------------------+
| avg3  | avg2 | ratio | name                            |
+-------+------+-------+---------------------------------+
| 78.49 | 7.59 | 10.34 | Piet Wetenkamp                  |
| 48.29 | 6.75 |  7.15 | Jelome Empedrad                 |
| 43.40 | 6.10 |  7.11 | Nathan Seeto                    |
| 54.87 | 7.88 |  6.96 | David Bockman                   |
| 42.36 | 6.10 |  6.94 | Luis Garcés Méndez              |
| 55.65 | 8.31 |  6.70 | Ammar Haider                    |
| 26.87 | 4.05 |  6.63 | Sebastian Deimel                |
| 40.23 | 6.22 |  6.47 | Tomasz Bartkowiak               |
| 31.15 | 4.83 |  6.45 | Ties de Wit                     |
| 17.16 | 2.81 |  6.11 | Yui Tomita (????)               |
| 31.49 | 5.19 |  6.07 | Kim Jae-Min                     |
| 44.87 | 7.43 |  6.04 | Cameron Drysdale                |
| 59.72 | 9.91 |  6.03 | Sietse Vos                      |
| 43.20 | 7.27 |  5.94 | Lei Shi (??)                    |
| 54.59 | 9.26 |  5.90 | Fabian Erkemeij                 |
| 19.37 | 3.30 |  5.87 | Mina Tomita (????)              |
| 31.17 | 5.33 |  5.85 | Chenxi Shan (???)               |
| 50.33 | 8.61 |  5.85 | Andrés Alonso Gutiérrez Salinas |
| 55.76 | 9.54 |  5.84 | Kh?i Trí ??                     |
| 37.47 | 6.43 |  5.83 | Zetis Nguyen                    |
| 24.69 | 4.25 |  5.81 | Kim Yong-Hun                    |
| 36.13 | 6.23 |  5.80 | Magda Gancarz                   |
| 19.23 | 3.33 |  5.77 | Junya Tomita (????)             |
| 31.31 | 5.57 |  5.62 | Jure Vidmar                     |
| 16.59 | 2.96 |  5.60 | Kevin Guillaumond               |
| 52.79 | 9.69 |  5.45 | Vighar Choirul Iqbal            |
| 16.87 | 3.10 |  5.44 | Alexey Oblaukhov                |
| 35.56 | 6.55 |  5.43 | Scott Leslie                    |
| 43.09 | 8.03 |  5.37 | Marek Gancarz                   |
| 12.00 | 2.25 |  5.33 | Cameron Stollery                |
| 44.12 | 8.28 |  5.33 | Luis Arturo Peña Nemer          |
| 46.25 | 8.74 |  5.29 | Jack DeLano                     |
| 44.09 | 8.36 |  5.27 | Daniel Schnoll                  |
| 37.56 | 7.13 |  5.27 | Kwak Hyoung-Jin                 |
| 29.57 | 5.62 |  5.26 | Filippo Di Biase                |
| 41.49 | 7.93 |  5.23 | Brandon Turner                  |
| 26.23 | 5.04 |  5.20 | Kevin Gonzalez                  |
| 44.82 | 8.74 |  5.13 | Michael Womack                  |
| 31.16 | 6.09 |  5.12 | Darren Carpenter                |
| 37.39 | 7.32 |  5.11 | Tam Jia Tern                    |
| 16.70 | 3.28 |  5.09 | ?ukasz Cia?o?                   |
| 27.73 | 5.45 |  5.09 | Sam Schultz                     |
| 31.35 | 6.20 |  5.06 | Corentin Levy                   |
| 16.83 | 3.33 |  5.05 | Will Ballard                    |
| 41.96 | 8.32 |  5.04 | Håvard Terland                  |
| 39.35 | 7.81 |  5.04 | Oleg Andreyev                   |
| 45.69 | 9.08 |  5.03 | Julián González Acevedo         |
| 24.99 | 4.97 |  5.03 | Denzel Gutierrez                |
| 13.38 | 2.67 |  5.01 | Zhou Yichen (???)               |
| 32.22 | 6.44 |  5.00 | Justin Grant                    |
+-------+------+-------+---------------------------------+

[TMOY]

Well, at least for once Michael is right, Ties de Wit actually averages sup-30 on 3^3 and sub-5 on 2^3. He seems to be the only one, though (although Kim Jae-Min and Chenxi Shan are pretty close).

[Robert-Y]

What about the densest rounds sorted by average distance in percentage?

Thanks for all these stats so far, Stefan, they're quite interesting

[Michael Womack]

Well, at least for once Michael is right, Ties de Wit actually averages sup-30 on 3^3 and sub-5 on 2^3. He seems to be the only one, though (although Kim Jae-Min and Chenxi Shan are pretty close).

Thank you Phochmann for proving it for me

[Sebastien]

Thank you Phochmann for proving it for me

I'm sure it was a pleasure for him Whomack.

[Stefan]

What about the densest rounds sorted by average distance in percentage?

I thought about that but didn't see an easy enough way to do that. For average absolute difference I can use the simple formula (worst-best)/(persons-1), ignoring all times between best and worst because they don't affect the average absolute difference (worthy of a proof if you have a minute). For average relative difference, that doesn't work, as the middle ones do matter (worthy of a proof if you have another minute). And I'm also not sure how to properly average it and whether this is really what I want.

So, well, let's pretend the middle ones are "evenly spaced" so that all pairs of adjacent ones are the same factor x apart, then
worst = best * x^(persons-1) and thus x = (persons-1)th root of worst/best
See below for results.

Or maybe someone with better math knowledge has a better definition of densest in relative terms? Large gaps would make the round look much less dense, but they would go unnoticed with this definition of mine. I'd like something that rewards both for small factors and for similar factors.

select competitionId, eventId, roundId, best, worst, round(power(worst/best,1/(persons-1)),4) avgFactor, persons from
(select competitionId, eventId, roundId, min(if(average>0,round(average/100,2),999999999)) best, max(if(average>0,round(average/100,2),999999999)) worst, count(*) persons
from Results
where roundId in ('f','c')
group by competitionId, eventId, roundId) helper
where persons>1 and worst<999999999
order by power(worst/best,1/(persons-1)), persons desc
limit 100;

+----------------------------+---------+---------+--------+--------+-----------+---------+
| competitionId              | eventId | roundId | best   | worst  | avgFactor | persons |
+----------------------------+---------+---------+--------+--------+-----------+---------+
| CubeCanadaDay2011          | mmagic  | f       |   6.92 |   7.01 |    1.0130 |       2 |
| OGU2006                    | sq1     | f       |  46.45 |  47.14 |    1.0149 |       2 |
| IVBogota2012               | 444     | f       |  54.97 |  57.76 |    1.0166 |       4 |
| WC2009                     | 333     | f       |  10.74 |  13.81 |    1.0169 |      16 |
| Euro2010                   | 333     | f       |  10.31 |  12.68 |    1.0174 |      13 |
| AachenSummer2012           | 333     | f       |   9.68 |  18.78 |    1.0176 |      39 |
| HungarianOpen2009          | 555     | f       |  91.49 | 119.00 |    1.0177 |      16 |
| TaipeiOpen2011             | 444     | f       |  44.28 |  89.79 |    1.0178 |      41 |
| Euro2010                   | 555     | f       |  77.60 |  99.54 |    1.0179 |      15 |
| Euro2006                   | 333     | f       |  14.97 |  19.55 |    1.0180 |      16 |
| SuzhouOpen2011             | 333     | f       |  11.97 |  14.59 |    1.0182 |      12 |
| MunichOpen2011             | 444     | f       |  49.10 |  60.26 |    1.0188 |      12 |
| WC2007                     | 333     | f       |  12.46 |  16.51 |    1.0189 |      16 |
| BeijingSummer2011          | 333     | f       |  12.60 |  15.80 |    1.0190 |      13 |
| HungarianOpen2009          | 444     | f       |  51.57 |  68.99 |    1.0196 |      16 |
| Vastervik2008              | mmagic  | f       |   5.10 |   5.20 |    1.0196 |       2 |
| WC2003                     | 333     | f       |  20.00 |  22.92 |    1.0197 |       8 |
| WC2005                     | 333     | f       |  15.10 |  18.71 |    1.0197 |      12 |
| WC2009                     | 555     | f       |  78.20 | 104.80 |    1.0197 |      16 |
| Euro2010                   | 333oh   | f       |  18.39 |  24.17 |    1.0197 |      15 |
| TaiwanSummerOpen2009       | 333     | f       |  13.30 |  16.49 |    1.0197 |      12 |
| GuangdongOpen2009          | 333     | f       |  11.83 |  20.57 |    1.0200 |      29 |
| RizalOpen2009              | 444     | f       |  69.49 |  83.27 |    1.0203 |      10 |
| KansaiOpen2012             | 333     | f       |  11.19 |  13.98 |    1.0204 |      12 |
| ThailandOpen2009           | 333     | f       |  12.72 |  18.72 |    1.0205 |      20 |
| PhilippinesOpen2008        | 333     | f       |  14.94 |  21.99 |    1.0206 |      20 |
| WC2009                     | 444     | f       |  45.18 |  61.48 |    1.0207 |      16 |
| SlovenianOpen2012          | 444     | f       |  51.21 |  61.73 |    1.0210 |      10 |
| TaiwanSpring2010           | 333     | f       |  12.45 |  15.65 |    1.0210 |      12 |
| HungarianOpen2010          | 333     | f       |  12.39 |  15.58 |    1.0210 |      12 |
| Malang2011                 | 222     | f       |   6.35 |  16.29 |    1.0212 |      46 |
| USNationals2010            | 444     | f       |  43.76 |  59.94 |    1.0212 |      16 |
| TaiwanSpringOpen2011       | 333     | f       |  11.02 |  15.16 |    1.0215 |      16 |
| TaiwanSummerOpen2008       | 333     | f       |  15.02 |  18.98 |    1.0215 |      12 |
| ThailandOpen2010           | 333     | f       |  12.54 |  15.85 |    1.0215 |      12 |
| MunichOpen2010             | 444     | f       |  48.82 |  67.84 |    1.0222 |      16 |
| StanfordWinter2010         | 333     | f       |  12.69 |  16.20 |    1.0224 |      12 |
| GuangzhouBigCubes2010      | 555     | f       |  84.76 |  92.64 |    1.0225 |       5 |
| HongKongCubeDay2010        | 444     | f       |  55.60 |  66.42 |    1.0225 |       9 |
| WC2007                     | 555     | f       | 105.07 | 147.29 |    1.0228 |      16 |
| MNWOpen2011                | 333     | f       |  11.79 |  15.11 |    1.0228 |      12 |
| Euro2008                   | 333     | f       |  11.71 |  16.48 |    1.0230 |      16 |
| WC2011                     | 444     | f       |  35.22 |  49.58 |    1.0231 |      16 |
| PolishOpen2009             | 333     | f       |  11.81 |  15.20 |    1.0232 |      12 |
| GuangdongOpen2008          | 333     | f       |  12.74 |  18.40 |    1.0232 |      17 |
| FinnishOpen2009            | mmagic  | f       |   5.56 |   5.69 |    1.0234 |       2 |
| USNationals2009            | 444     | f       |  52.84 |  74.75 |    1.0234 |      16 |
| SingaporeOpen2009          | 333     | f       |  12.96 |  15.96 |    1.0234 |      10 |
| EastGermanOpen2010         | 444     | f       |  51.94 |  73.50 |    1.0234 |      16 |
| NewZealandChamps2009       | sq1     | f       |  28.17 |  28.83 |    1.0234 |       2 |
| TorontoSpring2011          | 333     | f       |  12.47 |  15.36 |    1.0234 |      10 |
| Euro2008                   | 333oh   | f       |  21.79 |  30.85 |    1.0234 |      16 |
| TianjinOpen2011            | 333     | f       |  13.56 |  15.95 |    1.0235 |       8 |
| ShenzhenSummerOpen2009     | 333     | f       |  12.03 |  17.06 |    1.0236 |      16 |
| CubingKoreaJanuary2012     | 333     | f       |  11.49 |  14.86 |    1.0237 |      12 |
| HumanRightsDay2011         | 444     | f       |  44.30 |  66.15 |    1.0239 |      18 |
| USNationals2011            | 333     | f       |   9.91 |  14.12 |    1.0239 |      16 |
| UKDWOpen2011               | 333     | f       |  11.52 |  19.89 |    1.0240 |      24 |
| CubikBoxCup2011            | 333     | f       |  10.26 |  14.65 |    1.0240 |      16 |
| IndonesianOpen2011         | 333     | f       |  11.58 |  17.34 |    1.0240 |      18 |
| Shandong2010               | 333     | f       |  15.64 |  24.62 |    1.0242 |      20 |
| Cheonan2008                | 333     | f       |  13.63 |  17.74 |    1.0242 |      12 |
| AustrianOpen2011           | 333     | f       |  10.83 |  14.10 |    1.0243 |      12 |
| BerkeleySummer2011         | 333     | f       |  10.96 |  17.72 |    1.0243 |      21 |
| TaiwanSummer2010           | 333     | f       |  10.71 |  16.14 |    1.0244 |      18 |
| MunichOpen2011             | 333     | f       |  10.72 |  13.98 |    1.0244 |      12 |
| Netherlands2006            | 444     | f       |  74.32 |  79.93 |    1.0246 |       4 |
| CaltechWinter2007          | 333     | f       |  14.82 |  19.36 |    1.0246 |      12 |
| ShantouOpen2010            | 333oh   | f       |  24.95 |  37.74 |    1.0246 |      18 |
| Kuikuiltik2012             | 444     | f       |  51.13 | 109.35 |    1.0248 |      32 |
| MatsudoOpen2010            | 444     | f       |  48.05 |  54.34 |    1.0249 |       6 |
| SilesiaOpen2012            | 333     | f       |  10.57 |  13.89 |    1.0251 |      12 |
| VCubeSpiel2011             | 333     | f       |  10.58 |  24.63 |    1.0252 |      35 |
| USNationals2010            | 333     | f       |  10.93 |  15.87 |    1.0252 |      16 |
| USNationals2009            | 333oh   | f       |  20.37 |  29.58 |    1.0252 |      16 |
| HaNoiOpen2011              | 333     | f       |  12.81 |  16.85 |    1.0252 |      12 |
| SanFranciscoOpen2009       | 333     | f       |  13.41 |  19.50 |    1.0253 |      16 |
| Borneo2010                 | 333oh   | f       |  24.46 |  49.31 |    1.0254 |      29 |
| NorwegianOpen2009          | 555     | f       | 132.07 | 142.42 |    1.0255 |       4 |
| CyberOpen2011              | 333     | f       |  11.72 |  15.47 |    1.0256 |      12 |
| IndonesianChampionship2010 | pyram   | f       |   7.81 |  37.41 |    1.0256 |      63 |
| Seoul2008                  | 333     | f       |  13.63 |  18.00 |    1.0256 |      12 |
| JapanOpen2011              | 444     | f       |  44.64 |  59.13 |    1.0259 |      12 |
| KoreanChampionship2011     | 333     | f       |  11.13 |  16.34 |    1.0259 |      16 |
| GermanOpen2007             | 333     | f       |  13.62 |  20.01 |    1.0260 |      16 |
| ChinaTourismDay2012        | 222     | f       |   5.20 |   9.15 |    1.0260 |      23 |
| USNationals2010            | 333oh   | f       |  18.53 |  27.29 |    1.0261 |      16 |
| MunichOpen2010             | 555     | f       |  92.72 | 136.68 |    1.0262 |      16 |
| TaiwanWinterOpen2010       | 333     | f       |  12.42 |  16.51 |    1.0262 |      12 |
| GalantaOpen2009            | 333     | f       |  15.20 |  20.22 |    1.0263 |      12 |
| PolishOpen2008             | 333     | f       |  12.89 |  17.15 |    1.0263 |      12 |
| BWOpen2012                 | 555     | f       |  85.49 | 113.85 |    1.0264 |      12 |
| SpanishChampionship2011    | 333     | f       |  11.73 |  15.63 |    1.0264 |      12 |
| HungarianOpen2008          | 333     | f       |  13.20 |  19.56 |    1.0266 |      16 |
| Germany2009                | 444     | f       |  59.53 |  71.54 |    1.0266 |       8 |
| USOpen2008                 | 444     | f       |  57.95 |  77.44 |    1.0267 |      12 |
| JRCAKansaiSpring2010       | 333     | f       |  12.21 |  13.93 |    1.0267 |       6 |
| IndonesianOpen2011         | 555     | f       |  92.81 | 124.06 |    1.0267 |      12 |
| CubingKoreaNewYears2012    | 333     | f       |  10.79 |  22.05 |    1.0268 |      28 |
| WC2011                     | 555     | f       |  59.94 |  89.18 |    1.0268 |      16 |
+----------------------------+---------+---------+--------+--------+-----------+---------+
100 rows in set (0.69 sec)

That AachenSummer2012 round with 39 persons stands out a bit and indeed looks rather dense:
http://www.worldcubeassociation.org/...esults=1#333_f

Btw, note that I only consider rounds where the worst average was still successful (not a DNF). I might thus be missing rounds with one or more DNF average that are otherwise very dense.

[cuber952]

What is the record for breaking a competition PB in consecutive competitions?

[kinch2002]

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