Odd WCA stats/ Stats request Thread

[qqwref]

I'm not sure about whauk's post, but maybe he means the longest row of steadily increasing times?


Here's a new question: has anyone ever won every round in a competition (which had more than one round)? If so, what was the competition with the most rounds where this was done? If not, what was the highest percentage of rounds anyone has won in a competition?

 

[cubernya]

Well I'm sure Feliks beats everyone in that qq

 

[qqwref]

I'm not.

EDIT: Looks like Feliks won everything here. So that's probably the record then. (But what's 2nd?)

 

[Pedro]

I'm not sure about whauk's post, but maybe he means the longest row of steadily increasing times?


Here's a new question: has anyone ever won every round in a competition (which had more than one round)? If so, what was the competition with the most rounds where this was done? If not, what was the highest percentage of rounds anyone has won in a competition?

Well, this is probably 1st place: http://worldcubeassociation.org/results/c.php?i=SESCSantos2011&allResults=1#333

(and he didn't do really well that day...)

EDIT

Well, your first question was about "every round", but I'm not sure if that means every round in the whole comp or every round in the same event...

EDIT 2

Nah, "every round in a competition" is pretty clear...

I've won a lot of stuff in the past:

10/11 (90.91%) - http://worldcubeassociation.org/results/c.php?i=MinasOpen2008
5/7 (71.43%) - http://worldcubeassociation.org/results/c.php?i=BrazilOpen2007
10/15 (66.67%) - http://worldcubeassociation.org/results/c.php?i=ABCOpen2010
8/13 (61.54%) - http://worldcubeassociation.org/results/c.php?i=SaoPauloOpen2009
7/12 (58.33%) - http://worldcubeassociation.org/results/c.php?i=SantiagoOpen2009
10/18 (55.56%) - http://worldcubeassociation.org/results/c.php?i=UNESPOpen2009
8/16 (50%) - http://worldcubeassociation.org/results/c.php?i=BrasiliaOpen2009

But not recently: 5/17 (29.41%), 6/15 (40%) and 1/17 (5.88%)

(I'm not counting the 4x4 bld with everybody DNFing)

 

[Stefan]

has anyone ever won every round in a competition (which had more than one round)?

+-----+----+-----------------------------+----------------------+
| won | of | personName                  | competitionId        |
+-----+----+-----------------------------+----------------------+
|  15 | 15 | Feliks Zemdegs              | MelbourneCubeDay2010 |
|  11 | 11 | Timothy Sun                 | DrexelWinter2010     |
|  10 | 10 | Bernett Orlando             | IndianOpen2010       |
|   8 |  8 | Bernett Orlando             | PragyanOpen2011      |
|   6 |  6 | Francisco Javier Lemes Sßez | SantiagoBLD2010      |
|   6 |  6 | Bernett Orlando             | DelhiOpen2010        |
|   5 |  5 | Shotaro Makisumi (?? ???)   | CaltechSpring2004    |
|   4 |  4 | Yumu Tabuchi (????)         | LISMOCup2010         |
|   3 |  3 | Shotaro Makisumi (?? ???)   | CaltechWinter2004    |
|   3 |  3 | Joδl van Noort              | Netherlands2005      |
|   2 |  2 | Piti Pichedpan              | NSMThailand2009      |
|   2 |  2 | Phillip Espinoza            | DiscoveryWinter2009  |
|   2 |  2 | John Louis                  | ApogeeOpen2011       |
|   2 |  2 | Nathan Azaria               | JavaFMCCubeDay2010   |
|   2 |  2 | OlivΘr Perge                | AthensOpen2010       |
|   2 |  2 | Sei Sugama (?? ?)           | KansaiNewYear2011    |
+-----+----+-----------------------------+----------------------+

SELECT won, of, personName, p.competitionId
FROM
(SELECT personId, personName, competitionId, count(*) won FROM Results WHERE pos=1 and best>0 GROUP BY personId, competitionId) p,
(SELECT competitionId, count(distinct eventId, roundId) of FROM Results GROUP BY competitionId) c
WHERE p.competitionId = c.competitionId AND won=of AND of>1
ORDER BY won/of desc, won desc

(only counting round wins with at least one successful attempt, but counting all rounds (including if everybody failed))

 

[Goosly]

Weird: This person doesn't have a gender.

I've searched the top 100 single 3x3 solves, and found only 2 female cubers:
This girl has 9.13 solve and she has a 8.63 solve. I was just looking because I know a girl who hasn't competed yet, but might get our next Belgian record.
Stefan, could you check if I missed someone? My SQL-skills have probably died out, and I also don't know where to download the WCA database (if this is available for everyone).

 

[vcuber13]

notice how both of them are canadian

 

[Stefan]

Weird: This person doesn't have a gender.

One of 454 persons where the database doesn't know it, nothing special.

I've searched the top 100 single 3x3 solves, and found only 2 female cubers:

No you didn't. There are none.
http://www.worldcubeassociation.org...gionId=&years=&show=100+Results&single=Single

This girl has 9.13 solve and she has a 8.63 solve.

You know, they do have names.

Next fastest is Patricia Li with 9.69 and there are no others with sub10 solves.

I also don't know where to download the WCA database (if this is available for everyone).

http://worldcubeassociation.org/results/misc/export.html

 

[Mike Hughey]

I just noticed that the top 100 people in 3x3x3 BLD are all now sub-1:30. (I think I remember predicting we'd get here about a year and a half ago. Yeah, I guess I'm not very good at predictions.)

I wonder how long it will be before the top 100 are sub-minute? (Currently there are 33 who are sub-minute.)

 

[RyanReese09]

I give it 2 more years.

 

[Stefan]

I just noticed that the top 100 people in 3x3x3 BLD are all now sub-1:30.

History looks roughly like this.

I wonder how long it will be before the top 100 are sub-minute?

Based on that graph, I'm guessing in 1.5 years, beginning of 2013.

 

[Hippolyte!!!]

Not odd, but very impressive:
http://imageshack.us/photo/my-images/202/gffjjj.png/

 

[Owen]

The top seven 3x3x3 singles are by the same dude.

 

[Pro94]

What is the best 3x3 SD, between first 100 results, removing best and worst time?

 

[MAHTI-ANSSI]

Now the top 100 official 3x3 average results are sub-10.

 

[Stefan]

Talking with Dave I mentioned that China is pretty good at memory competitions, then Dave said they're pretty good at many things, then I said it has to do with them being so many, and that it helps even more in team games because it's not enough to happen to have one good player. Then we translated that to cubing. Which country is the best, judged by the average of their top 10 cubers (3x3 average)? Again, it's not enough to happen to have one good player, so Feliks can dominate all he wants but Australia is still nowhere near the top

 1  USA                    10.2900            
 2  Japan                  10.4230            
 3  Thailand               10.4600            
 4  China                  10.5210            
 5  Germany                10.8600            
 6  Poland                 11.0020            
 7  Italy                  11.1000            
 8  Taiwan                 11.1020            
 9  Indonesia              11.1860            
10  Canada                 11.4840            
11  Malaysia               11.8220            
12  France                 11.8220            
13  United Kingdom         11.9440            
14  Hungary                12.1120            
15  Korea                  12.1290            
16  Philippines            12.1720            
17  Sweden                 12.2380            
18  Spain                  12.2550            
19  Netherlands            12.3210            
20  Russia                 12.4670            
21  Brazil                 12.4950            
22  Vietnam                12.5800            
23  Australia              12.7800            
24  Hong Kong              12.9400            
25  Singapore              13.9800            
26  Finland                14.4540            
27  Chile                  14.5090            
28  Norway                 14.5440            
29  Austria                14.6180            
30  Denmark                15.2320            
31  Israel                 16.0330            
32  India                  16.0360            
33  Mexico                 16.3790            
34  New Zealand            16.5420            
35  Belgium                17.3660            
36  Ukraine                17.4970            
37  Colombia               18.6490            
38  Romania                19.0260            
39  Peru                   19.8930            
40  Switzerland            20.8720            
41  Argentina              22.5860            
42  Slovenia               23.0110            
43  Portugal               24.9430            
44  Estonia                27.4000            
45  Czech Republic         27.5890            
46  Greece                 39.9910            
47  Slovakia               42.2470

Query (not exactly recommended):

select
	@num2 :=  @num2 + 1 as row_number,
	o.country,
	o.score
from
(

	select 
		n.country,
		(sum(n.average) / 1000) as score,
		max(n.row_number) as row_counter
	from
	(
		select 
			m.country,
			m.person,
			m.average,	
			@num := if(@group = m.country, @num + 1, 1) as row_number,
			@group := m.country as dummy,
			@num2:= 0
		from 
		(
			select 
				results.personCountryId as country,
				results.personName as person,
				min(results.average) as average
			      
			from   results
			where results.eventId like '333' and results.average > 0
			group by results.personId, results.personCountryId
			order by results.personCountryId, average
		)
		m
	)
	n
	where
		n.row_number <=10
	group by n.country
	order by score 
)
o
	where o.row_counter >=10

For the write-up, I tried to reconstruct how we started this conversation, and Dave found it ironic that I couldn't remember that I had started it by talking about memory competitions. Pfft.

 

[Ltsurge]

but in terms of per capita... Well all I can say is america is definitely not at the top then

 

[Erdos]

Talking with Dave I mentioned that China is pretty good at memory competitions, then Dave said they're pretty good at many things, then I said it has to do with them being so many, and that it helps even more in team games because it's not enough to happen to have one good player. Then we translated that to cubing. Which country is the best, judged by the average of their top 10 cubers (3x3 average)? Again, it's not enough to happen to have one good player, so Feliks can dominate all he wants but Australia is still nowhere near the top
...

Very cool post. This is also a pretty good indication of where cubing is most competitive.

 

[DavidWoner]

Any way we could see average age by country?

 

[Stefan]

but in terms of per capita... Well all I can say is america is definitely not at the top then

It definitely is! USA shares first place with every other country as all countries are getting DNF.

Any way we could see average age by country?

Can't do it right now, but it should be fairly easy. Something like:

SELECT countryId, avg(datediff(now(),year*10000+month*100+day))/365.25 avgAge
FROM Persons
WHERE day>0
GROUP BY countryId
ORDER BY avgAge

Which country is the best, judged by the average of their top 10 cubers (3x3 average)?

Btw, with judging by top 200 instead, USA still leads but China moved up to second place, and judging by top 300, China is on top. Don't know the exact point where they switch, and they might also switch back and forth several times. And maybe at some point some third country would be on top, haven't checked that, either (well, judging by top 1, obviously "Australia" wins).