PatrickJameson
Premium Member
My original reason for doing this was to see if there was a significant spike of success rates near when the paper regulation was put in place. Unfortunately there's insufficient data to prove or disprove my hypothesis. But I thought meh, why not publish the stats.
Although there is a significant drop in average success rate after February 2007 there's also a significant rise in number of attempts(which could be caused by the increase in talk about blindfolded solving during that time).
One interesting stat is that from 2007-2011 the success rate was pretty consistent at ~29.7±1.
Here's the stats I gathered in case anyone wants them for whatever reason.
Per year:
Per Month:
Script:
From http://www.worldcubeassociation.org/results/misc/export.html:
Although there is a significant drop in average success rate after February 2007 there's also a significant rise in number of attempts(which could be caused by the increase in talk about blindfolded solving during that time).
One interesting stat is that from 2007-2011 the success rate was pretty consistent at ~29.7±1.
Here's the stats I gathered in case anyone wants them for whatever reason.
Per year:
Code:
Year Total Percent Solved
2003 3 66.6666666666667
2004 61 29.5081967213115
2005 254 37.4015748031496
2006 678 34.070796460177
2007 1412 30.7365439093484
2008 3647 29.9972580202907
2009 5155 28.8069835111542
2010 7397 28.7143436528322
2011 1725 27.4782608695652Per Month:
Code:
Year Month Total Percent Solved
2003 8 3 66.6666666666667
2004 4 2 50
2004 7 9 66.6666666666667
2004 8 20 20
2004 10 30 23.3333333333333
2005 1 6 50
2005 4 26 46.1538461538462
2005 5 6 66.6666666666667
2005 6 2 50
2005 8 27 29.6296296296296
2005 9 20 50
2005 10 71 28.169014084507
2005 11 72 38.8888888888889
2005 12 24 37.5
2006 1 33 30.3030303030303
2006 3 32 40.625
2006 4 123 27.6422764227642
2006 5 47 36.1702127659575
2006 7 41 29.2682926829268
2006 8 95 38.9473684210526
2006 9 90 36.6666666666667
2006 10 75 38.6666666666667
2006 11 142 32.3943661971831
2007 1 54 27.7777777777778
2007 2 42 33.3333333333333
2007 3 66 36.3636363636364
2007 4 161 27.9503105590062
2007 5 174 28.1609195402299
2007 6 51 41.1764705882353
2007 7 72 22.2222222222222
2007 8 136 27.2058823529412
2007 9 122 27.8688524590164
2007 10 211 39.8104265402844
2007 11 212 28.3018867924528
2007 12 111 31.5315315315315
2008 1 126 23.8095238095238
2008 2 244 35.655737704918
2008 3 278 28.7769784172662
2008 4 451 29.9334811529933
2008 5 387 31.0077519379845
2008 6 138 24.6376811594203
2008 7 470 28.936170212766
2008 8 288 28.125
2008 9 244 27.4590163934426
2008 10 408 36.0294117647059
2008 11 391 31.2020460358056
2008 12 222 24.7747747747748
2009 1 255 30.5882352941176
2009 2 558 27.9569892473118
2009 3 309 25.2427184466019
2009 4 462 27.0562770562771
2009 5 452 28.7610619469027
2009 6 272 31.25
2009 7 384 22.1354166666667
2009 8 692 30.0578034682081
2009 9 383 27.9373368146214
2009 10 603 34.8258706467662
2009 11 435 29.1954022988506
2009 12 350 27.4285714285714
2010 1 515 32.2330097087379
2010 2 685 26.1313868613139
2010 3 334 30.2395209580838
2010 4 578 27.3356401384083
2010 5 453 23.3995584988962
2010 6 337 32.0474777448071
2010 7 795 30.062893081761
2010 8 899 28.0311457174639
2010 9 679 28.4241531664212
2010 10 972 32.9218106995885
2010 11 609 26.2725779967159
2010 12 541 26.2476894639556
2011 1 632 28.9556962025316
2011 2 835 25.8682634730539
2011 3 258 29.0697674418605Script:
Code:
#!/usr/bin/perl -w
use strict;
use warnings;
open FH, "data/WCA_export_Competitions.tsv";
my @rawComps = <FH>;
close FH;
my @fieldNames = split /\t/, $rawComps[0];
shift(@rawComps);
my %compInfo;
foreach my $line (@rawComps) {
my @curLine = split /\t/, $line;
for (my $i = 0;$i < $#curLine;$i++) {
$compInfo{$curLine[0]}{$fieldNames[$i]} = $curLine[$i];
}
}
open FH, "data/WCA_export_Results.tsv";
my @rawEvents = <FH>;
close FH;
shift(@rawEvents);
my (@eventInfo, %solved, %attempts);
foreach my $line (@rawEvents) {
my @eventInfo = split /\t/, $line;
if ($eventInfo[1] eq '333bf') {
for my $solveNum (10 .. 14) {
my $year = $compInfo{$eventInfo[0]}{'year'};
my $month = $compInfo{$eventInfo[0]}{'month'}-1;
if ($eventInfo[$solveNum] > 0) {
$solved{$year}[$month]++;
$attempts{$year}[$month]++;
} elsif ($eventInfo[$solveNum] < 0) {
$attempts{$year}[$month]++;
}
}
}
}
print "Year\tMonth\tTotal\tPercent Solved\n";
for my $key (sort keys %attempts) {
for my $month (0 .. 11) {
if (defined $attempts{$key}[$month]) {
print $key."\t".($month+1)."\t".$attempts{$key}[$month]."\t".(100*($solved{$key}[$month]/$attempts{$key}[$month]))."\n";
}
}
}From http://www.worldcubeassociation.org/results/misc/export.html:
Code:
Export of the World Cube Association results database
Date: March 11, 2011
Remarks: none
Contact: Ron van Bruchem Netherlands [email][email protected][/email]
Website: [url]http://www.worldcubeassociation.org/results[/url]
Description:
This file contains public information on all official WCA competitions,
WCA members and WCA competition results.
Goal:
Goal of this file is for members of our community to do analysis on the
information for statistical and personal purposes.
Allowed use: Information and parts of it may be published online,
but only under the following conditions:
- A clearly visible link to World Cube Association website is added
([url]http://www.worldcubeassociation.org[/url]) with the notification that
World Cube Association is the source and owner of the information.
- A clearly visible notification is added that the published information
is not actual information.
- A clearly visible link to [url]http://www.worldcubeassociation.org/results[/url] is
added with the notification that the actual information can be found via
that link.
- A clearly visible notification which date is taken for the source of the data.
- The style and format of the information must be clearly distinguishable
from the official WCA website
Software created by:
Clément Gallet France
Stefan Pochmann Germany
Josef Jelinek Czech Republic
Ron van Bruchem Netherlands
The export consists of these tables:
Persons WCA competitors
Competitions WCA competitions
Events WCA events (Rubik's Cube, Megaminx, etc)
Results WCA results per competition+event+round+person
Rounds The round types (first, final, etc)
Formats The round formats (best of 3, average of 5, etc)
Countries Countries according to [url]http://en.wikipedia.org/wiki/List_of_countries[/url]
Continents Continents
Most of the tables should be self-explanatory, but the result values of
the Results table need some explanation:
- The result values are in fields value1-value5, best and average.
- Value -1 means DNF
- Value -2 means DNS
- Value 0 means "nothing", for example a best-of-3 has value4=value5=average=0
- Positive values depend on the event, see column "format" in Events.
- Most events have format "time", where the value represents centiseconds.
For example, 8653 means 1 minute and 26.53 seconds.
- Format "number" means the value is a raw number, currently only used
by "fewest moves" for number of moves.
- Format "multi" is for old and new multi-blind, encoding not only the time
but also the number of attempted and solved cubes. Writing the value in
decimal it is interpreted like this:
old: 1SSAATTTTT
solved = 99 - SS
attempted = AA
timeInSeconds = TTTTT (99999 means unknown)
new: 0DDTTTTTMM
difference = 99 - DD
timeInSeconds = TTTTT (99999 means unknown)
missed = MM
solved = difference + missed
attempted = solved + missed
Note that this is designed so that a smaller value means a better result.
Last edited:
.
(agreeing with Mike here)
