Give a 'weight' to a ranking.

[itzvenom95]

I have the following table.
I would like to know how to give an weight to the "12 Month Median Ranking of Opponent" so it changes other two columns depending on how high/low the ranking is.
To put this into perspective, this is regarding tennis players. On the spreadsheet I can have two players facing each other that have the same "12 Month Service Points Won" of 40%. Although Player A has a "12 Month Median Ranking of Opponent" of 300 and Player B of 100. Although the percentages are the same the player who managed to get a 40% "12 Month Service Points Won" against an "12 Month Median Ranking of Opponent" of 100 is extremely better than Player A that managed to get the same 40% against a "12 Month Median Ranking of Opponent" of 300.
I would like a formula to tackle this issue and give me "real" values.

Let me know if I wasn't clear on any of my explanation.

 

[Deleted member 4993]

I have the following table.
I would like to know how to give an weight to the "12 Month Median Ranking of Opponent" so it changes other two columns depending on how high/low the ranking is.
To put this into perspective, this is regarding tennis players. On the spreadsheet I can have two players facing each other that have the same "12 Month Service Points Won" of 40%. Although Player A has a "12 Month Median Ranking of Opponent" of 300 and Player B of 100. Although the percentages are the same the player who managed to get a 40% "12 Month Service Points Won" against an "12 Month Median Ranking of Opponent" of 100 is extremely better than Player A that managed to get the same 40% against a "12 Month Median Ranking of Opponent" of 300.
I would like a formula to tackle this issue and give me "real" values.
View attachment 25895
Let me know if I wasn't clear on any of my explanation.

Please show us what you have tried and exactly where you are stuck.

Please follow the rules of posting in this forum, as enunciated at:

READ BEFORE POSTING​

Please share your work/thoughts about this problem.

 

[itzvenom95]

Please show us what you have tried and exactly where you are stuck.

Please follow the rules of posting in this forum, as enunciated at:

READ BEFORE POSTING​

Please share your work/thoughts about this problem.
View attachment 25896

Hello Khan, I haven't tried anything as my math skills are not good enough to solve this issue, so I'm right at the beginning of trying to solve this.

 

[itzvenom95]

Here's another photo that might help with this problem.



I would like to come up with a formula that takes the ranking of opponent into account, giving more or less value to the other two columns.