a

a

Finding Middle Ranks using Rank Transformation

Many times we come across scenario ( Mostly in Interview ;-) ) we need to find middle ranks and not top or bottom  using rank transformation

lets say My data is like below

B 201
A 100
C 300
D 400
E 500
F 600
G 700
H 800
I 900

I want to find 6th and 5th highest salaries from above ? How to get it .

Answer :
We can use 2 tank transformations and do it

as below


First get bottom 6 in first rank Tns.
Pass them  to another Rank and get top 2 from them
And you are done you will get 6th and 5th highest