Odd WCA stats/ Stats request Thread

[sam596]

Fastest time taken (in terms of days/years) to complete all WCA events?

Is there anyone who completed all on their first comp?

Don't know for definite, but this guy is a contender.

https://www.worldcubeassociation.org/results/p.php?i=2016FANG01

Competed first March 19th, got a single and avg in all events by November 27th same year.

 

[sam596]

Who's been to the most comps but never got below a 10, 20, 30, 40, 50 and 60 second average in 3x3?


Sent from my iPhone using Tapatalk

 

[1973486]

Who's been to the most comps but never got below a 10, 20, 30, 40, 50 and 60 second average in 3x3?

10: François Courtès (184)
20: Maria Oey (125)

Only ones I'm sure about.

 

[Kit Clement]

Who's been to the most comps but never got below a 10, 20, 30, 40, 50 and 60 second average in 3x3?


Sent from my iPhone using Tapatalk

10: François Courtès (184)
20: Maria Oey (125)

Only ones I'm sure about.

I believe 30, 40, 50, and 60 are all Takao Hashimoto, who has competed in 91 competitions but has never competed in the 3x3x3 event.

 

[sam596]

I believe 30, 40, 50, and 60 are all Takao Hashimoto, who has competed in 91 competitions but has never competed in the 3x3x3 event.

But what about people who have competed in 3x3?


Sent from my iPad using Tapatalk

 

[asacuber]

10: François Courtès (184).

In memoriam

 

[shadowslice e]

I there a way to use the competition registrations list to bring up a list of pbs by event?

 

[sam596]

I there a way to use the competition registrations list to bring up a list of pbs by event?

Fantasy Cubing?

I do it with SQL queries for the comps that don't have psych sheets.

 

[henrysavich]

Average competition winning time for 3x3 for each year?

 

[guysensei1]

Are there cubers than cannot be linked to one another based on shared competitions?

For example, if I wanted to link with Feliks, I would go like this:
I have been to a competition with Jonathan Chng.
Jonathan Chng has been to a competition with Feliks, done.

And what's the highest number of such 'links' that need to be made to connect 2 cubers?

 

[FJT97]

As Max Park broke the NAR twice in a single comp recently, i thought if theres a statistic for best average means during comps with three rounds of an Event.

 

[AlphaSheep]

Are there cubers than cannot be linked to one another based on shared competitions?

For example, if I wanted to link with Feliks, I would go like this:
I have been to a competition with Jonathan Chng.
Jonathan Chng has been to a competition with Feliks, done.

And what's the highest number of such 'links' that need to be made to connect 2 cubers?

I would guess it's highly unlikely that two competitors can't be linked, and I doubt there would be any. Only a handful of delegates don't compete, so the vast majority of competitors have been to a competition that a delegate competed at. Then it just reduces to linking the delegates which is a much smaller problem.

The other question is interesting. I've been wanting to work on a maximum degree of separation type problem for a while. I'll see if I can find some time to work on it over the weekend.

 

[FJT97]

Are there cubers than cannot be linked to one another based on shared competitions?

For example, if I wanted to link with Feliks, I would go like this:
I have been to a competition with Jonathan Chng.
Jonathan Chng has been to a competition with Feliks, done.

And what's the highest number of such 'links' that need to be made to connect 2 cubers?

I dont think there are People that cannot be linked.
I heared that over a "chain" of three of your Facebook friends you are linked with all Facebook users. And Facebook is so much bigger and i in Terms of "themes" of the users widely spread, so its way less likely, that i'm linked with a Person i have nothing in common, ´but we cubers have much in common so i thinks its way more likely to bei linked in a shorter chain.

 

[AlphaSheep]

Are there cubers than cannot be linked to one another based on shared competitions?

For example, if I wanted to link with Feliks, I would go like this:
I have been to a competition with Jonathan Chng.
Jonathan Chng has been to a competition with Feliks, done.

And what's the highest number of such 'links' that need to be made to connect 2 cubers?

Rather than linking cubers, I linked competitions (which is a much smaller problem but is equivalent - every cuber who was at the competition with you and Jonathan Chng can be linked to every cuber who was at the competition with Jonathan Chng and Feliks). A competition is linked if the same person competed in both competitions. It gives enough information to answer your question.

No, there are no isolated communities - every cuber can be linked to every other cuber.
The longest chain involves 13 competitions.

Distance:   0, Count:     3465, (  0.03 %)
Distance:   1, Count:   643468, (  5.36 %)
Distance:   2, Count:  1530184, ( 12.75 %)
Distance:   3, Count:  2905620, ( 24.21 %)
Distance:   4, Count:  3220186, ( 26.83 %)
Distance:   5, Count:  1817478, ( 15.14 %)
Distance:   6, Count:  1173406, (  9.78 %)
Distance:   7, Count:   373760, (  3.11 %)
Distance:   8, Count:   215804, (  1.80 %)
Distance:   9, Count:    59276, (  0.49 %)
Distance:  10, Count:    40564, (  0.34 %)
Distance:  11, Count:    18652, (  0.16 %)
Distance:  12, Count:     4242, (  0.04 %)
Distance:  13, Count:      120, (  0.00 %)
Distance:  14, Count:        0, (  0.00 %)

Here's the Python code I used

EDIT: This is all wrong. See this post for the correct answer.

 

[1973486]

Do you know which competitions have 13 links?

 

[Mattheo DW]

Probably already asked some time ago, but what are the top 10 / 50 closest podiums (in any event)?

 

[bubbagrub]

Average competition winning time for 3x3 for each year?

+------+---------+
| year | average |
+------+---------+
| 2003 |   20.00 |
| 2004 |   19.82 |
| 2005 |   18.37 |
| 2006 |   16.01 |
| 2007 |   14.54 |
| 2008 |   13.65 |
| 2009 |   13.59 |
| 2010 |   12.33 |
| 2011 |   11.73 |
| 2012 |   11.83 |
| 2013 |   10.76 |
| 2014 |   10.60 |
| 2015 |   10.40 |
| 2016 |    9.96 |
| 2017 |    9.54 |
+------+---------+

SQL: select year,ROUND(avg(average)/100,2) as average from Results,Competitions where pos=1 and eventId="333" and roundId IN ("f","c") and Competitions.Id=Results.competitionId and average > 0 group by year;

 

[vcuber13]

Are there cubers than cannot be linked to one another based on shared competitions?

For example, if I wanted to link with Feliks, I would go like this:
I have been to a competition with Jonathan Chng.
Jonathan Chng has been to a competition with Feliks, done.

And what's the highest number of such 'links' that need to be made to connect 2 cubers?

There was a similar stat called the Blonk number

 

[AlphaSheep]

Do you know which competitions have 13 links?

Going to have to dig into the data tonight to find out. I've been doubting it ever since I posted it.

There was a similar stat called the Blonk number

The cubing community has grown significantly since then. I was considering calculating a van Bruchem number for every competitor but I decided it would take too long. That's when I started focusing on competitions rather than competitors.

Amazing how the Dubai Open 2009 is only linked to the rest of the world by Mohammad Forootani, who competed at the Austrian Open 2010.

 

[AlphaSheep]

Do you know which competitions have 13 links?

Spoiler: Competitions that are 13 links apart

Distance: 13      TorneoCosmocentro2016 --> CagayanValleyOpen2016
Distance: 13      TorneoCosmocentro2016 --> SpeedcubeWeekendMerida2016
Distance: 13      TorneoCosmocentro2016 --> CebuOpen2016
Distance: 13      TorneoCosmocentro2016 --> TagumCityOpen2016
Distance: 13      TorneoCosmocentro2016 --> TunisiaSummerOpen2016
Distance: 13      TorneoCosmocentro2016 --> PrimeOneChihuahua2016
Distance: 13      TorneoCosmocentro2016 --> CEICMasterdaOpen2016
Distance: 13      TorneoCosmocentro2016 --> AlgersSummerOpen2016
Distance: 13      TorneoCosmocentro2016 --> MoldavianNationalsSummer2016
Distance: 13      TorneoCosmocentro2016 --> NhaTrangSummerOpen2016
Distance: 13      TorneoCosmocentro2016 --> NLCAnniversary2016
Distance: 13      TorneoCosmocentro2016 --> YoRubik2016
Distance: 13      TorneoCosmocentro2016 --> BotosaniRubikOpen2016
Distance: 13      TorneoCosmocentro2016 --> PraxisOpen2016
Distance: 13      TorneoCosmocentro2016 --> EbenezerSpring2016
Distance: 13      TorneoCosmocentro2016 --> CubingAtmosphere2016
Distance: 13      TorneoCosmocentro2016 --> AmaltheaSCMUOpen2016
Distance: 13      TorneoCosmocentro2016 --> MaharashtraChampionship2016
Distance: 13      TorneoCosmocentro2016 --> P3GrandOpen2016
Distance: 13      TorneoCosmocentro2016 --> KuboOpen2016
Distance: 13      TorneoCosmocentro2016 --> CubeleloWinterOpen2016
Distance: 13      TorneoCosmocentro2016 --> IliganOpen2016
Distance: 13      TorneoCosmocentro2016 --> P3GrandOpenJan2017
Distance: 13      TorneoCosmocentro2016 --> CubersEastIndiaOpen2017
Distance: 13      TorneoCosmocentro2016 --> MalabarOpen2017
Distance: 13      TorneoCosmocentro2016 --> CubeChallengeQuark2017
Distance: 13      TorneoCosmocentro2016 --> CubeEManiaOpen2017
Distance: 13      TorneoCosmocentro2016 --> RubiXtremePiatraNeamt2017
Distance: 13      TorneoCosmocentro2016 --> SiguldaOpen2017
Distance: 13      TorneoCosmocentro2016 --> PolyhedraOpen2017
Distance: 13      TorneoCosmocentro2016 --> SpeedsolvingPucallpa2017
Distance: 13      TorneoCosmocentro2016 --> P3GrandOpenFeb2017
Distance: 13      TorneoCosmocentro2016 --> PanaboSpeedcubeChallenge2017
Distance: 13      TorneoCosmocentro2016 --> SynoCubixOpen2017
Distance: 13      TorneoCosmocentro2016 --> InquivestaCubeOpen2017
Distance: 13      GeniusCube2016 --> MaharashtraChampionship2016
Distance: 13      GeniusCube2016 --> P3GrandOpen2016
Distance: 13      GeniusCube2016 --> KuboOpen2016
Distance: 13      GeniusCube2016 --> CubeleloWinterOpen2016
Distance: 13      GeniusCube2016 --> IliganOpen2016
Distance: 13      GeniusCube2016 --> P3GrandOpenJan2017
Distance: 13      GeniusCube2016 --> CubersEastIndiaOpen2017
Distance: 13      GeniusCube2016 --> MalabarOpen2017
Distance: 13      GeniusCube2016 --> CubeChallengeQuark2017
Distance: 13      GeniusCube2016 --> CubeEManiaOpen2017
Distance: 13      GeniusCube2016 --> RubiXtremePiatraNeamt2017
Distance: 13      GeniusCube2016 --> SiguldaOpen2017
Distance: 13      GeniusCube2016 --> PolyhedraOpen2017
Distance: 13      GeniusCube2016 --> SpeedsolvingPucallpa2017
Distance: 13      GeniusCube2016 --> P3GrandOpenFeb2017
Distance: 13      GeniusCube2016 --> PanaboSpeedcubeChallenge2017
Distance: 13      GeniusCube2016 --> SynoCubixOpen2017
Distance: 13      GeniusCube2016 --> InquivestaCubeOpen2017
Distance: 13      FirstEcuadorOpen2017 --> SiguldaOpen2017
Distance: 13      FirstEcuadorOpen2017 --> PolyhedraOpen2017
Distance: 13      FirstEcuadorOpen2017 --> SpeedsolvingPucallpa2017
Distance: 13      FirstEcuadorOpen2017 --> P3GrandOpenFeb2017
Distance: 13      FirstEcuadorOpen2017 --> PanaboSpeedcubeChallenge2017
Distance: 13      FirstEcuadorOpen2017 --> SynoCubixOpen2017
Distance: 13      FirstEcuadorOpen2017 --> InquivestaCubeOpen2017

From a quick look, it's mostly chains from competitions in remote parts of South America to competitions in remote parts of Asia.

EDIT: This is all wrong. See this post for correct answer.