• Welcome to SpeedSolving.com — the world’s largest puzzle community!

    You’re currently browsing as a guest, which means you have limited access to discussions, resources, member profiles, and community features.

    Join 50,000+ cubers and puzzle enthusiasts from around the world to ask questions, share solves, improve faster, and be part of the community.

    Registration is free, fast, and easy — create your account today.

    Already a member? Log in here to hide this message and start participating.
3x3 single and average NRs, but based on where it was set, not the citizenship of the person?

Singles:
CountryCompetitionPerson"NR" Single
AndorraIutopiaOpen20142013TORN028.92
ArgentinaUTNOtono20152012HAML018.83
AustraliaCubeForCambodia20152009ZEMD015.61
AustriaAustrianBigCubeOpen20142005AKKE017.25
AzerbaijanBakuOpen20152015NABI0113.48
BelarusCubingFest20142011DOBR016.84
BelgiumZonhovenOpen20132007VALK015.55
BoliviaCochabambaOpen20152011CUBA028.44
Bosnia and HerzegovinaBIHOpen20122005BATI016.93
BrazilWC20152009ZEMD015.39
CanadaCanadianOpen20152010WANG685.72
ChileLaFloridaOpen20152010FUEN018.03
ChinaCubeEliteUnionCafe20142010WANG535.81
ColombiaTorneoSalitrePlaza20152011SALG017.40
CroatiaCroatianOpen20142010OMUL027.69
Czech RepublicCzechOpen20082005AKKE017.08
DenmarkEuro20142010CORM026.41
Dominican RepublicBackTo360Open20142013SIER018.17
EstoniaEstonianOpen20152013JOKI017.28
FinlandHelsinkiBlindWeekend20152013JOKI017.92
FranceFLIPOpen20152012CARL036.37
GeorgiaGeorgianOpen20132013KAKH019.62
GermanyFrankfurtCubeDays20152009DIEC016.26
GreeceGreeceOpen20152012PATE017.84
GuatemalaGuateRubik20152014BARR0211.00
Hong KongAsianChampionship20122010SICH017.33
HungaryHungarianNationals20152009BOZS017.75
IcelandIcelandOpen20122003BRUC0110.03
IndiaIndianNationals20142012RUPE016.91
IndonesiaBandungOpen20152010UTOM016.61
IranBeheshtiCubingDays20142011FATE017.30
IrelandIrishChampionship20152012BEAH017.39
IsraelIsraelChampionship20142010ALFA039.84
ItalySmallCubingItaly20152011BARB036.64
JapanAsianChampionship20142013NAHM016.15
JordanJordanOpen20122012DOOF0211.34
KoreaGoodCubeShowKorea20152013KYOU016.69
LatviaLatvianOpen20142012BARA039.32
LithuaniaLithuanianOpen20132012BARA0311.40
MacauMacauOpen20092008SOPA0110.53
MalaysiaMelakaOpen20142009JIAY017.18
MexicoClasico20152014HERN087.73
MoldovaMoldavianNationals20152011MELI019.95
MongoliaMongolianOpen20132012DAVA0111.13
NetherlandsDutchOpen20142007VALK016.23
New ZealandNewZealandNationals20142011LINA017.40
NorwayKjellerOpen20142011HAMS016.50
PeruTCGAndFriends20152009ZEMD016.10
PhilippinesSMCityRosales20132013BAUT017.09
PolandCubingSpringGrudziadz20122009PLES016.11
PortugalPortugalOpen20142010GARC028.02
RomaniaRomanianOpen20122005BATI018.06
RussiaNelidovoOpen20132009RYAB016.86
SerbiaSerbianOpen20132005BATI018.03
SingaporeSingaporeOpen20152010ADHI017.40
SlovakiaBratislavaNoCutoffOpen20152009BOZS017.36
SloveniaSlovenianOpen20152009BOZS016.84
South AfricaCapeTown20142009ZEMD015.91
SpainMontgrosOpen20152011SANC026.58
SwedenLinkub20152013UVES017.18
SwitzerlandSwissScienceOpen20152009PLES016.41
TaiwanKaohsiungOpen20152006TSAI036.50
ThailandBangkok20122009KONV016.15
TunisiaTunisiaSummerOpen20152008VIRO0112.13
TurkeyTurkishAnkaraOpen20142005AKKE019.19
UkraineUkrainianOpen20152013POCH016.63
United Arab EmiratesDubaiOpen20132012DOOF0212.58
United KingdomCambridgeOpen20132011LAUA015.96
UruguayUchiFlorida20152009BARB017.90
USADoylestownSpring20152010BURN015.25
VenezuelaEjidoMallChallenge20152013CONT018.95
VietnamHaNoiCubeDay20142010NGUY336.84

Average:
CountryCompetitionPerson"NR" Average
AndorraIutopiaOpen20142013TORN0210.38
ArgentinaSanLorenzoInvierno20152008JONG0310.09
AustraliaMelbourneCubeDay20132009ZEMD016.54
AustriaAustrianBigCubeOpen20142005AKKE018.79
AzerbaijanBakuOpen20152015ISRA0116.63
BelarusDvinaOpen20152011DOBR018.17
BelgiumN8W8Summer20152007VALK017.59
BoliviaCochabambaOpen20152011CUBA028.95
Bosnia and HerzegovinaBIHOpen20122005BATI019.94
BrazilWC20152009ZEMD016.97
CanadaTorontoOpenFall20142010WANG687.50
ChileHectorSalinasOpen20152008JONG0310.06
ChinaXianCherryBlossom20152009FANH017.85
ColombiaBogotaCubico20152012HERN039.85
CroatiaOsijekOpen20152009BOZS019.47
Czech RepublicCzechOpen20142009BOZS019.48
DenmarkEuro20142010WEYE017.82
Dominican RepublicVeranoCubero20152013SIER0110.10
EstoniaEstonianOpen20152013JOKI019.75
FinlandHelsinkiBlindWeekend20152013JOKI019.32
FranceFrance20152012CARL038.38
GeorgiaGeorgianOpen20132013KAKH0111.07
GermanyFrankfurtCubeDays20152009DIEC017.53
GreeceGreeceOpen20152013VASI039.86
GuatemalaRubikHuehue20142013RAMI0214.23
Hong KongAsianChampionship20122010SICH018.67
HungaryHungarianNationals20152009BOZS019.15
IcelandIcelandOpen20122009MAGN0212.19
IndiaSCMU20152013TALU018.90
IndonesiaJakartaSpeedcubing20132010UTOM018.49
IranParaxCubecomp20152012SARL019.30
IrelandIrishChampionship20152012BEAH018.65
IsraelIsraelChampionship20142010ALFA0310.81
ItalyEretumOpen20142009MORI058.48
JapanRabbitAndTurtle20122006TABU028.25
JordanJordanOpen20122012DOOF0213.62
KoreaGoodCubeShowKorea20152013KYOU017.88
LatviaLatvianOpen20122005VANH0111.22
LithuaniaLithuanianOpen20132012BARA0312.56
MacauMacauOpen20092008CHEN1012.97
MalaysiaJohorOpen20122009XIAN019.88
MexicoSIGI20152014RUIZ049.49
MoldovaMoldavianNationals20152011MELI0110.82
MongoliaMongolianOpen20132012TUGU0112.65
NetherlandsDutchOpen20122007VALK017.66
New ZealandNewZealandNationals20142011LINA018.34
NorwayKjellerOpen20142010ARBO018.68
PeruTCGAndFriendsAQP20152009ZEMD017.33
PhilippinesCubaoOpen20132010APAG018.50
PolandRumiaOpen20142009PLES018.11
PortugalPortugalOpen20142010GARC029.24
RomaniaMioveniRubikOpen20152013FRON0110.03
RussiaCCCEndofSummer20152011DOBR017.91
SerbiaSerbianOpen20132005BATI019.35
SingaporeSingaporeOpen20142010UTOM019.33
SlovakiaBratislavaOpen20142009BOZS019.34
SloveniaLentOpen20152014ZUPA019.04
South AfricaCapeTown20142009ZEMD016.77
SpainCastellonOpen20152011SANC027.56
SwedenSwedishCubeDays20132009CONT019.14
SwitzerlandSwissScienceOpen20152009PLES017.98
TaiwanTaiwanCubingLeague20152010WUIF018.30
ThailandWC20112009ZEMD017.78
TunisiaTunisiaSummerOpen20152008VIRO0113.39
TurkeyTurkishAnkaraOpen20142005AKKE0110.37
UkrainePodolianOpen20142010VYNN018.75
United Arab EmiratesDubaiOpen20132012DOOF0214.53
United KingdomWelcomeBackToGuildford20152011LAUA017.37
UruguayUchiFlorida20152009BARB019.16
USAUSNationals20142009ZEMD017.03
VenezuelaCubingMerida20132011AMOR0111.29
VietnamCSPOpen20152011NGUY108.72
 
whats the fastest average anyone's ever gotten at their second competition after getting a DNF average at their first (I got a 22.45, for example)
oh ok thank you could you make a list of the rankings if possible?

Here's the full list of all 376 people whose first official average was a DNF, ranked by their second official average. People who followed their first DNF with a second one were excluded.
PersonSecond Official Average
12010ARBO0112.83
22013UVES0113.07
32012SHAK0113.64
42011LIMA0513.81
52015WEIG0114.10
62015SHEN0714.43
72010QIUJ0114.71
82013GILM0114.89
92009CORN0115.06
102014YAKU0215.19
112013MAJK0115.20
122013DINI0115.36
132014CHIN0415.40
142010ZHEN1215.57
152009CHEN3915.58
162012WOYD0115.58
172013DANY0215.78
182009POOK0116.01
192012ZHAO0316.21
202013ZHON0216.26
212008GANC0216.39
222012LIMU0116.41
232013CHIA0216.58
242014TAOZ0116.68
252013HUAN1916.71
262013JORD0116.81
272012PASC0116.89
282014SAPU0116.91
292014ZHAN3217.06
302012SATO0317.17
312013PARI0317.28
322011VECC0117.57
332014LIMI0217.69
342010PANG0317.87
352014ZENG0517.98
362013KOPI0118.00
372014NISH0418.08
382010PANJ0118.39
392014MART0218.42
402013DINH0118.50
412010YANG0618.67
422014JOUB0118.79
432011FINK0118.81
442013BONA0118.94
452014PRAD0418.97
462015AREE0119.00
472013ESQU0119.04
482014KATR0119.10
492014FANJ0119.14
502014SHAR1519.18
512014HAWK0119.22
522013KIRI0119.30
532013HYUN0319.32
542013LUNI0219.54
552014LAZA0119.57
562009GAGG0219.69
572013DAHI0119.97
582010TONG0220.04
592014FENG0920.14
602014BINB0120.30
612011THAN0220.36
622008ZHOU0120.49
632011KIJV0120.58
642010SOMM0120.65
652011EUNS0120.69
662015FAVA0120.82
672012ORBE0120.88
682008NEME0120.92
692012POJD0120.97
702013PANK0121.07
712012HALE0121.28
722013ZHAO1321.36
732013BADE0121.43
742012BAGG0121.52
752010ADAM0221.58
762011STAC0221.69
772013SHAH0221.75
782011LIGA0121.83
792012SHAN0221.83
802015LAPE0121.88
812010WANG1622.09
822012LOUS0122.11
832014ZARA0122.11
842014BECK0322.13
852015PERE1122.25
862011CHAI0222.30
872011HANI0122.41
882014SCHU0222.45
892014SAHN0122.49
902015LONG0222.50
912014EDWA0122.67
922010ROSE0222.72
932015FRAN0722.86
942013CHEN4622.88
952007LACZ0123.20
962010KILB0323.21
972011HERR0323.25
982011PERI0123.25
992009LIMA0123.44
1002013NHAN0223.50
1012009LIWE0323.61
1022012ZOUX0123.74
1032014GAOT0123.85
1042012KIMA0123.93
1052012BREN0123.98
1062014KHOA0224.06
1072009KOBA0224.11
1082014GAUR0124.24
1092015HUAN0324.37
1102009XUQI0124.40
1112015VARG0224.46
1122009LIPP0124.54
1132014QIUR0124.57
1142013JOKS0124.67
1152012ACEV0124.73
1162013MART1424.79
1172010HAOD0124.80
1182015STAP0124.80
1192015PERA0125.04
1202013MALY0125.09
1212013CAOJ0225.23
1222009RAMA0325.26
1232012JONS0125.34
1242011HAYA0225.37
1252013CHAU0225.42
1262011WANG5625.46
1272011HASA0125.53
1282005GILS0125.59
1292008STAN0125.62
1302013WALL0225.74
1312013LIUC0225.77
1322012DILU0125.89
1332015COCH0125.90
1342013PIEC0125.98
1352015MARC0126.19
1362011GUIL0226.24
1372014VILI0126.33
1382013SHIU0126.34
1392012LIAO0126.36
1402009HENF0126.42
1412012WERN0126.43
1422011FRIB0126.45
1432014CHAK0226.60
1442012RODR0726.62
1452014WERE0126.64
1462009ZHAN2026.66
1472010OLBE0126.83
1482015THAK0227.30
1492013LUTS0127.38
1502015HIUM0127.43
1512012ORTA0127.57
1522010LUXI0227.82
1532014PKAA0127.85
1542008CHRI0127.93
1552011IVKO0128.00
1562015WYMB0128.11
1572011OMID0128.39
1582015WESO0128.39
1592015TZYB0128.40
1602011LASZ0128.52
1612014HOLU0128.56
1622015TABO0128.56
1632012REQU0128.76
1642013WANG0528.80
1652012CHAV0429.32
1662013MONT0329.55
1672012KOSY0129.59
1682013STAM0129.60
1692014ZHAO1629.61
1702013CHEN8329.62
1712014MARR0529.65
1722014BAUD0129.68
1732015ZMYS0129.87
1742012PERE0430.30
1752014PATI0630.78
1762011YUYA0230.92
1772014HUAN1030.95
1782009CHAN0430.97
1792013LIUQ0130.99
1802014VURE0130.99
1812014MCNA0231.03
1822013RANG0231.14
1832014KIMJ0131.27
1842012SMIT0131.31
1852012FANG0431.32
1862014PANG0231.38
1872008PAND0131.72
1882015PRAJ0131.73
1892014SHAN0331.85
1902014LIPI0131.95
1912014CAST1531.99
1922011TRUJ0132.02
1932013MEDV0132.05
1942011KUBU0132.21
1952010SAND0232.23
1962009BOUR0132.49
1972009YANZ0132.51
1982010LOCS0132.59
1992009MARB0132.63
2002008WANG0132.69
2012015ZHAN0432.71
2022012MUNO0332.91
2032014MAJE0232.91
2042013PRAN0433.09
2052009FAZE0133.15
2062012ZHOU1233.18
2072010FUYA0133.39
2082011NURA0133.71
2092009KONG0133.92
2102008HUAN0534.01
2112009DAVE0134.25
2122010HELM0134.30
2132014CARA0334.34
2142011GIOR0134.41
2152014GAWO0134.72
2162012MUSO0134.96
2172015BAKE0235.03
2182015HAYE0335.19
2192009XION0335.34
2202009STUM0235.35
2212014RILE0135.64
2222005IDEK0135.82
2232009MCCA0235.91
2242010DRAC0136.33
2252012BREN0236.33
2262009ZHAN3336.43
2272015BANE0336.83
2282011YANG0837.80
2292012FINO0138.02
2302015ZWAH0138.05
2312014AHME0338.18
2322014MONE0338.18
2332014LAND0238.27
2342014MARQ0138.51
2352014BERR0238.54
2362013HOLM0238.82
2372015SUMM0139.06
2382011FARH0139.10
2392015RENA0139.12
2402010CARM0239.23
2412011HUYN0139.25
2422011RAMD0139.28
2432014AGRE0139.29
2442010FRAN0539.92
2452011WINT0140.73
2462014YANG3141.59
2472015WIDD0241.94
2482014HOLO0142.26
2492013KOMO0142.44
2502012ZAKR0342.48
2512010RUTH0143.12
2522009BENN0143.23
2532014SZAB0543.24
2542014CHER0343.31
2552013LIUA0143.56
2562014CICH0143.75
2572011IBAR0143.91
2582013LUND0144.30
2592009BERM0144.47
2602014CHAN1844.80
2612013COOP0144.87
2622011ANDU0144.89
2632005IDEK0245.17
2642013TYBU0145.62
2652014MALD0245.83
2662014RUMA0145.97
2672014YANG1846.02
2682011COEU0146.33
2692014MOSQ0146.39
2702014BEAM0146.80
2712014ARCI0147.10
2722009KANG0347.14
2732014NIEL0147.17
2742009NAUM0147.74
2752011DELI0147.86
2762012DESM0147.96
2772013NAIR0148.01
2782013CHEN3648.54
2792008DAMM0148.63
2802012BUTS0148.94
2812012GAIT0149.09
2822014SHAR0149.22
2832010FOSS0149.51
2842014PODO0249.70
2852011WHIT0350.08
2862013SAGW0150.09
2872012ICKE0150.58
2882009BENO0150.97
2892011SANH0151.18
2902007GRAN0251.36
2912013WANG5951.49
2922014YESA0151.55
2932015STRI0152.24
2942008LOTU0152.40
2952007SCHU0152.43
2962014KUDR0152.84
2972009BAIP0153.07
2982014DELG0153.37
2992011AEIR0153.43
3002012SHAR0154.08
3012013FENG0454.20
3022006IDEK0154.24
3032010BOCK0154.87
3042014DUQU0157.58
3052011MEND0258.60
3062014CHAC0258.89
3072012PARW0259.50
3082010HORW0159.97
3092014GHAL0160.35
3102011SELA0160.70
3112015SHAH0161.10
3122011DWYE0161.53
3132010DEDH0162.01
3142012DECK0162.01
3152013VIDA0462.06
3162009CHOK0262.86
3172014ROEG0263.34
3182010JENS0163.60
3192008KANG0363.76
3202013ZHAN6564.27
3212013GIND0165.57
3222006MATH0165.69
3232010YOUN0166.00
3242006TOMI0166.83
3252015LOPE1767.01
3262011LEIY0167.31
3272015RAYN0167.31
3282014SOLO0267.62
3292009SHAN0568.59
3302010BODD0169.53
3312014ARAU0370.22
3322011ANGE0170.81
3332014CONT0671.59
3342014GALL0771.70
3352011KUSE0171.92
3362006MIZO0174.63
3372010HEME0174.69
3382010KARE0174.72
3392014PAGE0175.90
3402009ARMA0176.48
3412009OKED0176.78
3422009BALA0278.09
3432013MONT0179.82
3442013WADY0180.35
3452011MILA0180.46
3462014SILV0383.29
3472014PENN0185.23
3482013ZOLT0186.29
3492014WICA0187.88
3502013SILV2893.20
3512015BHUT0297.08
3522012ALBA0297.49
3532014PREN0197.91
3542008HUAN10100.56
3552010STRI03101.83
3562009ARSI01102.08
3572012ASTR01106.82
3582011MASL01107.42
3592011HAAV01110.92
3602015CIPR01112.46
3612014VISS02114.84
3622014SOUS01117.86
3632012ARMS03119.53
3642009BURN01119.80
3652014KEJH01120.41
3662012NOOR01126.60
3672010DHAL01138.49
3682009LOGA01148.41
3692014TOLE02149.76
3702014GUIL01153.19
3712010SABN01159.65
3722013LINY03164.63
3732011VELA03185.60
3742010HOUL01246.41
3752013BORR02298.47
3762010DICK03326.49
 
Average of top 5 singles (results) in 2-5: (can someone do this for all events?)
2x2:
(0.58) 0.69 0.72 0.74 (0.75) = 0.62
3x3:
(5.25) 5.39 5.55 5.58 (5.60) = 5.51
4x4:
(21.97) 22.78 23.25 23.72 (23.88) = 23.25
5x5:
(48.42) 48.54 48.57 49.28 (49.36) = 48.80
 
Average of top 5 singles (results) in 2-5: (can someone do this for all events?)
2x2:
(0.58) 0.69 0.72 0.74 (0.75) = 0.62
3x3:
(5.25) 5.39 5.55 5.58 (5.60) = 5.51
4x4:
(21.97) 22.78 23.25 23.72 (23.88) = 23.25
5x5:
(48.42) 48.54 48.57 49.28 (49.36) = 48.80

6x6: (1:33.55), 1:39.4, 1:45.45, 1:47.53, (1:51.76) = 1:44.13

7x7: (2:23.55), 2:30.35, 2:33.08, 2:33.9, (2:34.64) = 2:32.44

OH: (6.88), 8.27, 8.48, 8.75, (8.82)=8.5

Pyraminx: (1.36), 1.61, 1.68, 1.69, (1.8) = 1.66

Clock: (3.73), 4.8, 5.19, 5.2, (5.27) = 5.06

Skewb: (1.68), 1.69, 1.81, 1.84, (1.92) = 1.78

Square-1: (6.96), 7.41, 8.63, 9.15, (9.16) = 8.39

Megaminx: (37.58), 39.57, 42.28, 43.13, (43.18) = 41.66

Feet: (20.57), 25.14, 27.66, 27.93, (28.07) = 26.91

3BLD: (21.17), 21.83, 22.98, 23.8, (24.86) = 22.87

4BLD: (2:02.75), 2:17.07, 2:28.57, 2:30,62, (2:41.30) = 2:25.42

5BLD: (5:18.65), 5:35.84, 5:39.1, 6:06.41, (6:24.11) = 5:47.11

MBLD: (41), 26, 24, 24, (23) = 24.66

FMC: (20), 20, 21, 21, (22) = 20.66
 
6x6: (1:33.55), 1:39.4, 1:40.25, 1:40.86, (1:41.58) = 1:40.17

7x7: (2:23.55), 2:30.35, 2:33.08, 2:33.4, (2:33.52) = 2:32.27

OH: (6.88), 8.27, 8.48, 8.75, (8.82)=8.5

Pyraminx: (1.36), 1.61, 1.68, 1.69, (1.71) = 1.66

Clock: (3.73), 4.8, 5.19, 5.2, (5.25) = 5.06

Skewb: (1.68), 1.69, 1.81, 1.84, (1.92) = 1.78

Square-1: (6.96), 7.41, 8.63, 8.65, (9.01) = 8.23

Megaminx: (37.58), 37.83, 38.83, 39.57, (40.16) = 38.74

Feet: (20.57), 25.04, 25.14, 25.36, (25.9) = 25.18

3BLD: (21.17), 21.24, 21.83, 22.98, (23.1) = 22.01

4BLD: (2:02.75), 2:10.47, 2:17.07, 2:18.31, (2:18.65) = 2:15.28

5BLD: (5:18.65), 5:35.84, 5:39.1, 5:39.96, (5:51.53) = 5:38.3

MBLD: (41), 36, 35, 32, (32) = 34.33

FMC: (20), 20, 21, 21, (21) = 20.66
 
Average standard deviation of PB averages? (3x3)

Average of all PB average standard deviations: 4.036657631749797
Highest PB standard deviation: 371.18632710989414 on an average of 320.92 by 2014PATW02.
Lowest PB standard deviation: 0.00577350269189716 on an average of 20.09 by 2003BARR01.

Ruby code:
Code:
def mean(arr)
  sum = arr.inject(0) { |accum, i| accum + i}
  return sum / arr.size().to_f()
end

def sd(arr)
  mean = mean(arr)
  var = 0.0
  arr.each do |n|
    var += ((n - mean) * (n - mean)).to_f()
  end
  var /= (arr.size() - 1)
  return Math.sqrt(var)
end

pb_avgs = {}

File.open("WCA_export_Results.tsv") do |f|
  f.each_line do |l|
    data = l.split("\t")
    a = data[5].to_i()
    if data[1] == "333" && a > 0
      round = [
        data[10].to_f() / 100.0,
        data[11].to_f() / 100.0,
        data[12].to_f() / 100.0,
        data[13].to_f() / 100.0,
        data[14].to_f() / 100.0
      ]
      
      round.each_index do |s|
        if round[s] == -0.01 || round[s] == -0.02
          round[s] = 100000.0
        end
      end
      
      round.delete_at(round.index(round.max()))
      round.delete_at(round.index(round.min()))
      
      m = mean(round)
      s = sd(round)
      
      if !pb_avgs.has_key?(data[7]) || pb_avgs[data[7]][0] > m
        pb_avgs[data[7]] = [m, s]
      end
    end
  end
end

max = pb_avgs.keys[0]
min = pb_avgs.keys[0]
total_sd = 0.0
count = 0
pb_avgs.each do |k, v|
  if v[1].nan?()
    puts k
  end

  total_sd += v[1]
  count += 1
  
  if v[1] < pb_avgs[min][1]
    min = k
  end
  if v[1] > pb_avgs[max][1]
    max = k
  end
end

puts "Average of all PB average standard deviations: #{total_sd / count}"
puts "Highest PB standard deviation: #{pb_avgs[max][1]} on an average of #{sprintf("%.2f", pb_avgs[max][0])} by [url=\"https://www.worldcubeassociation.org/results/p.php?i=#{max}\"]#{max}[/url]."
puts "Lowest PB standard deviation: #{pb_avgs[min][1]} on an average of #{sprintf("%.2f", pb_avgs[min][0])} by [url=\"https://www.worldcubeassociation.org/results/p.php?i=#{min}\"]#{min}[/url]."
 
Could I get a ranked list for the number of people who have competed in each WCA event?

Not for all events, but the top 10 is under "Most Persons" here: https://www.worldcubeassociation.org/results/statistics.php

I was curious about the bottom of the list so I tried to find the full list myself. My numbers don't quite match the ones on the WCA page but they're pretty close. Not sure what the problem is but the ranking should at least be correct.

  1. 3x3: 43187
  2. 2x2: 24007
  3. 4x4: 13930
  4. OH: 12778
  5. Pyra: 12732
  6. 5x5: 7581
  7. Magic: 4938
  8. Skewb: 4652
  9. Minx: 4546
  10. 3BLD: 4530
  11. FMC: 3485
  12. Sq1: 2704
  13. 6x6: 2662
  14. 7x7: 2460
  15. Clock: 2434
  16. Master Magic: 2081
  17. MBLD: 1882 (1695 new format, 187 old format)
  18. Feet: 1323
  19. 4BLD: 648
  20. 5BLD: 337

Ruby code:
Code:
events = {}
count = 0

File.open("WCA_export_Results.tsv") do |f|
  ignore_first_line = true
  f.each_line do |l|
    if ignore_first_line
      ignore_first_line = false
      next
    end
    
    data = l.split("\t")
    event = data[1]
    person = data[7]
    
    if !events.has_key?(event)
      events[event] = []
    end
    
    if !events[event].include?(person)
      events[event] << person
    end
    
    count += 1
    if count % 10000 == 0
      puts "#{count} records processed."
    end
  end
end

events.each do |k, v|
  puts "#{k}: #{v.size()} participants."
end
 
Back
Top