Stefan
Member
Today I realized I have a better official skewb average than 2x2 average (because my 2x2 average had one 9 and a DNF). Are there any combinations of two events where only 1 person has a better result in one than the other? I think there was only 1 person with a better 5BLD than 4BLD, but I'm not sure.
That's a good one. Someone please check this independently, though. I did single and average separately, seemed easiest.
Using data from WCA_export468_20140908 and Stefan's WCA statistics tools.
Cuber | Faster | Time | Slower | Time |
Haiyan Zhuang (庄海燕) | 3x3 blindfolded | 30.94 | Rubik's Cube | 33.69 |
Oliver Frost | 3x3 blindfolded | 38.12 | Skewb | 1:01.78 |
Mats Kollbrink | 3x3 with feet | 48.84 | 3x3 one-handed | 57.96 |
Denys Lazarenko (Денис Лазаренко) | 4x4 blindfolded | 5:11.84 | 5x5 Cube | 5:25.50 |
Zheng Li (李政) | 5x5 Cube | 2:08.74 | Skewb | 4:07.94 |
Vojtěch Dvořák | 5x5 blindfolded | 15:42.00 | 4x4 blindfolded | 19:32.00 |
Xinye Wang (王鑫晔) | 6x6 Cube | 6:21.91 | 3x3 one-handed | 9:59.36 |
Julio Martín Gómez Telésforo | 6x6 Cube | 8:33.91 | 4x4 Cube | 9:09.13 |
Xinye Wang (王鑫晔) | 7x7 Cube | 8:38.22 | 3x3 one-handed | 9:59.36 |
Vivek Prasad Mada | Megaminx | 4:08.44 | Rubik's Clock | 4:40.79 |
ALTER TABLE RanksSingle ADD INDEX person (personId ASC);
SELECT a.personId Cuber, a.eventId 'Faster', a.best 'Time', b.eventId 'Slower', b.best 'Time'
FROM RanksSingle a join RanksSingle b on a.personId = b.personId
WHERE a.best < b.best
GROUP BY a.eventId, b.eventId
HAVING count(*) = 1;
ALTER TABLE RanksSingle DROP INDEX person;
SELECT a.personId Cuber, a.eventId 'Faster', a.best 'Time', b.eventId 'Slower', b.best 'Time'
FROM RanksSingle a join RanksSingle b on a.personId = b.personId
WHERE a.best < b.best
GROUP BY a.eventId, b.eventId
HAVING count(*) = 1;
ALTER TABLE RanksSingle DROP INDEX person;
Using data from WCA_export468_20140908 and Stefan's WCA statistics tools.
Cuber | Faster | Time | Slower | Time |
Yudanis Taqwin Rohman | 3x3 blindfolded | 49.36 | Skewb | 52.66 |
Mats Kollbrink | 3x3 with feet | 1:05.78 | 3x3 one-handed | 1:14.57 |
Antonio Aguilera Manzano | 5x5 Cube | 2:12.55 | 3x3 one-handed | 2:15.01 |
Yiliang Lu (路义亮) | 5x5 Cube | 2:46.00 | Rubik's Clock | 2:54.81 |
Nguyễn Ngọc Thịnh | 5x5 Cube | 1:21.32 | Skewb | 1:53.70 |
Nguyễn Ngọc Thịnh | Megaminx | 1:21.70 | Skewb | 1:53.70 |
ALTER TABLE RanksAverage ADD INDEX person (personId ASC);
SELECT a.personId Cuber, a.eventId 'Faster', a.best 'Time', b.eventId 'Slower', b.best 'Time'
FROM RanksAverage a join RanksAverage b on a.personId = b.personId
WHERE a.best < b.best
GROUP BY a.eventId, b.eventId
HAVING count(*) = 1;
ALTER TABLE RanksAverage DROP INDEX person;
SELECT a.personId Cuber, a.eventId 'Faster', a.best 'Time', b.eventId 'Slower', b.best 'Time'
FROM RanksAverage a join RanksAverage b on a.personId = b.personId
WHERE a.best < b.best
GROUP BY a.eventId, b.eventId
HAVING count(*) = 1;
ALTER TABLE RanksAverage DROP INDEX person;
Edit: Should I rename these statistics "Dude, what is wrong with you??"?
Last edited: