Odd WCA stats/ Stats request Thread

Kit Clement · Sep 25, 2015

illius said:
Most events in a one-day competition? Has there ever been an FMC mean in one day?

Too lazy to check, but this one-day competition had 15 events: https://www.worldcubeassociation.org/results/c.php?i=Indiana2012
Also, besides the obvious FMC-dedicated competitions (Fantastic/Fabulous/Fantabulous competitions in USA, FMC USA/Europe), this competition was one day and had a mean: https://www.worldcubeassociation.org/results/c.php?i=DixonSpring2014

JustinTimeCuber said:
between rounds or between competitions?
what event?
averages or singles?

There's no need to be pedantic, this stat has been requested several times. It's a PB streak between competitions -- getting at least 1 PB in a competition keeps the streak alive.

JustinTimeCuber · Sep 25, 2015

Kit Clement said:
Too lazy to check, but this one-day competition had 15 events: https://www.worldcubeassociation.org/results/c.php?i=Indiana2012
Also, besides the obvious FMC-dedicated competitions (Fantastic/Fabulous/Fantabulous competitions in USA, FMC USA/Europe), this competition was one day and had a mean: https://www.worldcubeassociation.org/results/c.php?i=DixonSpring2014

There's no need to be pedantic, this stat has been requested several times. It's a PB streak between competitions -- getting at least 1 PB in a competition keeps the streak alive.

oh well then I have that just in 3x3 lol
*but I've only been to four

Isaac Lai · Sep 28, 2015

I've seen this somewhere before, but I think I didn't search for the correct term, so I can't find it. Could someone do a fastest first official single and average for each event?

Hssandwich · Sep 28, 2015

Slowest 3x3 single compared to average?

Ninja Storm · Sep 28, 2015

Hssandwich said:
Slowest 3x3 single compared to average?

It's not 3x3, but this person is like it for Megaminx.

Wilhelm · Sep 28, 2015

I think he is high up on the list https://www.worldcubeassociation.org/results/p.php?i=2012WROD01

Ronxu · Sep 28, 2015

Ninja Storm said:
It's not 3x3, but this person is like it for Megaminx.

Dank 7x7 stuff.

JustinTimeCuber · Sep 28, 2015

what about fastest 3x3 single compared to average? I have an 11.90 single and a 15.03 average but I think Kit has a sub 10 single and a low 14 average.

Sergeant Baboon · Sep 28, 2015

JustinTimeCuber said:
what about fastest 3x3 single compared to average? I have an 11.90 single and a 15.03 average but I think Kit has a sub 10 single and a low 14 average.

There's Pavan Ravindra's 5.58 single and 10.60 average.

edit: Went through the database and found the biggest difference between an average and best single in that average. Daniel Sheppard got an average of 1:52.86 with a 16.46 single. Full average was 18.43, 20.22, (16.46), (DNF), 4:59.94.

I thought that one would be exceptional and the rest would be lucky singles, but it seems like most of these are the same way--a mostly good average and then a DNF paired with a complete collapse on one solve that skews the whole average. Even after I filtered to only see sub-30 averages, it's mostly stuff like someone who's comfortably sub-20 or sub-15 getting a DNF then a 40.xx or something.

The biggest difference that I found that seems to be a lucky single is Slowest 3x3 single compared to average?[/QUOTE]

Scrolled up and realized I could answer this too! [url="https://www.worldcubeassociation.org/results/p.php?i=2010MICH03"]Michael recently got a (25.06), (25.03), 25.03, 25.05, 25.03.

Sorry for the double post. I tried to edit it into the end of my other post and it got weird and deleted a bunch of the middle of the post when I submitted.

Lid · Sep 28, 2015

Sergeant Baboon said:
Scrolled up and realized I could answer this too! Michael recently got a (25.06), (25.03), 25.03, 25.05, 25.03.

Sorry for the double post. I tried to edit it into the end of my other post and it got weird and deleted a bunch of the middle of the post when I submitted.

Sure he did, but I would not count it.

Sergeant Baboon · Sep 28, 2015

Lid said:
Sure he did, but I would not count it.

Why not? Did he do it intentionally?

edit: in retrospect, it does look like he cheesed it. If that is indeed what you meant, then I found Yang Liu 3, who got (20.68), 20.71, 20.71, (21.34), 20.68, which also seems cheesed to me. The next-closest is Muhammad Iril Khairul Anam, whose (29.71), 29.56, (29.46), 29.50, 29.50, also seems to be intentional. I'm looking through a lot of these and it's hard for me to tell if they got their numbers this close or are just really consistent. Here are the top twenty ranked by (average - best)/average:

WCA ID	Average - Best	Average	Ratio
2010MICH03	0.01	25.04	0.000399361022364217
2011YANG17	0.02	20.70	0.000966183574879227
2009ANAM01	0.06	29.52	0.00203252032520325
2010MAUL03	0.05	19.99	0.00250125062531266
2012ORTU01	0.04	15.65	0.00255591054313099
2009ANAM01	0.09	30.22	0.00297816015883521
2012LIUY03	0.04	13.38	0.00298953662182362
2008MIZU01	0.04	13.20	0.00303030303030303
2012SALA05	0.04	13.15	0.00304182509505703
2011DIRK01	0.05	15.05	0.00332225913621262
2007LUCH02	0.05	14.71	0.00339904826648538
2008MEIS01	0.23	65.64	0.00350396099939062
2010HANS01	0.11	30.19	0.00364359059291156
2011RODR11	0.06	15.64	0.00383631713554987
2009TANG05	0.08	19.86	0.0040281973816717
2008PAWL01	0.08	19.36	0.00413223140495868
2004GALL02	0.07	16.28	0.0042997542997543
2009GENN01	0.13	28.79	0.00451545675581799
2013TOMA01	0.06	12.33	0.0048661800486618
2015VALD07	0.28	56.56	0.00495049504950495

JustinTimeCuber · Sep 28, 2015

top 100 singles achieved during sup 15 averages?
sup 20?
sup 10?

Sergeant Baboon · Sep 29, 2015

JustinTimeCuber said:
top 100 singles achieved during sup 15 averages?
sup 20?
sup 10?

>20s:

WCA ID	Solve	Average
2013SEOH01	8.21	21.93
2012LIIH01	8.68	20.09
2013SEOH01	9.14	21.93
2009PICH01	9.21	20.25
2009ROTA01	9.56	22.45
2012SLIZ01	9.92	21.90
2009PICH01	9.93	20.25
2013GUMP01	10.00	24.85
2007ESPI01	10.06	28.10
2012LIFL01	10.27	20.85
2006DZOA03	10.38	25.48
2013TORR02	10.43	22.27
2013SEOH01	10.43	21.93
2013KAPL01	10.59	20.43
2007COOP01	10.61	22.11
2013MIRA02	10.65	27.84
2007WEIN01	10.65	20.28
2012LIIH01	10.67	20.09
2010PATZ01	10.69	29.60
2010BADR01	10.72	22.06
2009PICH01	10.86	20.25
2015ARYA02	10.87	25.52
2012HWAN01	10.89	25.69
2012HWAN01	10.90	25.69
2013FERR03	10.94	21.78
2014CHIE01	11.01	21.94
2011ATAS01	11.18	23.34
2011ZAKA01	11.18	23.61
2010NOUV01	11.27	20.78
2007ESPI01	11.33	28.10
2007CHAN06	11.39	22.60
2012PARA03	11.40	23.07
2006DZOA03	11.43	25.48
2008LIUE01	11.44	21.35
2009CUST01	11.50	20.17
2010BADR01	11.58	22.06
2008DANG01	11.59	22.95
2012SOKO01	11.59	45.65
2014YUJA01	11.61	23.94
2012SOKO01	11.63	45.65
2009KOCH02	11.66	21.76
2015KENN01	11.67	24.18
2010BOON01	11.68	21.57
2010TANA02	11.75	20.47
2011BENZ01	11.75	22.43
2007SUGA01	11.80	26.45
2011BEAT01	11.82	20.08
2014PENA07	11.83	20.32
2010LIUD02	11.83	24.01
2008LINM03	11.84	20.91
2008TRAN02	11.85	20.01
2012BOGD01	11.86	33.27
2013ZORL01	11.91	20.77
2009JOHN05	11.96	22.77
2011BRUS01	11.96	20.60
2009GUIL01	11.96	21.01
2014MCGA01	11.97	26.28
2010CHEN27	11.98	23.20
2010PATZ01	12.00	29.60
2010BINL01	12.00	24.02
2013KOIL01	12.01	20.57
2010YUPH01	12.02	20.57
2010CARA01	12.08	20.02
2008YOUN02	12.11	26.59
2010YUPH01	12.14	20.90
2011DILA01	12.18	20.50
2011ATAS01	12.18	23.34
2007SUGA01	12.27	26.45
2013VOLO01	12.27	21.94
2011RETZ01	12.28	20.08
2010GIEN01	12.30	20.45
2009HUJI01	12.31	21.07
2013CONT01	12.31	21.01
2011SALG01	12.34	30.84
2013MOTT01	12.34	20.93
2014GONZ18	12.37	20.02
2007CERP02	12.38	61.39
2011SVEN02	12.39	25.64
2013VARG02	12.40	21.87
2009INGE01	12.41	20.72
2011SVEN02	12.43	25.64
2011JESU01	12.45	22.96
2007CHAN06	12.45	22.60
2015KIMG01	12.46	20.18
2010RUGA01	12.46	21.27
2013MIRA02	12.50	27.84
2014CHAY01	12.50	20.07
2014JAUR01	12.51	20.47
2009CHEN35	12.52	22.34
2014SZNE01	12.52	22.03
2011ESQU01	12.53	20.32
2014NURU01	12.53	20.82
2010YUPH01	12.55	21.05
2008LIUE01	12.58	25.69
2013BOGA01	12.58	20.50
2012CHEN25	12.60	21.39
2014SARK01	12.61	20.09
2013LING03	12.61	20.12
2007CERP02	12.63	20.80
2012HOFL01	12.63	20.07

>15s:

WCA ID	Solve	Average
2013SCHM02	7.79	18.57
2011MERL01	7.96	17.01
2013SEOH01	8.21	21.93
2009KORB02	8.43	15.32
2006SHEU01	8.55	17.11
2011SANJ01	8.56	15.31
2009HILD01	8.63	16.53
2007CLAE03	8.63	17.30
2012LIIH01	8.68	20.09
2013MACI01	8.78	17.25
2011NATH02	8.80	16.26
2011RECH01	8.90	15.25
2007SHIR01	8.91	15.79
2008JADE01	8.93	15.18
2014YANG11	8.96	15.88
2010STOL01	9.02	19.88
2011ALFA02	9.09	15.83
2007HESS01	9.13	16.31
2013SEOH01	9.14	21.93
2008LINH01	9.21	15.25
2009PICH01	9.21	20.25
2008LINH01	9.22	19.55
2005AKKE01	9.22	16.00
2008BRAN01	9.28	15.62
2010DUON01	9.31	16.99
2009NATE01	9.34	16.07
2013ANDR04	9.35	15.13
2012PERK01	9.35	15.09
2013KHUU01	9.36	15.52
2014WANG26	9.37	17.36
2013KASH01	9.40	19.54
2007THOM02	9.40	16.64
2007VALK01	9.41	15.61
2009OHRN01	9.42	17.66
2007LING01	9.43	15.05
2008CLEM01	9.43	17.39
2009KIEL01	9.44	17.86
2009GUGL01	9.44	15.68
2013CHEU01	9.45	15.87
2012MAAL01	9.46	15.39
2010ANDE03	9.46	16.01
2011SALG01	9.53	19.39
2007PERG01	9.53	16.01
2010GOLD01	9.54	15.58
2012KIMD01	9.55	16.14
2003BRUC01	9.55	16.24
2008JINX01	9.55	15.61
2008LOMB01	9.56	15.53
2009ROTA01	9.56	22.45
2003POCH01	9.56	17.21
2007PERG01	9.58	15.79
2010KOUG01	9.59	15.43
2014CYBU02	9.64	16.76
2011FOYL01	9.65	16.16
2015MARC03	9.66	15.04
2003BRUC01	9.68	15.51
2011HAVL01	9.69	15.71
2013VIDA01	9.71	15.89
2009CHEN35	9.71	15.10
2012CROS01	9.72	16.99
2013OLIV01	9.72	15.08
2008DIEW01	9.72	15.06
2005AKKE01	9.75	16.00
2008MORA02	9.75	15.61
2009JAGI01	9.77	16.85
2012MORA06	9.78	16.24
2013CHIX01	9.78	17.63
2008LINH01	9.78	15.25
2009VERA01	9.78	15.10
2008BERE01	9.80	15.32
2007LUJI01	9.80	15.22
2006GARR01	9.81	15.19
2006ANDO01	9.83	15.34
2008LIZH02	9.84	16.84
2013HANN01	9.86	17.44
2012HUAN12	9.87	18.65
2009HAYA01	9.88	15.91
2007GOUL01	9.88	15.59
2003BRUC01	9.88	15.82
2007LIME01	9.88	15.10
2006TABU01	9.90	15.86
2009LAIY01	9.92	16.80
2012SLIZ01	9.92	21.90
2003BRUC01	9.93	15.43
2012DOED01	9.93	15.10
2009PICH01	9.93	20.25
2013LINK01	9.94	16.01
2011EBEL01	9.94	17.23
2012CHIN01	9.94	16.33
2011BRZE01	9.96	16.65
2011WANG52	9.97	15.92
2011BANS02	9.98	16.64
2012IVAN02	9.98	15.02
2012KONG01	9.98	17.23
2006AUST01	9.99	15.18
2008LINH01	9.99	15.25
2010MARI02	10.00	15.35
2011SZAT01	10.00	17.28
2013GUMP01	10.00	24.85
2010BECK01	10.02	15.05

>10s:

WCA ID	Solve	Average
2013RAVI06	5.58	10.60
2010WANG53	5.81	10.49
2010BURN01	5.93	10.53
2013NAHM01	6.15	10.07
2010THOM03	6.21	11.14
2010LANE02	6.25	11.39
2010PROT01	6.27	10.33
2012MAHV01	6.32	10.07
2011HAMS01	6.50	12.09
2009CHAR03	6.50	10.69
2006TSAI03	6.50	11.28
2008HASH02	6.56	11.51
2007VALK01	6.61	10.25
2010KIPA01	6.61	10.34
2010YOUY01	6.61	11.16
2011KNOT01	6.64	13.19
2011BARB03	6.64	10.92
2010PROT01	6.65	12.27
2007VALL01	6.65	10.36
2009MORI05	6.77	10.04
2010MALL01	6.80	10.50
2013WOJT02	6.81	11.24
2012ROQU01	6.82	10.18
2009FUSH01	6.84	10.21
2009BOZS01	6.84	10.12
2010ADHI01	6.84	11.38
2012SZEW01	6.87	13.45
2008CHUC02	6.89	12.06
2011GROG02	6.89	10.15
2011HOFF02	6.90	10.78
2009YAUR01	6.91	10.40
2012RUPE01	6.91	10.37
2013ZHOU19	6.92	11.67
2005BATI01	6.93	10.49
2008SEAR01	6.93	12.22
2007HESS01	6.94	10.52
2012PONC02	7.00	10.60
2014KARN02	7.00	11.49
2007NAKA03	7.00	10.27
2010WEYE02	7.00	10.96
2011LIYI02	7.02	11.31
2007HESS01	7.02	12.04
2010WEYE02	7.02	10.25
2006GUNJ01	7.03	10.38
2013HUAN30	7.04	13.18
2015CHEA01	7.05	11.00
2007HESS01	7.06	11.26
2009YAUR01	7.06	10.12
2007VALL01	7.08	10.43
2005AKKE01	7.08	12.26
2013BAUT01	7.09	14.06
2010WEYE02	7.11	10.20
2012KALE01	7.11	10.93
2008SEAR01	7.13	10.66
2011ZALE02	7.13	11.02
2014GERB01	7.13	10.11
2011ZENG06	7.14	11.36
2010CANT02	7.16	10.15
2007NAKA03	7.16	10.63
2009LIUE01	7.16	11.81
2013BALI01	7.17	11.14
2009JIAY01	7.18	10.44
2013UVES01	7.18	11.61
2012PONC02	7.18	10.68
2009ZHAN53	7.18	10.90
2010KIPA01	7.19	10.35
2012KALE01	7.19	10.46
2012LEWI01	7.19	11.04
2010WANG53	7.20	10.10
2012ROZA01	7.21	12.19
2012WESC01	7.21	10.77
2009BARB01	7.21	10.06
2009KORB01	7.25	11.41
2012IVAN03	7.25	11.97
2008LINE02	7.25	10.89
2009DIEC01	7.25	10.08
2009BARB01	7.25	10.37
2005AKKE01	7.25	10.98
2007WOOR01	7.27	10.81
2009BARB01	7.28	10.35
2013LEJE03	7.28	10.35
2009WHIT01	7.28	10.46
2007COHE01	7.28	13.67
2010SCHM01	7.28	10.24
2011RHEI01	7.28	10.14
2013JOKI01	7.28	10.02
2012KALE01	7.29	12.06
2012DYGI01	7.29	10.59
2012CHOS01	7.30	10.01
2012CHOS01	7.30	10.74
2014HOUS01	7.30	11.90
2010LEED02	7.30	10.41
2007GUIM01	7.30	11.29
2011FATE01	7.30	11.20
2011ALVI01	7.30	12.05
2009KORB01	7.31	11.69
2011TORG01	7.31	11.21
2010PROT01	7.31	10.16
2013PARK03	7.31	10.47
2008SEAR01	7.31	10.42

R code:

Code:

raw_data = read.csv(file = "WCA_export_Results.tsv", head = TRUE, sep = "\t")
valid_333 = data.frame(raw_data$personId, raw_data$eventId, 
  raw_data$value1, raw_data$value2, raw_data$value3, raw_data$value4, raw_data$value5, raw_data$average)
names(valid_333) = c("person", "event", "s1", "s2", "s3", "s4", "s5", "average")
valid_333 = subset(valid_333, event == "333" & average > 0)

s1s = data.frame(valid_333$person, valid_333$s1, valid_333$average)
s2s = data.frame(valid_333$person, valid_333$s2, valid_333$average)
s3s = data.frame(valid_333$person, valid_333$s3, valid_333$average)
s4s = data.frame(valid_333$person, valid_333$s4, valid_333$average)
s5s = data.frame(valid_333$person, valid_333$s5, valid_333$average)
n = c("person", "solve", "average")
names(s1s) = n
names(s2s) = n
names(s3s) = n
names(s4s) = n
names(s5s) = n
all_valid_333_solves = rbind(s1s, s2s, s3s, s4s, s5s)
all_valid_333_solves = subset(all_valid_333_solves, solve > 0)

sup20s = subset(all_valid_333_solves, average > 2000)
sup20s = sup20s[order(sup20s$solve),][1:100,]

sup15s = subset(all_valid_333_solves, average > 1500)
sup15s = sup15s[order(sup15s$solve),][1:100,]

sup10s = subset(all_valid_333_solves, average > 1000)
sup10s = sup10s[order(sup10s$solve),][1:100,]

YouCubing · Sep 29, 2015

Sergeant Baboon said:
>20s:

WCA ID Solve Average
2013SEOH01 8.21 21.93
2012LIIH01 8.68 20.09
2013SEOH01 9.14 21.93
2009PICH01 9.21 20.25
2009ROTA01 9.56 22.45
2012SLIZ01 9.92 21.90
2009PICH01 9.93 20.25
2013GUMP01 10.00 24.85
2007ESPI01 10.06 28.10
2012LIFL01 10.27 20.85
2006DZOA03 10.38 25.48
2013TORR02 10.43 22.27
2013SEOH01 10.43 21.93
2013KAPL01 10.59 20.43
2007COOP01 10.61 22.11
2013MIRA02 10.65 27.84
2007WEIN01 10.65 20.28
2012LIIH01 10.67 20.09
2010PATZ01 10.69 29.60
2010BADR01 10.72 22.06
2009PICH01 10.86 20.25
2015ARYA02 10.87 25.52
2012HWAN01 10.89 25.69
2012HWAN01 10.90 25.69
2013FERR03 10.94 21.78
2014CHIE01 11.01 21.94
2011ATAS01 11.18 23.34
2011ZAKA01 11.18 23.61
2010NOUV01 11.27 20.78
2007ESPI01 11.33 28.10
2007CHAN06 11.39 22.60
2012PARA03 11.40 23.07
2006DZOA03 11.43 25.48
2008LIUE01 11.44 21.35
2009CUST01 11.50 20.17
2010BADR01 11.58 22.06
2008DANG01 11.59 22.95
2012SOKO01 11.59 45.65
2014YUJA01 11.61 23.94
2012SOKO01 11.63 45.65
2009KOCH02 11.66 21.76
2015KENN01 11.67 24.18
2010BOON01 11.68 21.57
2010TANA02 11.75 20.47
2011BENZ01 11.75 22.43
2007SUGA01 11.80 26.45
2011BEAT01 11.82 20.08
2014PENA07 11.83 20.32
2010LIUD02 11.83 24.01
2008LINM03 11.84 20.91
2008TRAN02 11.85 20.01
2012BOGD01 11.86 33.27
2013ZORL01 11.91 20.77
2009JOHN05 11.96 22.77
2011BRUS01 11.96 20.60
2009GUIL01 11.96 21.01
2014MCGA01 11.97 26.28
2010CHEN27 11.98 23.20
2010PATZ01 12.00 29.60
2010BINL01 12.00 24.02
2013KOIL01 12.01 20.57
2010YUPH01 12.02 20.57
2010CARA01 12.08 20.02
2008YOUN02 12.11 26.59
2010YUPH01 12.14 20.90
2011DILA01 12.18 20.50
2011ATAS01 12.18 23.34
2007SUGA01 12.27 26.45
2013VOLO01 12.27 21.94
2011RETZ01 12.28 20.08
2010GIEN01 12.30 20.45
2009HUJI01 12.31 21.07
2013CONT01 12.31 21.01
2011SALG01 12.34 30.84
2013MOTT01 12.34 20.93
2014GONZ18 12.37 20.02
2007CERP02 12.38 61.39
2011SVEN02 12.39 25.64
2013VARG02 12.40 21.87
2009INGE01 12.41 20.72
2011SVEN02 12.43 25.64
2011JESU01 12.45 22.96
2007CHAN06 12.45 22.60
2015KIMG01 12.46 20.18
2010RUGA01 12.46 21.27
2013MIRA02 12.50 27.84
2014CHAY01 12.50 20.07
2014JAUR01 12.51 20.47
2009CHEN35 12.52 22.34
2014SZNE01 12.52 22.03
2011ESQU01 12.53 20.32
2014NURU01 12.53 20.82
2010YUPH01 12.55 21.05
2008LIUE01 12.58 25.69
2013BOGA01 12.58 20.50
2012CHEN25 12.60 21.39
2014SARK01 12.61 20.09
2013LING03 12.61 20.12
2007CERP02 12.63 20.80
2012HOFL01 12.63 20.07

>15s:

WCA ID Solve Average
2013SCHM02 7.79 18.57
2011MERL01 7.96 17.01
2013SEOH01 8.21 21.93
2009KORB02 8.43 15.32
2006SHEU01 8.55 17.11
2011SANJ01 8.56 15.31
2009HILD01 8.63 16.53
2007CLAE03 8.63 17.30
2012LIIH01 8.68 20.09
2013MACI01 8.78 17.25
2011NATH02 8.80 16.26
2011RECH01 8.90 15.25
2007SHIR01 8.91 15.79
2008JADE01 8.93 15.18
2014YANG11 8.96 15.88
2010STOL01 9.02 19.88
2011ALFA02 9.09 15.83
2007HESS01 9.13 16.31
2013SEOH01 9.14 21.93
2008LINH01 9.21 15.25
2009PICH01 9.21 20.25
2008LINH01 9.22 19.55
2005AKKE01 9.22 16.00
2008BRAN01 9.28 15.62
2010DUON01 9.31 16.99
2009NATE01 9.34 16.07
2013ANDR04 9.35 15.13
2012PERK01 9.35 15.09
2013KHUU01 9.36 15.52
2014WANG26 9.37 17.36
2013KASH01 9.40 19.54
2007THOM02 9.40 16.64
2007VALK01 9.41 15.61
2009OHRN01 9.42 17.66
2007LING01 9.43 15.05
2008CLEM01 9.43 17.39
2009KIEL01 9.44 17.86
2009GUGL01 9.44 15.68
2013CHEU01 9.45 15.87
2012MAAL01 9.46 15.39
2010ANDE03 9.46 16.01
2011SALG01 9.53 19.39
2007PERG01 9.53 16.01
2010GOLD01 9.54 15.58
2012KIMD01 9.55 16.14
2003BRUC01 9.55 16.24
2008JINX01 9.55 15.61
2008LOMB01 9.56 15.53
2009ROTA01 9.56 22.45
2003POCH01 9.56 17.21
2007PERG01 9.58 15.79
2010KOUG01 9.59 15.43
2014CYBU02 9.64 16.76
2011FOYL01 9.65 16.16
2015MARC03 9.66 15.04
2003BRUC01 9.68 15.51
2011HAVL01 9.69 15.71
2013VIDA01 9.71 15.89
2009CHEN35 9.71 15.10
2012CROS01 9.72 16.99
2013OLIV01 9.72 15.08
2008DIEW01 9.72 15.06
2005AKKE01 9.75 16.00
2008MORA02 9.75 15.61
2009JAGI01 9.77 16.85
2012MORA06 9.78 16.24
2013CHIX01 9.78 17.63
2008LINH01 9.78 15.25
2009VERA01 9.78 15.10
2008BERE01 9.80 15.32
2007LUJI01 9.80 15.22
2006GARR01 9.81 15.19
2006ANDO01 9.83 15.34
2008LIZH02 9.84 16.84
2013HANN01 9.86 17.44
2012HUAN12 9.87 18.65
2009HAYA01 9.88 15.91
2007GOUL01 9.88 15.59
2003BRUC01 9.88 15.82
2007LIME01 9.88 15.10
2006TABU01 9.90 15.86
2009LAIY01 9.92 16.80
2012SLIZ01 9.92 21.90
2003BRUC01 9.93 15.43
2012DOED01 9.93 15.10
2009PICH01 9.93 20.25
2013LINK01 9.94 16.01
2011EBEL01 9.94 17.23
2012CHIN01 9.94 16.33
2011BRZE01 9.96 16.65
2011WANG52 9.97 15.92
2011BANS02 9.98 16.64
2012IVAN02 9.98 15.02
2012KONG01 9.98 17.23
2006AUST01 9.99 15.18
2008LINH01 9.99 15.25
2010MARI02 10.00 15.35
2011SZAT01 10.00 17.28
2013GUMP01 10.00 24.85
2010BECK01 10.02 15.05

>10s:

WCA ID Solve Average
2013RAVI06 5.58 10.60
2010WANG53 5.81 10.49
2010BURN01 5.93 10.53
2013NAHM01 6.15 10.07
2010THOM03 6.21 11.14
2010LANE02 6.25 11.39
2010PROT01 6.27 10.33
2012MAHV01 6.32 10.07
2011HAMS01 6.50 12.09
2009CHAR03 6.50 10.69
2006TSAI03 6.50 11.28
2008HASH02 6.56 11.51
2007VALK01 6.61 10.25
2010KIPA01 6.61 10.34
2010YOUY01 6.61 11.16
2011KNOT01 6.64 13.19
2011BARB03 6.64 10.92
2010PROT01 6.65 12.27
2007VALL01 6.65 10.36
2009MORI05 6.77 10.04
2010MALL01 6.80 10.50
2013WOJT02 6.81 11.24
2012ROQU01 6.82 10.18
2009FUSH01 6.84 10.21
2009BOZS01 6.84 10.12
2010ADHI01 6.84 11.38
2012SZEW01 6.87 13.45
2008CHUC02 6.89 12.06
2011GROG02 6.89 10.15
2011HOFF02 6.90 10.78
2009YAUR01 6.91 10.40
2012RUPE01 6.91 10.37
2013ZHOU19 6.92 11.67
2005BATI01 6.93 10.49
2008SEAR01 6.93 12.22
2007HESS01 6.94 10.52
2012PONC02 7.00 10.60
2014KARN02 7.00 11.49
2007NAKA03 7.00 10.27
2010WEYE02 7.00 10.96
2011LIYI02 7.02 11.31
2007HESS01 7.02 12.04
2010WEYE02 7.02 10.25
2006GUNJ01 7.03 10.38
2013HUAN30 7.04 13.18
2015CHEA01 7.05 11.00
2007HESS01 7.06 11.26
2009YAUR01 7.06 10.12
2007VALL01 7.08 10.43
2005AKKE01 7.08 12.26
2013BAUT01 7.09 14.06
2010WEYE02 7.11 10.20
2012KALE01 7.11 10.93
2008SEAR01 7.13 10.66
2011ZALE02 7.13 11.02
2014GERB01 7.13 10.11
2011ZENG06 7.14 11.36
2010CANT02 7.16 10.15
2007NAKA03 7.16 10.63
2009LIUE01 7.16 11.81
2013BALI01 7.17 11.14
2009JIAY01 7.18 10.44
2013UVES01 7.18 11.61
2012PONC02 7.18 10.68
2009ZHAN53 7.18 10.90
2010KIPA01 7.19 10.35
2012KALE01 7.19 10.46
2012LEWI01 7.19 11.04
2010WANG53 7.20 10.10
2012ROZA01 7.21 12.19
2012WESC01 7.21 10.77
2009BARB01 7.21 10.06
2009KORB01 7.25 11.41
2012IVAN03 7.25 11.97
2008LINE02 7.25 10.89
2009DIEC01 7.25 10.08
2009BARB01 7.25 10.37
2005AKKE01 7.25 10.98
2007WOOR01 7.27 10.81
2009BARB01 7.28 10.35
2013LEJE03 7.28 10.35
2009WHIT01 7.28 10.46
2007COHE01 7.28 13.67
2010SCHM01 7.28 10.24
2011RHEI01 7.28 10.14
2013JOKI01 7.28 10.02
2012KALE01 7.29 12.06
2012DYGI01 7.29 10.59
2012CHOS01 7.30 10.01
2012CHOS01 7.30 10.74
2014HOUS01 7.30 11.90
2010LEED02 7.30 10.41
2007GUIM01 7.30 11.29
2011FATE01 7.30 11.20
2011ALVI01 7.30 12.05
2009KORB01 7.31 11.69
2011TORG01 7.31 11.21
2010PROT01 7.31 10.16
2013PARK03 7.31 10.47
2008SEAR01 7.31 10.42

R code:

Code:

raw_data = read.csv(file = "WCA_export_Results.tsv", head = TRUE, sep = "\t") valid_333 = data.frame(raw_data$personId, raw_data$eventId, raw_data$value1, raw_data$value2, raw_data$value3, raw_data$value4, raw_data$value5, raw_data$average) names(valid_333) = c("person", "event", "s1", "s2", "s3", "s4", "s5", "average") valid_333 = subset(valid_333, event == "333" & average > 0) s1s = data.frame(valid_333$person, valid_333$s1, valid_333$average) s2s = data.frame(valid_333$person, valid_333$s2, valid_333$average) s3s = data.frame(valid_333$person, valid_333$s3, valid_333$average) s4s = data.frame(valid_333$person, valid_333$s4, valid_333$average) s5s = data.frame(valid_333$person, valid_333$s5, valid_333$average) n = c("person", "solve", "average") names(s1s) = n names(s2s) = n names(s3s) = n names(s4s) = n names(s5s) = n all_valid_333_solves = rbind(s1s, s2s, s3s, s4s, s5s) all_valid_333_solves = subset(all_valid_333_solves, solve > 0) sup20s = subset(all_valid_333_solves, average > 2000) sup20s = sup20s[order(sup20s$solve),][1:100,] sup15s = subset(all_valid_333_solves, average > 1500) sup15s = sup15s[order(sup15s$solve),][1:100,] sup10s = subset(all_valid_333_solves, average > 1000) sup10s = sup10s[order(sup10s$solve),][1:100,]

In relation to this, what is the lowest number for "official PB single / official PB avg"?

Sergeant Baboon · Sep 29, 2015

YouCubing said:
In relation to this, what is the lowest number for "official PB single / official PB avg"?

For all people who have a PB single and average:

WCA ID	PB Single	PB Average	PB Single / Average
2014ZHUR02	111.68	514.22	0.217183306755863
2014LOMB01	88.76	398.66	0.222645863643205
2014PATW02	78.78	320.92	0.245481739997507
2015TYMO01	14.22	56.52	0.251592356687898
2014KANT03	13.36	48.87	0.273378350726417
2013VINO01	22.41	74.86	0.299358803099118
2015NAGA02	24.75	81.37	0.304166154602433
2014BROA01	77.00	234.72	0.328050443081118
2012DIVA01	93.27	278.67	0.334696953385725
2015THOD01	16.73	49.17	0.340248118771609
2008KULI01	21.20	61.22	0.346292061417837
2014ANCC01	112.81	320.51	0.351970297338617
2006TANA01	38.96	108.32	0.359675036927622
2014THAK05	68.82	187.27	0.367490788700806
2012WEIB02	84.26	219.87	0.38322645199436
2014PHLE01	32.02	83.25	0.384624624624625
2009SOST01	69.46	180.54	0.384734684834386
2007OKAD01	23.09	59.38	0.388851465139778
2013ZHON05	54.24	137.89	0.393357023714555
2012SUZU01	38.90	97.93	0.397222505871541
2014WILL07	150.46	378.59	0.397422013259727
1982VALD01	29.62	74.44	0.397904352498657
2014MACH07	158.15	394.89	0.400491276051559
2012SANT03	57.84	143.76	0.402337228714524
2014WESO02	18.67	46.08	0.405164930555556

For PB sub-30 averages:

WCA ID	PB Single	PB Average	PB Single / Average
2013GUMP01	10.00	24.42	0.40950040950041
2015ARYA02	10.87	25.52	0.425940438871473
2013TORR02	10.43	21.80	0.478440366972477
2015ESTU02	14.00	29.18	0.47978067169294
2014IVAN01	13.22	26.58	0.497366440933032
2014CHIE01	11.01	21.94	0.501823154056518
2013FERR03	10.94	21.78	0.502295684113866
2013BAUT01	7.09	13.68	0.51827485380117
2013FANJ02	14.20	26.36	0.538694992412747
2015YUYO01	14.71	26.70	0.550936329588015
2007CLAE03	8.63	15.64	0.551790281329923
2010LIUD02	11.83	21.43	0.552029864675688
2012BOBJ01	16.53	29.79	0.554884189325277
2012PARA03	11.40	20.53	0.555284948855334
2015HUAN25	10.90	19.60	0.556122448979592
2013VOLO01	12.27	21.94	0.559252506836828
2014LILI01	15.31	27.32	0.560395314787701
2014POPA01	14.34	25.43	0.563900904443571
2014SZNE01	12.52	22.03	0.568315932818883
2014LEIR01	14.65	25.72	0.569595645412131
2007COOP01	10.61	18.53	0.572584997301673
2014CYBU02	9.64	16.76	0.575178997613365
2010ZHAO18	14.15	24.57	0.575905575905576
2014MERH01	15.34	26.56	0.577560240963855
2015QUAD01	14.03	24.21	0.579512598099959

Sub-20:

WCA ID	PB Single	PB Average	PB Single / Average
2013BAUT01	7.09	13.68	0.51827485380117
2007CLAE03	8.63	15.64	0.551790281329923
2015HUAN25	10.90	19.60	0.556122448979592
2007COOP01	10.61	18.53	0.572584997301673
2014CYBU02	9.64	16.76	0.575178997613365
2011MERL01	7.96	13.58	0.586156111929308
2014WANG26	9.37	15.97	0.586725109580463
2010HYUN01	7.90	13.38	0.590433482810164
2015VALA01	10.61	17.93	0.591745677635248
2014SHEN06	8.53	14.39	0.59277275886032
2013ZHOU19	6.92	11.67	0.592973436161097
2010DUON01	9.31	15.66	0.594508301404853
2014ZABI01	11.08	18.58	0.596340150699677
2013RAHS01	11.50	19.26	0.597092419522326
2010DOTR01	10.41	17.39	0.598619896492237
2008JADE01	8.93	14.90	0.599328859060403
2013GRAE01	10.16	16.89	0.60153937240971
2014RAMA06	10.78	17.90	0.602234636871508
2009JAGI01	9.77	16.20	0.603086419753086
2013SCHM02	7.79	12.90	0.603875968992248
2014RUDA01	11.28	18.64	0.605150214592275
2009OHRN01	9.42	15.52	0.606958762886598
2015MAGA02	7.52	12.35	0.608906882591093
2013LUDW01	5.96	9.71	0.613800205973223
2012MAAL01	9.46	15.39	0.614684860298895

Sub-15:

WCA ID	PB Single	PB Average	PB Single / Average
2013BAUT01	7.09	13.68	0.51827485380117
2011MERL01	7.96	13.58	0.586156111929308
2010HYUN01	7.90	13.38	0.590433482810164
2014SHEN06	8.53	14.39	0.59277275886032
2013ZHOU19	6.92	11.67	0.592973436161097
2008JADE01	8.93	14.90	0.599328859060403
2013SCHM02	7.79	12.90	0.603875968992248
2015MAGA02	7.52	12.35	0.608906882591093
2013LUDW01	5.96	9.71	0.613800205973223
2011JOVI01	8.05	13.06	0.616385911179173
2012TERE01	7.36	11.90	0.618487394957983
2014HERN08	7.73	12.42	0.622383252818035
2009SUPC01	8.55	13.70	0.624087591240876
2013HUAN30	7.04	11.18	0.629695885509839
2015BROK01	8.30	13.15	0.631178707224335
2011NATH02	8.80	13.91	0.632638389647735
2013CHIA03	8.92	14.09	0.633073101490419
2013KATO01	7.55	11.89	0.634987384356602
2009ZAMZ01	9.41	14.80	0.635810810810811
2008MCKE01	9.47	14.89	0.635997313633311
2012SZEW01	6.87	10.73	0.640260950605778
2011VAND01	9.28	14.48	0.640883977900553
2013PIEC02	8.79	13.66	0.643484626647145
2007JOHN02	7.94	12.32	0.644480519480519
2013MACI01	8.78	13.61	0.645113886847906

Sub-10:

WCA ID	PB Single	PB Average	PB Single / Average
2013LUDW01	5.96	9.71	0.613800205973223
2010BURN01	5.25	8.06	0.65136476426799
2012MAHV01	6.32	9.58	0.659707724425887
2013RAVI06	5.58	8.36	0.667464114832536
2013LINK01	6.13	9.18	0.667755991285403
2006TSAI03	6.50	9.69	0.670794633642931
2010LANE02	6.25	9.25	0.675675675675676
2012MCNE01	5.91	8.67	0.681660899653979
2011KNOT01	6.64	9.70	0.684536082474227
2013WOJT02	6.81	9.93	0.685800604229607
2011ZALE02	6.42	9.31	0.689581095596133
2010YOUY01	6.61	9.55	0.692146596858639
2011HAMS01	6.50	9.37	0.693703308431163
2010THOM03	6.21	8.92	0.696188340807175
2010ADHI01	6.84	9.79	0.698672114402451
2012WICH01	6.52	9.33	0.69882100750268
2011DERS01	6.77	9.62	0.703742203742204
2010WANG53	5.81	8.23	0.70595382746051
2011GROG02	6.89	9.69	0.711042311661507
2011BARB03	6.64	9.33	0.711682743837085
2011HOFF02	6.90	9.68	0.712809917355372
2010CORM02	6.41	8.99	0.71301446051168
2010PROT01	6.27	8.70	0.720689655172414
2009KONV01	6.15	8.50	0.723529411764706
2009PLES01	5.81	7.98	0.728070175438597

R code:

Code:

raw_data = read.csv(file = "WCA_export_Results.tsv", head = TRUE, sep = "\t")
valid_333 = data.frame(raw_data$personId, raw_data$eventId, raw_data$best,
  raw_data$value1, raw_data$value2, raw_data$value3, raw_data$value4, raw_data$value5, raw_data$average)
names(valid_333) = c("person", "event", "best", "s1", "s2", "s3", "s4", "s5", "average")
valid_333 = subset(valid_333, event == "333")

valid_333$best[valid_333$best <= 0] = 1000000
valid_333$average[valid_333$average <= 0] = 1000000

pb_singles = aggregate(valid_333$best, list(person = valid_333$person), min)
pb_avgs = aggregate(valid_333$average, list(person = valid_333$person), min)
names(pb_singles) = c("person", "single")
names(pb_avgs) = c("person", "average")
pbs = merge(x = pb_singles, y = pb_avgs, by.x = "person", by.y = "person")
pbs = subset(pbs, single != 1000000 & average != 1000000)

pbs$ratio = pbs$single / pbs$average
pbs = pbs[order(pbs$ratio),]

pbs_sub30 = subset(pbs, average < 3000)[1:25,]
pbs_sub20 = subset(pbs, average < 2000)[1:25,]
pbs_sub15 = subset(pbs, average < 1500)[1:25,]
pbs_sub10 = subset(pbs, average < 1000)[1:25,]
pbs = pbs[1:25,]

TMOY · Sep 29, 2015

Sergeant Baboon said:
edit: Went through the database and found the biggest difference between an average and best single in that average. Daniel Sheppard got an average of 1:52.86 with a 16.46 single. Full average was 18.43, 20.22, (16.46), (DNF), 4:59.94.

I thought that one would be exceptional and the rest would be lucky singles, but it seems like most of these are the same way--a mostly good average and then a DNF paired with a complete collapse on one solve that skews the whole average. Even after I filtered to only see sub-30 averages, it's mostly stuff like someone who's comfortably sub-20 or sub-15 getting a DNF then a 40.xx or something.

That's pretty common,cubers who screw up two consecutive solves simply don't care about the average anymore. I remember Daniel''s 4:59.94 solve (I witnessed it): when it became evident that he wouldn't get a decent average anyway, he started to do random stuff until the 5-minute time limit was (almost) reached.

illius · Sep 29, 2015

TMOY said:
That's pretty common,cubers who screw up two consecutive solves simply don't care about the average anymore. I remember Daniel''s 4:59.94 solve (I witnessed it): when it became evident that he wouldn't get a decent average anyway, he started to do random stuff until the 5-minute time limit was (almost) reached.

Isn't that technically breaching the regulations?

Sent from my MotoG3 using Tapatalk

Hssandwich · Sep 29, 2015

illius said:
Isn't that technically breaching the regulations?

Sent from my MotoG3 using Tapatalk

It wasn't at the time.

illius · Sep 29, 2015

Hssandwich said:
It wasn't at the time.

Okay.

AlexMaass · Sep 29, 2015

3x3 single and average NRs, but based on where it was set, not the citizenship of the person?

Odd WCA stats/ Stats request Thread

Premium Member

Legend

Veteran

Veteran

Veteran

Veteran

Veteran

Legend

Regular

Veteran

Regular

Legend

Regular

Veteran

Regular

Veteran

Regular

Veteran

Regular

Veteran

Similar threads