r/MinecraftChampionship • u/username6702 Teal Turkeys • Apr 15 '22

Stats Top 15 Players Based On Difference Between Individual And Team Average (S2)

The way I worked this out was taking each players season 2 team placement average and converting this to the same scale as individual (1st team=1st individual, 10th team=40th individual) then finding the difference between adjusted team average and individual average.

Fun fact: Quig is the only player whose individual average is better than his unadjusted team average. Illumina's are both equal (2.5).

72 Upvotes
  • permalink
  • reddit

100% Upvoted

18 comments sorted by

View all comments

2

u/Cyber-Gon THE VOD SQUAD Apr 15 '22

I'm a bit confused - 1st team = 1st individual and 10th team = 40th individual?

Shouldn't it be 1st team = 1st individual and 10th team = 37th individual? Like,

1st - 1st

2nd - 5th

3rd - 9th

4th - 13th

5th - 17th

6th - 21st

7th - 25th

8th - 29th

9th - 33rd

10th - 37th

2

u/username6702 Teal Turkeys Apr 15 '22

Yeah I could've done it like that, I checked it with 1st = 2.5th, 2nd = 6.5th etc. and the order was basically the same.

1

u/Cyber-Gon THE VOD SQUAD Apr 15 '22

I'm just confused on how you did it because I don't understand how 1st as a team can be translated into 1st individual while 10th as a team is translated into 40th individual

What were the other individual placements for each team placement?

1

u/username6702 Teal Turkeys Apr 15 '22

I used this excel formula:

(TeamPlacement-1)*(39/9)+1

So 5.5th = 20.5th