Averaging Rankings?

Is it simply adding the ranks and dividing by 3 then sort ascending to achieve an average ranking order (assuming equal weight) How can you break ties?

3 separate columns contain rankings

Col 1 col 2 col 3

9th 2nd 2nd

8th 1st 1st = 3.33

1st 8th 5th

3rd 4th 3rd = 3.33

7th 9th 8th

6th 3rd 5th

5th 6th 5th

2nd 4th 4th = 3.33

4th 7th 8th

Quote: Arnie

Is it simply adding the ranks and dividing by 3 then sort ascending to achieve an average ranking order (assuming equal weight) How can you break ties?

yep, that is how you do an average. Breaking a tie would be up to you. I personally would break it by highest rank.

1-1-8 > 3-3-4

Quote: GWAE

yep, that is how you do an average. Breaking a tie would be up to you. I personally would break it by highest rank.

1-1-8 > 3-3-4

Thank you


Also what would your opinion be on this?

Anyone of the top 3 in column one who are also in the top 2 in either columns two or three BUT beyond that, what is the best way to rank the remaining using that logic. In the example below Arnie and Gwae qualify below that Mr. C is in top 3 but not in top 2 of the others. Same as Mr. D

For example

Arnie - 1 / 2 / 5

Gwae- 3 / 1 / 7

-------------------------------------
using same logic as above example, is there a way to rank the following who do not qualify ??

Mr. A -7 / 7 / 1

Mr. B - 5 / 3 / 4

Mr C - 2 / 5 / 3

Mr. D - 3 / 3 / 6

Mr. E - 7 / 6 / 2

Do you mean a opposed to an average? The average would be different for the 2.

Yes as opposed to the average

I've been averaging but only adding column one with the better of the other two columns since column one most important

Just wondering if better way

This is one way of doing it, and if all you have is the rankings themselves (as opposed to the values used to determine the rankings), then this is the only way to do it, but it's not necessarily accurate.

For example, let the three ranks be in order of wins in a particular sports league in the first 1/3, the second 1/3, and the final 1/3 of the season. (Let's assume baseball, which has 162 games, which we can break up into three groups of 54 games each.)
Los Angeles has 35 wins in each of the first two groups, and 40 in the third.
New York has 32 wins in each of the first two groups, and 45 in the third.
Assume no other team has at least 32 wins in any group.
Based solely on rankings, Los Angeles is first, first, second, so its average is 1 1/3, and New York is second, second, first, so its average is 1 2/3.
However, New York has 111 total wins, while Los Angeles only has 110.

Quote: ThatDonGuy

This is one way of doing it, and if all you have is the rankings themselves (as opposed to the values used to determine the rankings), then this is the only way to do it, but it's not necessarily accurate.

For example, let the three ranks be in order of wins in a particular sports league in the first 1/3, the second 1/3, and the final 1/3 of the season. (Let's assume baseball, which has 162 games, which we can break up into three groups of 54 games each.)
Los Angeles has 35 wins in each of the first two groups, and 40 in the third.
New York has 32 wins in each of the first two groups, and 45 in the third.
Assume no other team has at least 32 wins in any group.
Based solely on rankings, Los Angeles is first, first, second, so its average is 1 1/3, and New York is second, second, first, so its average is 1 2/3.
However, New York has 111 total wins, while Los Angeles only has 110.

I do have ratings. Let pretend its horse racing ;) I have 3 speed ratings representing various combinations of pacelines

How would you rank these based on the following data (lets assume equal weight for now)

2 - 61 / 38 / 64

3 - 65 / 73 / 50

4 - 66 / 64 / 42

5 - 67 / 58 / 51

6 - 44 / 42 / 58

7 - 71 / 82 / 45

8 - 66 / 84 / 31