Odd WCA stats/ Stats request Thread

Stefan · Feb 18, 2015

mycube said:
What's the longest period of time where no WRs were set? I just noticed because there were no WRs this year

Big bang to 1982.

TDM · Feb 18, 2015

mycube said:
What's the longest period of time where no WRs were set? I just noticed because there were no WRs this year

http://www.reddit.com/r/Cubers/comm..._been_a_world_record_for_65_days_this/coo76cp

Hssandwich · Feb 18, 2015

bubbagrub said:
For 3x3, the biggest discrepancy is Kasoju Chandra Kanth who has a 13.36 single and a best average of 48.87.

Since you asked about Skewb, the biggest discrepancy there is Cody Brown who has a best single of 3.38 (68th in the world) and a best average of 25.86 (2131st in the world). Wow.

Wow, how on earth could that happen? Unless they were trying to get a horrible average so that they could be like that. I suppose skewb was just a matter of luck.

Sebastien · Feb 19, 2015

Inspired by a question on the Delegate mailing list, I checked for WCA competitions with at least one other event having more rounds than the 3x3x3 event.

There are 60 such competitions out of 2123:

[table="width: 1000, align: left"][tr][td]competitionId[/td][td]333rounds[/td][td]maxrounds[/td][td]maxevents[/td][/tr]
[tr][td]BigCubeKrasnik2014[/td][td]2[/td][td]3[/td][td]666,777,444,555[/td][/tr]
[tr][td]MichiganCubingClubAlpha2015[/td][td]2[/td][td]3[/td][td]333oh[/td][/tr]
[tr][td]SkanstullCube2014[/td][td]2[/td][td]3[/td][td]222[/td][/tr]
[tr][td]SPOpen2014[/td][td]2[/td][td]3[/td][td]222,444[/td][/tr]
[tr][td]VCubeSpiel2011[/td][td]2[/td][td]3[/td][td]555[/td][/tr]
[tr][td]C3Open2014[/td][td]1[/td][td]2[/td][td]pyram,skewb,sq1,333oh[/td][/tr]
[tr][td]PinoyBigCubesOpen2015[/td][td]1[/td][td]2[/td][td]555,666,777,pyram[/td][/tr]
[tr][td]EastJapanBigCubes2012[/td][td]0[/td][td]3[/td][td]555[/td][/tr]
[tr][td]GuangzhouBigCubes2013[/td][td]0[/td][td]3[/td][td]444[/td][/tr]
[tr][td]GuangzhouBigCubes2014[/td][td]0[/td][td]3[/td][td]444,pyram[/td][/tr]
[tr][td]MagicsKorea2012[/td][td]0[/td][td]3[/td][td]magic,mmagic[/td][/tr]
[tr][td]TaiwanBigCube2010[/td][td]0[/td][td]3[/td][td]555,444[/td][/tr]
[tr][td]VCUBESpiel2010[/td][td]0[/td][td]3[/td][td]555[/td][/tr]
[tr][td]AnotherFMC2015[/td][td]0[/td][td]2[/td][td]333bf[/td][/tr]
[tr][td]BeijingFebruary2011[/td][td]0[/td][td]2[/td][td]555,666,clock,pyram[/td][/tr]
[tr][td]BeijingFootsteps2011[/td][td]0[/td][td]2[/td][td]333ft[/td][/tr]
[tr][td]BeijingNoCubes2010[/td][td]0[/td][td]2[/td][td]mmagic,pyram,clock,sq1,magic[/td][/tr]
[tr][td]BeijingSideEventsSupplement2010[/td][td]0[/td][td]2[/td][td]sq1,pyram[/td][/tr]
[tr][td]CampeonatoBlind2013[/td][td]0[/td][td]2[/td][td]333bf,444,sq1,222[/td][/tr]
[tr][td]CyclopsOpen2011[/td][td]0[/td][td]2[/td][td]333bf,555[/td][/tr]
[tr][td]EastJapanBigCubes2013[/td][td]0[/td][td]2[/td][td]555,666,777,minx[/td][/tr]
[tr][td]GalaOpen2014[/td][td]0[/td][td]2[/td][td]pyram,skewb,minx[/td][/tr]
[tr][td]GuangzhouBigCubes2010[/td][td]0[/td][td]2[/td][td]mmagic,pyram,444,sq1,555[/td][/tr]
[tr][td]GuangzhouHaizhu2011[/td][td]0[/td][td]2[/td][td]333oh[/td][/tr]
[tr][td]HaNoiBigCube2012[/td][td]0[/td][td]2[/td][td]444,555[/td][/tr]
[tr][td]HaNoiBigCube2013[/td][td]0[/td][td]2[/td][td]555,444[/td][/tr]
[tr][td]JavaFMCCubeDay2010[/td][td]0[/td][td]2[/td][td]333fm[/td][/tr]
[tr][td]MiniCampeonatoSantiago2014[/td][td]0[/td][td]2[/td][td]333bf,444,222[/td][/tr]
[tr][td]NanjingAutumn2011[/td][td]0[/td][td]2[/td][td]magic,sq1,minx,mmagic,pyram[/td][/tr]
[tr][td]PinoyBigCubesOpen2009[/td][td]0[/td][td]2[/td][td]444,555[/td][/tr]
[tr][td]PLG2Open2012[/td][td]0[/td][td]2[/td][td]pyram,222,333bf[/td][/tr]
[tr][td]QuezonMegaminxOpen2009[/td][td]0[/td][td]2[/td][td]minx[/td][/tr]
[tr][td]ShanghaiMilanyuanCafe2014[/td][td]0[/td][td]2[/td][td]skewb,222[/td][/tr]
[tr][td]SingaporeSpecial2013[/td][td]0[/td][td]2[/td][td]clock,minx,pyram[/td][/tr]
[tr][td]TelesisBlindfoldOpen2014[/td][td]0[/td][td]2[/td][td]333bf,minx[/td][/tr]
[tr][td]TelesisOpen2014[/td][td]0[/td][td]2[/td][td]skewb[/td][/tr]
[tr][td]WasedaBrainChallenge2012[/td][td]0[/td][td]2[/td][td]333bf[/td][/tr]
[tr][td]BeijingAfterDark2011[/td][td]0[/td][td]1[/td][td]333mbf,444bf,555bf[/td][/tr]
[tr][td]BigCubesSummer2009[/td][td]0[/td][td]1[/td][td]777,pyram,555,clock,sq1,555bf,minx,444,666,mmagic,...[/td][/tr]
[tr][td]ChiayiPyraminx2009[/td][td]0[/td][td]1[/td][td]pyram[/td][/tr]
[tr][td]ChinaFMBeijing2011[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]ChinaFMGuangzhou2011[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]ChinaFMShanghai2011[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]ChinaFMShenyang2011[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]ChinaFMXian2011[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]ChinaFMZhengzhou2011[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]CrossstraitFMC2014[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]FMCUSA2014[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]FMUkraine2014[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]GuangzhouCubeDay2011[/td][td]0[/td][td]1[/td][td]555,666,777,333bf,minx[/td][/tr]
[tr][td]GuangzhouFMC2012[/td][td]0[/td][td]1[/td][td]333fm,mmagic,pyram[/td][/tr]
[tr][td]KantoFMC2015[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]MITFMC2014[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]PKUFM2012[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]PKUFMC2010[/td][td]0[/td][td]1[/td][td]333fm[/td][/tr]
[tr][td]ShanghaiSpring2011[/td][td]0[/td][td]1[/td][td]sq1,777,333fm,clock,333ft,minx,666[/td][/tr]
[tr][td]TaichungPyraminx2009[/td][td]0[/td][td]1[/td][td]pyram[/td][/tr]
[tr][td]TaipeiPyraminx2009[/td][td]0[/td][td]1[/td][td]pyram[/td][/tr]
[tr][td]TaiwanAutumn2010[/td][td]0[/td][td]1[/td][td]333ft,333oh,222,333bf[/td][/tr]
[tr][td]XianWinter2011[/td][td]0[/td][td]1[/td][td]sq1,magic,minx,pyram,clock[/td][/tr]
[/table]

SELECT tmp2.competitionId, 333rounds, maxrounds, group_concat(eventId) as maxevents FROM
(SELECT competitionId, eventId, COUNT(distinct roundId) as numrounds FROM `Results` WHERE 1
GROUP BY competitionId, eventId) tmp2 INNER JOIN
(SELECT competitionId, sum(if(eventId="333",numrounds,0)) as 333rounds, max(numrounds) as maxrounds
FROM (SELECT competitionId, eventId, COUNT(distinct roundId) as numrounds FROM `Results` WHERE 1
GROUP BY competitionId, eventId) tmp
GROUP BY competitionId) tmp3 on tmp2.competitionId=tmp3.competitionId
WHERE numrounds=maxrounds and 333rounds < maxrounds
GROUP BY tmp2.competitionId
ORDER BY 333rounds DESC, maxrounds DESC

AndersB · Feb 20, 2015

https://www.worldcubeassociation.or...nId=Sweden&eventId=222&years=&history=History
According to this, Marcus and I are former NR-holders for single, even though Swedish championship 2014 took place 3 months before Huddinge cube day 2014. I challenge you to figure out why it looks like this!

ottozing · Feb 20, 2015

AndersB said:
https://www.worldcubeassociation.or...nId=Sweden&eventId=222&years=&history=History
According to this, Marcus and I are former NR-holders for single, even though Swedish championship 2014 took place 3 months before Huddinge cube day 2014. I challenge you to figure out why it looks like this!

Mattias Uvesten's .88 was originally DNF because of talking about the scramble after his solve, but recently got reinstated

Ollie · Feb 22, 2015

Can I have stats for:

1. The number of competitors participating in 5BLD per year for the last 5 years (ignoring 2015, ofc)
2. The same for 4BLD?
3. The success rate for all 4BLD attempts in 2014? And the same for 5BLD?

Ta

Sebastien · Feb 22, 2015

AndersB said:
https://www.worldcubeassociation.or...nId=Sweden&eventId=222&years=&history=History
According to this, Marcus and I are former NR-holders for single, even though Swedish championship 2014 took place 3 months before Huddinge cube day 2014. I challenge you to figure out why it looks like this!

Seems like some results team member didn't take into account all possible effects when reinstating Mattias' solve. He fixed that now, sorry for the loss of your NRs.

bubbagrub · Feb 22, 2015

Ollie said:
Can I have stats for:

1. The number of competitors participating in 5BLD per year for the last 5 years (ignoring 2015, ofc)
2. The same for 4BLD?
3. The success rate for all 4BLD attempts in 2014? And the same for 5BLD?

Ta

Number of competitors:

[table="width: 500, class: grid"]
[tr]
[td]Year[/td]
[td]5BLD[/td]
[td]4BLD[/td]
[/tr]
[tr]
[td]2003[/td]
[td]1[/td]
[td]1[/td]
[/tr]
[tr]
[td]2004[/td]
[td]3[/td]
[td]2[/td]
[/tr]
[tr]
[td]2005[/td]
[td]2[/td]
[td]1[/td]
[/tr]
[tr]
[td]2006[/td]
[td]1[/td]
[td]1[/td]
[/tr]
[tr]
[td]2007[/td]
[td]10[/td]
[td]18[/td]
[/tr]
[tr]
[td]2008[/td]
[td]21[/td]
[td]59[/td]
[/tr]
[tr]
[td]2009[/td]
[td]28[/td]
[td]78[/td]
[/tr]
[tr]
[td]2010[/td]
[td]55[/td]
[td]128[/td]
[/tr]
[tr]
[td]2011[/td]
[td]96[/td]
[td]182[/td]
[/tr]
[tr]
[td]2012[/td]
[td]95[/td]
[td]208[/td]
[/tr]
[tr]
[td]2013[/td]
[td]148[/td]
[td]238[/td]
[/tr]
[tr]
[td]2014[/td]
[td]150[/td]
[td]259[/td]
[/tr]
[tr]
[td]2015 (so far)[/td]
[td]19[/td]
[td]49[/td]
[/tr]
[/table]

In 2014, there were 750 5BLD attempts (ignoring DNSs), of which 610 were DNF and 140 were success, meaning 18.67% success rate.
In 2014, there were 1649 4BLD attempts (ignoring DNSs), of which 1283 were DNF and 366 were success, meaning 22.20% success rate.

Ollie · Feb 22, 2015

bubbagrub said:
Number of competitors:

[table="width: 500, class: grid"]
[tr]
[td]Year[/td]
[td]5BLD[/td]
[td]4BLD[/td]
[/tr]
[tr]
[td]2003[/td]
[td]1[/td]
[td]1[/td]
[/tr]
[tr]
[td]2004[/td]
[td]3[/td]
[td]2[/td]
[/tr]
[tr]
[td]2005[/td]
[td]2[/td]
[td]1[/td]
[/tr]
[tr]
[td]2006[/td]
[td]1[/td]
[td]1[/td]
[/tr]
[tr]
[td]2007[/td]
[td]10[/td]
[td]18[/td]
[/tr]
[tr]
[td]2008[/td]
[td]21[/td]
[td]59[/td]
[/tr]
[tr]
[td]2009[/td]
[td]28[/td]
[td]78[/td]
[/tr]
[tr]
[td]2010[/td]
[td]55[/td]
[td]128[/td]
[/tr]
[tr]
[td]2011[/td]
[td]96[/td]
[td]182[/td]
[/tr]
[tr]
[td]2012[/td]
[td]95[/td]
[td]208[/td]
[/tr]
[tr]
[td]2013[/td]
[td]148[/td]
[td]238[/td]
[/tr]
[tr]
[td]2014[/td]
[td]150[/td]
[td]259[/td]
[/tr]
[tr]
[td]2015 (so far)[/td]
[td]19[/td]
[td]49[/td]
[/tr]
[/table]

In 2014, there were 750 5BLD attempts (ignoring DNSs), of which 610 were DNF and 140 were success, meaning 18.67% success rate.
In 2014, there were 1649 4BLD attempts (ignoring DNSs), of which 1283 were DNF and 366 were success, meaning 22.20% success rate.

Thanks, Ben!

I had a suspicion that the number of 5BLD competitors was decreasing, but time will tell.

I also thought that 4BLD accuracy would be a bit higher.

cubizh · Feb 22, 2015

Ollie said:
Can I have stats for:

3. The success rate for all 4BLD attempts in 2014? And the same for 5BLD?

Ta

Since bubba already gave the information you requested without DNSs, I included both DNF and DNSs for a larger period:

[TABLE="class:grid,align:left"]
[TR][TD] Year [/TD][TD] DNF/DNS [/TD][TD] TOTAL [/TD][TD] % [/TD][/TR]
[TR][TD] 2009 [/TD][TD] 290 [/TD][TD] 346 [/TD][TD] 83.8% [/TD][/TR]
[TR][TD] 2010 [/TD][TD] 585 [/TD][TD] 715 [/TD][TD] 81.8% [/TD][/TR]
[TR][TD] 2011 [/TD][TD] 803 [/TD][TD] 988 [/TD][TD] 81.3% [/TD][/TR]
[TR][TD] 2012 [/TD][TD] 934 [/TD][TD] 1160 [/TD][TD] 80.5% [/TD][/TR]
[TR][TD] 2013 [/TD][TD] 1193 [/TD][TD] 1516 [/TD][TD] 78.7% [/TD][/TR]
[TR][TD] 2014 [/TD][TD] 1440 [/TD][TD] 1806 [/TD][TD] 79.7% [/TD][/TR]
[/TABLE]

[TABLE="class:grid,align:left"]
[TR][TD] Year [/TD][TD] DNF/DNS [/TD][TD] TOTAL [/TD][TD] % [/TD][/TR]
[TR][TD] 2009 [/TD][TD] 80 [/TD][TD] 96 [/TD][TD] 83.3% [/TD][/TR]
[TR][TD] 2010 [/TD][TD] 293 [/TD][TD] 331 [/TD][TD] 88.5% [/TD][/TR]
[TR][TD] 2011 [/TD][TD] 424 [/TD][TD] 519 [/TD][TD] 81.7% [/TD][/TR]
[TR][TD] 2012 [/TD][TD] 464 [/TD][TD] 529 [/TD][TD] 87.7% [/TD][/TR]
[TR][TD] 2013 [/TD][TD] 768 [/TD][TD] 895 [/TD][TD] 85.8% [/TD][/TR]
[TR][TD] 2014 [/TD][TD] 861 [/TD][TD] 1001 [/TD][TD] 86.0% [/TD][/TR]
[/TABLE]

Stefan · Feb 22, 2015

Ollie said:
I also thought that 4BLD accuracy would be a bit higher.

You thought right

(unless it's me who made the mistake)

Using data from WCA_export607_20150222 and Stefan's WCA Data Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Year[/TD][TD]Attempts[/TD][TD]Successes[/TD][TD]Average[/TD][TD]Best[/TD][TD]Worst[/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]1[/TD][TD="align:right"]100.00%[/TD][TD="align:right"]22:35.00[/TD][TD="align:right"]22:35.00[/TD][TD="align:right"]22:35.00[/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]3[/TD][TD="align:right"]33.33%[/TD][TD="align:right"]19:14.00[/TD][TD="align:right"]19:14.00[/TD][TD="align:right"]19:14.00[/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]2[/TD][TD="align:right"]0.00%[/TD][TD="align:right"][/TD][TD="align:right"]27:46:39.99[/TD][TD="align:right"][/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]8[/TD][TD="align:right"]50.00%[/TD][TD="align:right"]11:18.99[/TD][TD="align:right"]8:04.90[/TD][TD="align:right"]15:45.00[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]54[/TD][TD="align:right"]29.63%[/TD][TD="align:right"]21:06.92[/TD][TD="align:right"]6:20.96[/TD][TD="align:right"]40:16.00[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]215[/TD][TD="align:right"]15.81%[/TD][TD="align:right"]16:05.85[/TD][TD="align:right"]6:05.21[/TD][TD="align:right"]36:16.00[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]283[/TD][TD="align:right"]18.37%[/TD][TD="align:right"]14:41.91[/TD][TD="align:right"]4:46.19[/TD][TD="align:right"]27:49.00[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]606[/TD][TD="align:right"]21.45%[/TD][TD="align:right"]15:07.98[/TD][TD="align:right"]4:42.34[/TD][TD="align:right"]46:12.00[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]848[/TD][TD="align:right"]20.99%[/TD][TD="align:right"]12:36.18[/TD][TD="align:right"]3:26.11[/TD][TD="align:right"]49:52.00[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]956[/TD][TD="align:right"]23.01%[/TD][TD="align:right"]11:59.85[/TD][TD="align:right"]2:48.88[/TD][TD="align:right"]41:46.00[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]1263[/TD][TD="align:right"]23.75%[/TD][TD="align:right"]10:28.06[/TD][TD="align:right"]2:30.62[/TD][TD="align:right"]32:29.00[/TD][/TR]
[TR][TD="align:right"]2014[/TD][TD="align:right"]1539[/TD][TD="align:right"]23.78%[/TD][TD="align:right"]10:20.98[/TD][TD="align:right"]2:18.65[/TD][TD="align:right"]36:44.00[/TD][/TR]
[TR][TD="align:right"]2015[/TD][TD="align:right"]121[/TD][TD="align:right"]17.36%[/TD][TD="align:right"]9:48.35[/TD][TD="align:right"]3:40.58[/TD][TD="align:right"]18:21.00[/TD][/TR]
[/TABLE]

Code:

[NOPARSE]SELECT
  year Year,
  solves+DNFs Attempts,
  solves/(solves+DNFs) 'Successes[%]',
  if(solves>0, cast(total/solves as unsigned), 0) 'Average[T]',
  best 'Best[T]',
  worst 'Worst[T]'
FROM
(SELECT
  year,
  sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves,
  sum((value1=-1)+(value2=-1)+(value3=-1)+(value4=-1)+(value5=-1)) DNFs,
  sum(if(value1>0,value1,0)+if(value2>0,value2,0)+if(value3>0,value3,0)+if(value4>0,value4,0)+if(value5>0,value5,0)) total,
  min(least(if(value1>0,value1,9999999),if(value2>0,value2,9999999),if(value3>0,value3,9999999),if(value4>0,value4,9999999),if(value5>0,value5,9999999))) best,
  max(greatest(value1,value2,value3,value4,value5)) worst
FROM Results JOIN Competitions ON Competitions.id = competitionId
WHERE eventId = '444bf'
GROUP BY year) tmp
ORDER BY year;[/NOPARSE]

JemFish · Feb 23, 2015

Stefan said:
You thought right (unless it's me who made the mistake)

Using data from WCA_export607_20150222 and Stefan's WCA Data Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Year[/TD][TD]Attempts[/TD][TD]Successes[/TD][TD]Average[/TD][TD]Best[/TD][TD]Worst[/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]1[/TD][TD="align:right"]100.00%[/TD][TD="align:right"]22:35.00[/TD][TD="align:right"]22:35.00[/TD][TD="align:right"]22:35.00[/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]3[/TD][TD="align:right"]33.33%[/TD][TD="align:right"]19:14.00[/TD][TD="align:right"]19:14.00[/TD][TD="align:right"]19:14.00[/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]2[/TD][TD="align:right"]0.00%[/TD][TD="align:right"][/TD][TD="align:right"]27:46:39.99[/TD][TD="align:right"][/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]8[/TD][TD="align:right"]50.00%[/TD][TD="align:right"]11:18.99[/TD][TD="align:right"]8:04.90[/TD][TD="align:right"]15:45.00[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]54[/TD][TD="align:right"]29.63%[/TD][TD="align:right"]21:06.92[/TD][TD="align:right"]6:20.96[/TD][TD="align:right"]40:16.00[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]215[/TD][TD="align:right"]15.81%[/TD][TD="align:right"]16:05.85[/TD][TD="align:right"]6:05.21[/TD][TD="align:right"]36:16.00[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]283[/TD][TD="align:right"]18.37%[/TD][TD="align:right"]14:41.91[/TD][TD="align:right"]4:46.19[/TD][TD="align:right"]27:49.00[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]606[/TD][TD="align:right"]21.45%[/TD][TD="align:right"]15:07.98[/TD][TD="align:right"]4:42.34[/TD][TD="align:right"]46:12.00[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]848[/TD][TD="align:right"]20.99%[/TD][TD="align:right"]12:36.18[/TD][TD="align:right"]3:26.11[/TD][TD="align:right"]49:52.00[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]956[/TD][TD="align:right"]23.01%[/TD][TD="align:right"]11:59.85[/TD][TD="align:right"]2:48.88[/TD][TD="align:right"]41:46.00[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]1263[/TD][TD="align:right"]23.75%[/TD][TD="align:right"]10:28.06[/TD][TD="align:right"]2:30.62[/TD][TD="align:right"]32:29.00[/TD][/TR]
[TR][TD="align:right"]2014[/TD][TD="align:right"]1539[/TD][TD="align:right"]23.78%[/TD][TD="align:right"]10:20.98[/TD][TD="align:right"]2:18.65[/TD][TD="align:right"]36:44.00[/TD][/TR]
[TR][TD="align:right"]2015[/TD][TD="align:right"]121[/TD][TD="align:right"]17.36%[/TD][TD="align:right"]9:48.35[/TD][TD="align:right"]3:40.58[/TD][TD="align:right"]18:21.00[/TD][/TR]
[/TABLE]

Code:

[NOPARSE]SELECT year Year, solves+DNFs Attempts, solves/(solves+DNFs) 'Successes[%]', if(solves>0, cast(total/solves as unsigned), 0) 'Average[T]', best 'Best[T]', worst 'Worst[T]' FROM (SELECT year, sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves, sum((value1=-1)+(value2=-1)+(value3=-1)+(value4=-1)+(value5=-1)) DNFs, sum(if(value1>0,value1,0)+if(value2>0,value2,0)+if(value3>0,value3,0)+if(value4>0,value4,0)+if(value5>0,value5,0)) total, min(least(if(value1>0,value1,9999999),if(value2>0,value2,9999999),if(value3>0,value3,9999999),if(value4>0,value4,9999999),if(value5>0,value5,9999999))) best, max(greatest(value1,value2,value3,value4,value5)) worst FROM Results JOIN Competitions ON Competitions.id = competitionId WHERE eventId = '444bf' GROUP BY year) tmp ORDER BY year;[/NOPARSE]

Hmm...very interesting...

Can I have the exact same stats as above please, except for blindfold cubers under 15 years of age; also, 333bf - 555bf, not just 444bf.

supercavitation · Feb 23, 2015

JemFish said:
Hmm...very interesting...

Can I have the exact same stats as above please, except for blindfold cubers under 15 years of age; also, 333bf - 555bf, not just 444bf.

The WCA doesn't publish age statistics, so I would bet the answer is no.

JemFish · Feb 23, 2015

supercavitation said:
The WCA doesn't publish age statistics, so I would bet the answer is no.

I would think so too but, just in case it's possible to get ages, I would like to see the statistics. Also, further up in this thread there is an 'average age' of world-class cubers, so maybe it's possible to get what I wanted.

guysensei1 · Feb 23, 2015

How many instances of equal single world ranking and average world ranking are there right now? How many have there been, ever?

bubbagrub · Feb 23, 2015

Stefan said:
You thought right (unless it's me who made the mistake)

Ooops -- yes. My mistake! The total number of DNFs for 4BLD in 2014 should be 1173, not 1283. So Stefan's stat is right, and mine is wrong.

JemFish · Feb 23, 2015

What are the top 10 most popular events?

Antonie faz fan · Feb 23, 2015

JemFish said:
What are the top 10 most popular events?

You can view that on the wca website at statistics.

JemFish · Feb 23, 2015

Antonie faz fan said:
You can view that on the wca website at statistics.

Where, I can't find it. Link please.

Odd WCA stats/ Stats request Thread

Legend

Legend

Veteran

Premium Member

Premium Member

Platinum Member

Legend

Premium Member

Veteran

Legend

Veteran

Legend

Veteran

Veteran

Veteran

Legend

Veteran

Veteran

Veteran

Veteran

Similar threads