Hssandwich
Veteran
Jong Ho?
Odd WCA stats/ Stats request Thread
- Thread starter anders
- Start date
Sergeant Baboon
Regular
Singles:
Average:
BOSSCUBER666
Member
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)
Mollerz
Swag Overlord
BOSSCUBER666
Member
oh ok thank you could you make a list of the rankings if possible?
YouCubing
Veteran
Average standard deviation of PB averages? (3x3)
EvilGnome6
Premium Member
Could I get a ranked list for the number of people who have competed in each WCA event?
Kit Clement
Premium Member
- Joined
- Aug 25, 2008
- Messages
- 1,626
- Location
- Champaign, IL, USA
- WCA ID
- 2008CLEM01
- YouTube
- Visit Channel
Not for all events, but the top 10 is under "Most Persons" here: https://www.worldcubeassociation.org/results/statistics.php
Sergeant Baboon
Regular
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.
EvilGnome6
Premium Member
Ah, that's useful. Thanks!
willtri4
Veteran
Fastest debut sq1 average?
vcuber13
Veteran
JustinTimeCuber
Legend
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
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
penguinz7
Veteran
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
CyanSandwich
Veteran
- Joined
- Oct 4, 2012
- Messages
- 1,615
- Location
- Wellington, New Zealand
- WCA ID
- 2013NELS01
- YouTube
- Visit Channel
^ He meant top 5 results, not persons. So MBLD for example would be (41), 36, 35, 32, (32) = 34.33
penguinz7
Veteran
Well, dang it..
I'm too lazy/tired too redo. If no one does it by tomorrow I will
penguinz7
Veteran
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
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
Sergeant Baboon
Regular
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]."Sergeant Baboon
Regular
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.
- 3x3: 43187
- 2x2: 24007
- 4x4: 13930
- OH: 12778
- Pyra: 12732
- 5x5: 7581
- Magic: 4938
- Skewb: 4652
- Minx: 4546
- 3BLD: 4530
- FMC: 3485
- Sq1: 2704
- 6x6: 2662
- 7x7: 2460
- Clock: 2434
- Master Magic: 2081
- MBLD: 1882 (1695 new format, 187 old format)
- Feet: 1323
- 4BLD: 648
- 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."
endAntonie faz fan
Veteran
Does this include any podium in any event? Or is this only 3x3?
edit:
I think I have a 1.15, though I'd like to see this stat also to verify. How many people have a 1? That is impressive
yeah every event
Similar threads
- Deleted member 36445
- General Speedcubing Discussion
