Odd WCA stats/ Stats request Thread

qqwref · Aug 15, 2011

vcuber13 said:
I dont think this is right, if you look at the first 2 tim has a higher y value but the time took less time than dennis.

2085:35:57.00 = 7508157.00 = 24 pts (0 unsolved, so 24/24) in 8157 seconds (2:15:57)
2252:33:09.06 = 8109189.06 = 18 pts (6 unsolved, so 24/30) in 9189 seconds (2:33:09)
Tim definitely didn't take less time than Dennis did - you might be thinking of Dennis's 10/10 results.

vcuber13 · Aug 15, 2011

qqwref said:
2085:35:57.00 = 7508157.00 = 24 pts (0 unsolved, so 24/24) in 8157 seconds (2:15:57)
2252:33:09.06 = 8109189.06 = 18 pts (6 unsolved, so 24/30) in 9189 seconds (2:33:09)
Tim definitely didn't take less time than Dennis did - you might be thinking of Dennis's 10/10 results.

for some reason i didnt convert it and read it as XXYY:YY:YY.Z, and tim did take less time than dennis

TMOY · Aug 15, 2011

James Ludlow said:
or AVG

Or me

(23 comps in 2009, AFAIK nobody has attended more than that).

Sebastien · Aug 15, 2011

yes, it is surely you Francois. You should be 2nd as well with 21 comps in 2010. I might follow with 20 comps in 2010 then.

Iirc Stefan made a list earlier in this thread but I'm just too lazy to search for it.

Tim Reynolds · Aug 17, 2011

I'm way too lazy to look too, so I'll make the list myself:

Code:

personName 		year 	numCompetitions
François Courtès 	2009 	23
François Courtès 	2010 	21
Arnaud van Galen 	2009 	21
Sébastien Auroux 	2010 	20
Takao Hashimoto (橋本貴夫)2009 	20
Bob Burton 		2009 	19
François Courtès 	2011 	18
Shelley Chang 		2009 	18
Clément Gallet 		2009 	18
Lars Vandenbergh 	2008 	18
Lars Vandenbergh 	2009 	18
Erik Akkersdijk 	2010 	18
Bob Burton 		2008 	17
Adam Zamora 		2009 	17
Takao Hashimoto (橋本貴夫)2008 	17
Fabian Auroux 		2010 	16
Clément Gallet 		2008 	16
Berit Brüster 		2010 	16
Erik Akkersdijk 	2008 	16
Erik Akkersdijk 	2009 	16
Arnaud van Galen 	2008 	16

TMOY · Aug 18, 2011

In the first round of Magic at Polish Nats:

2 Korneliusz Tombarkiewicz 1.08 1.16 Poland 1.08 1.16 DNS 1.16 1.15

wtf ??? He did two solves, then declined the third and jumped directly to the fourth ? Or the Magic event at that comp was run one solve at a time instead of all five in a row ?
(Or more probably, the DNS should be a DNF.)

Bryan · Aug 18, 2011

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

Shouldn't it be averaged by the age of when they competed? Otherwise if someone competes once in 1982 at age 20, they're counted as a 39 year-old competitor for statistic purposes.

ilikecubing · Aug 18, 2011

How many people have a faster OH average than 2H average?

mr. giggums · Aug 18, 2011

ilikecubing said:
How many people have a faster OH average than 2H average?

Stefan said:

Two-handed vs one-handed, single:

Code:

th/oh    th      oh   who
------------------------------------------------------
 1.38   81.33   59.12 [url=http://www.worldcubeassociation.org/results/p.php?i=2011CARU01]Martín Carusso[/url]
 1.18   31.02   26.33 [url=http://www.worldcubeassociation.org/results/p.php?i=2010OKAM02]Scott Okamura[/url]
 1.07   29.46   27.43 [url=http://www.worldcubeassociation.org/results/p.php?i=2010YUDA01]Ahmad Leo Yudanto[/url]
 1.07  307.36  287.05 [url=http://www.worldcubeassociation.org/results/p.php?i=2010HAOZ01]Zhiqiang Hao (郝志强)[/url]
 1.01   21.21   20.90 [url=http://www.worldcubeassociation.org/results/p.php?i=2009LINX01]Xu Lin (林徐)[/url]
 1.01   14.16   14.06 [url=http://www.worldcubeassociation.org/results/p.php?i=2009SUKH01]Sittinon Sukhaya[/url]
 0.93   17.93   19.22 [url=http://www.worldcubeassociation.org/results/p.php?i=2010LIUH01]Hanhan Liu (刘含菡)[/url]
 0.90   25.13   27.97 [url=http://www.worldcubeassociation.org/results/p.php?i=2008MEIZ01]Zeming Mei (梅泽铭)[/url]
 0.89   11.03   12.43 [url=http://www.worldcubeassociation.org/results/p.php?i=2008VARG01]Dániel Varga[/url]
 0.87   17.50   20.19 [url=http://www.worldcubeassociation.org/results/p.php?i=2009PUTR05]Hadrian Josna Putra[/url]

SELECT a.record/b.record ratio, a.record/100 ar, b.record/100 br, a.personId, a.personName
FROM
(SELECT personId, personName, min(best) record FROM Results WHERE eventId='333' AND best>0 GROUP BY personId) a,
(SELECT personId,             min(best) record FROM Results WHERE eventId='333oh' AND best>0 GROUP BY personId) b
where a.personId = b.personId
order by ratio desc
limit 10;

Average:

Code:

th/oh    th      oh   who
------------------------------------------------------
 1.11   32.50   29.21 [url=http://www.worldcubeassociation.org/results/p.php?i=2010OKAM02]Scott Okamura[/url]
 1.09   25.42   23.32 [url=http://www.worldcubeassociation.org/results/p.php?i=2009LINX01]Xu Lin (林徐)[/url]
 1.01   17.12   17.01 [url=http://www.worldcubeassociation.org/results/p.php?i=2009SUKH01]Sittinon Sukhaya[/url]
 0.95   87.99   92.42 [url=http://www.worldcubeassociation.org/results/p.php?i=2011CARU01]Martín Carusso[/url]
 0.93   31.13   33.39 [url=http://www.worldcubeassociation.org/results/p.php?i=2010YUDA01]Ahmad Leo Yudanto[/url]
 0.91   24.63   27.03 [url=http://www.worldcubeassociation.org/results/p.php?i=2010CHEN53]Rongwei Chen (陈榕伟)[/url]
 0.84   25.73   30.46 [url=http://www.worldcubeassociation.org/results/p.php?i=2009YINC03]Chan Yui Yin[/url]
 0.84   29.54   35.06 [url=http://www.worldcubeassociation.org/results/p.php?i=2009PAMA01]Brian Pamandanan[/url]
 0.84   16.00   19.00 [url=http://www.worldcubeassociation.org/results/p.php?i=2009TAND01]Ramble Tandar[/url]
 0.83   21.17   25.50 [url=http://www.worldcubeassociation.org/results/p.php?i=2010KLAE01]Arut Klaewkasetkorn[/url]

there you go.

vcuber13 · Aug 18, 2011

martin shouldnt be on that list anymore, 2h 28.77 - 33.53, 1h 59.12 - 1:32.42

whitejustice93 · Aug 18, 2011

http://worldcubeassociation.org/results/p.php?i=2011NUGR02
this is my friend, his first official competition was Indonesian Open 2011 and he got DNF..

Mike Hughey · Aug 18, 2011

whitejustice93 said:
http://worldcubeassociation.org/results/p.php?i=2011NUGR02
this is my friend, his first official competition was Indonesian Open 2011 and he got DNF..

I love it - the only event he ever tried is 5x5x5 BLD! I really really wish he had gotten one solved - it would be so cool to have someone whose only successful solve in competition was a 5x5x5 BLD solve. Perhaps he'll try again soon?

Anthony · Aug 18, 2011

I'd like to know in what percentage of averages of 5 of all events using that format have the fastest and slowest solves occur consecutively. Also, which order is more common.

mr. giggums · Aug 18, 2011

I'd like to know what is the most anyone has improved in a average of 5 where each solve decreases from the last.
For example here's an example average: 20 19 15 14 11 the range would be 9 so what is the highest number out there.

EDIT: I would also like to see a ratio so from the example 20/11 = 1.818 the higher the better.

Julian · Aug 18, 2011

mr. giggums said:
I'd like to know what is the most anyone has improved in a average of 5 where each solve decreases from the last.
For example here's an example average: 20 19 15 14 11 the range would be 9 so what is the highest number out there.

EDIT: I would also like to see a ratio so from the example 20/11 = 1.818 the higher the better.

What if someone gets and average of like
26, 12.5, 12, 11.5, 11
They didn't really 'improve', they just screwed up the first solve.

vcuber13 · Aug 18, 2011

that sort of happend to my 5x5 at cubecentric
2:22.96 1:44.84 1:44.34 2:00.19 1:38.75

mr. giggums · Aug 18, 2011

Julian said:
What if someone gets and average of like
26, 12.5, 12, 11.5, 11
They didn't really 'improve', they just screwed up the first solve.

I don't really know a way to get around that.

vcuber13 said:
that sort of happend to my 5x5 at cubecentric
2:22.96 1:44.84 1:44.34 2:00.19 1:38.75

This wouldn't qualify because of the 2:00.19. All times have to decease from the last.

Carrot · Aug 18, 2011

Code:

Name				Times					Event	Improvement	ratio (slow/fast)
Gilberto Caracciolo Morelli	(38455), 25272, 23309, 18493, (12916)	sq1	25539		2,977
Priyanka Sabnis			(28690), 19205, 16822, 11869, (11168)	333	17522		2,569
Gulshan Ramchandani		(36586), 34827, 26947, 26668, (21147)	444	15439		1,730
Jason So			(18119), 6006, 5993, 5111, (5081)	333	13038		3,566
Jill Hiraizumi			(19775), 16825, 12741, 11916, (8111)	333	11664		2,438
Lisa Chumpulpackdee		(20859), 14053, 11217, 10529, (9227)	333	11632		2,261
Vidar Klungre			(14530), 5441, 5346, 4996, (4138)	sq1	10392		3,511
Oleksandr Kolishchuk		(22708), 20508, 16347, 13163, (12759)	333	9949		1,780
Dennis Rogon			(50877), 47968, 47166, 47043, (40978)	555	9899		1,242
Shantanu Walke			(14801), 8268, 6336, 5789, (5003)	333	9798		2,958

Code:

Name				Times					Event	Improvement	ratio (slow/fast)
Aaron McGhie			(1042), 262, 131, 117, (115)		magic	927		9,061
Naman Shanishchara		(5361), 3711, 2086, 1033, (647)		pyram	4714		8,286
Adam Nyberg			(2972), 1109, 958, 563, (416)		222	2556		7,144
Pebam Pritam			(9353), 6234, 4144, 2840, (1408)	222	7945		6,643
Chunwei Qiao (ä¹”æ˜¥çŽ®)	(2138), 1561, 922, 755, (325)		222	1813		6,578
Quentin Dallison		(765), 580, 397, 188, (127)		magic	638		6,024
Mats Kollbrink			(8566), 5547, 5266, 3571, (1597)	222	6969		5,364
Kamil GÃ³rski			(775), 294, 209, 161, (146)		magic	629		5,308
Tim Reynolds			(552), 394, 316, 143, (109)		magic	443		5,064
Erik Akkersdijk			(468), 403, 388, 328, (96)		magic	372		4,875
...	
Jason So			(18119), 6006, 5993, 5111, (5081)	333	13038		3,566 (22nd place)

vcuber13 · Aug 18, 2011

i know i was just giving an example of a terrible first solve and decreasing almost the rest of the average.

qqwref · Aug 18, 2011

I kinda want to go do a 9:xx.xx 5.xx 4.xx 3.xx 1.xx on Magic now.

Odd WCA stats/ Stats request Thread

Legend

Veteran

Veteran

Premium Member

Premium Member

Veteran

Premium Member

Veteran

Veteran

Veteran

Member

Administrator

Professional Speedcuber

Veteran

Veteran

Veteran

Veteran

Veteran

Veteran

Legend

Similar threads