Odd WCA stats/ Stats request Thread

[Hazel]

Cubing doesn't discriminate. lgbt+ or straight, you probably won't make it into the 3x3x3 finals in US nationals unless you practice a whole lot which is not influenced by your orientation/gender
I am also pretty sure this isn't registered in anyplace where we get stats from.

If there is anyone in particular that you liked from the 3x3x3 finals in US nationals but that would need to be lgbt+ for the two of you to have a chance, I would suggest to contact them in private

Checks history, , I made it to the B Final in US Open 2007...close enough

I know cubing doesn't discriminate, I just think it would be fun if I was the first one

 

[Gomorrite]

https://www.worldcubeassociation.org/persons/2015MAGA02

This guy has the fastest first solve when participating for the first time in 3x3 with 7.52. Now, more than 3 years and 110 solves later, it is still his best solve.

Source: https://jonatanklosko.github.io/wca_statistics/best_first_single

 

[AvGalen]

I know cubing doesn't discriminate, I just think it would be fun if I was the first one

I still have no idea who you really are because you haven't linked your WCA profile. So I don't even know if you already managed to do this or if you are dreaming out loud . The wonders of online identities.
...and now that we are on the topic, <investigator mode>I am 100% sure you are hiding your real identity, but in a predictable way. If we reverse your name and location they become "who are you" AMrea and "where are you" INwem". So that explains 40% already. The other 60% might look random, but is of course an abbreviation like "Really Extra Attractive/Annoying/Anxious/Alien" and "Western-Europe, Monaco"</investigator mode>

It would be kind of sad if after all these year and podiums you would be the first/only one. Depending on where you get your statistics from LGTB+ would be about 1/16 (general) or 1/10 (young people, like cubers). So statistically speaking you would expect some "matches" by now. Still not sure why anyone would be looking for a link to sexual orientation and location-based-cubing-results except for the <insert-dad-joke>common factor of orientation</insert-dad-joke>

 

[Hazel]

I still have no idea who you really are because you haven't linked your WCA profile. So I don't even know if you already managed to do this or if you are dreaming out loud . The wonders of online identities.
...and now that we are on the topic, <investigator mode>I am 100% sure you are hiding your real identity, but in a predictable way. If we reverse your name and location they become "who are you" AMrea and "where are you" INwem". So that explains 40% already. The other 60% might look random, but is of course an abbreviation like "Really Extra Attractive/Annoying/Anxious/Alien" and "Western-Europe, Monaco"</investigator mode>

It would be kind of sad if after all these year and podiums you would be the first/only one. Depending on where you get your statistics from LGTB+ would be about 1/16 (general) or 1/10 (young people, like cubers). So statistically speaking you would expect some "matches" by now. Still not sure why anyone would be looking for a link to sexual orientation and location-based-cubing-results except for the <insert-dad-joke>common factor of orientation</insert-dad-joke>

Woah there! Mewni is the name of a dimension in a cartoon I like, and my username has very little meaning (and it certainly isn't an acronym!). I am just dreaming out loud, I'm barely sub-12 XD It's very improbable that every US Nationalist has been cisgender/heterosexual, you're right...

 

[Kit Clement]

                       males        females
mean of best average:  39.17        1:06.65
number:                12782           1411
with sub20 average:     3295 (25.8%)    107 (7.6%)
with sub15 average:     1117  (8.7%)     25 (1.8%)
with sub10 average:       45  (0.35%)     1 (0.07%)

sub15 among sub20:      33.9%          23.4%
sub10 among sub15:       4.0%           4.0%

select count(*), sum(ba), sum(ba)/count(*)/100
from (select personId, min(average) ba
from Results, Persons
where eventId='333' and average>0 and Persons.id=personId and gender='f'
group by personId) helper
where ba<1500

Wanted to re-do this analysis from 2012 for a point of comparison.

                       males          females
mean of best average:  36.01            58.93
number:                92086             9418
with sub20 average:    25980 (28.2%)      983 (10.4%)
with sub15 average:    11408 (12.4%)      377 (4.0%)
with sub10 average:     1123 (1.22%)       28 (0.3%)

sub15 among sub20:      43.9%           38.4%
sub10 among sub15:       9.8%            7.4%

 

[AvGalen]

Wanted to re-do this analysis from 2012 for a point of comparison.

                       males          females
mean of best average:  36.01            58.93
number:                92086             9418
with sub20 average:    25980 (28.2%)      983 (10.4%)
with sub15 average:    11408 (12.4%)      377 (4.0%)
with sub10 average:     1123 (1.22%)       28 (0.3%)

sub15 among sub20:      43.9%           38.4%
sub10 among sub15:       9.8%            7.4%

Those are amazing stats. Not only showing the absolute amounts of competitors having gone way up, but the level of all cubers has gone up even more. Literally every stat in their shows a big improvement.

I really wish this statistic could be shown in 2, 4 or 5 year increments on the official WCA page for every puzzle!

 

[Gomorrite]

https://www.worldcubeassociation.org/persons/2015MAGA02

This guy has the fastest first solve when participating for the first time in 3x3 with 7.52. Now, more than 3 years and 110 solves later, it is still his best solve.

Source: https://jonatanklosko.github.io/wca_statistics/best_first_single

And one week after my comment, he finally broke his PB. Now it's 6.65 (WR283)

 

[Gomorrite]

Two record weeks are coming!

https://jonatanklosko.github.io/wca_statistics/competitions_count_by_week

 

[2018AMSB02]

Has anyone else noticed that the cube in the WCA logo has the wrong color scheme?

 

[weatherman223]

Can anyone find the most common first 4 letters of WCA IDs? (Biggest mode in database)

 

[Mike Hughey]

Has anyone else noticed that the cube in the WCA logo has the wrong color scheme?

You're absolutely right - the red and yellow should be swapped.

Spoiler

Well, at least, that would make it match my color scheme.

Actually, their logo matches perfectly my original 1981 Rubik's cubes, so I'd say their logo is right, and your color scheme is wrong. (and, for that matter, so is mine)

 

[Mike Hughey]

Can anyone find the most common first 4 letters of WCA IDs? (Biggest mode in database)

I did this query against my copy of the database export from the beginning of this year; it's not up to date, but it should be close:

select substr(id, 5, 4), count(substr(id, 5, 4)) from Persons group by substring(id, 5, 4) order by count(substr(id, 5, 4)) desc;

'WANG', '879'
'CHEN', '839'
'ZHAN', '791'
'YANG', '525'
'HUAN', '481'
'MART', '450'
'SILV', '414'
'SANT', '384'
'ZHAO', '382'
'CHAN', '352'

In case you're wondering, this one is at #65:
'MILL', '119'

 

[asacuber]

the last weekend when there was no comp?

 

[2018AMSB02]

Anyone know the worst official solve on 3x3? How about 2x2?

 

[Mike Hughey]

Anyone know the worst official solve on 3x3? How about 2x2?

Not counting DNFs, of course; this is from the end of last year - I really need to download the latest export. But here it is as of end of last year:

3x3x3: 15:08.00 Isabella Petri (2010PETR02), SESC Santos 2010
2x2x2: 11:24.00 Jimeng Guo (郭冀蒙) (2016GUOJ02), Tangshan Open 2017

Query I used:
select competitionId, personId, personName, greatest(value1, value2, value3, value4, value5) from Results where eventId = '333' order by greatest(value1, value2, value3, value4, value5) desc;

For 3x3x3, my wife has 3 of the top 1000 worst singles, and for 2x2x2, my youngest daughter has one of the top 100 worst singles.

 

[2018AMSB02]

Wow! 3x3 was about what I was expecting, but 2x2 is just crazy! How did they deal with the timers after 10 minutes? I dont think they would have used a stopwatch as a backup for 2x2.

 

[Mike Hughey]

Wow! 3x3 was about what I was expecting, but 2x2 is just crazy! How did they deal with the timers after 10 minutes? I dont think they would have used a stopwatch as a backup for 2x2.

That is an interesting question. He was actually already at the time a very decent solver. It's possible it could be a typo that was never caught, or maybe it was something special - an attempt to solve it BLD or some other special way, so they had a stopwatch backup especially for that solve, or maybe they synchronized a stopwatch with the stackmat when he had a problem, like popping it. It would be nice to know the story - perhaps a current delegate reading this could check the competition delegate report and see if this solve was mentioned.

 

[Ronxu]

perhaps a current delegate reading this could check the competition delegate report and see if this solve was mentioned.

nope

 

[SM cubing]

Not counting DNFs, of course; this is from the end of last year - I really need to download the latest export. But here it is as of end of last year:

3x3x3: 15:08.00 Isabella Petri (2010PETR02), SESC Santos 2010
2x2x2: 11:24.00 Jimeng Guo (郭冀蒙) (2016GUOJ02), Tangshan Open 2017

Query I used:
select competitionId, personId, personName, greatest(value1, value2, value3, value4, value5) from Results where eventId = '333' order by greatest(value1, value2, value3, value4, value5) desc;

For 3x3x3, my wife has 3 of the top 1000 worst singles, and for 2x2x2, my youngest daughter has one of the top 100 worst singles.

You seem pleased at your family’s misfortune my dude

 

[Mike Hughey]

nope

Wow, makes it seem like there's a good chance it's a typo, then.

You seem pleased at your family’s misfortune my dude

It wasn't really misfortune; for them, at the time, they were pretty decent results. A successful solve is still a successful solve.