3
$\begingroup$

I have two sets of ranked data which are ranked on different scales, one fixed and one variable, and I would like to convert one of the data sets ranking values to match the other.

Set 1 is ranked 10 - 1 with 10 being the highest rank. Set 2 is ranked 1 - x with 1 being the highest rank and x being the number of items in the set.

Is it possible to convert the ranking of set 2 to fit into set 1?

Thanks, Phil

  • 0
    This isn't my subject area so didn't really know which category this fit into. Apologies if it caused confusion.2011-01-18

1 Answers 1

1

You can take the rank of an item of rank $r_1$ in set 1 and set $r_2=\frac{(x-1)(10-r_1)}{9}+1$. This will linearly map the set 1 ranks into the range of set 2. Is this what you are looking for?

This presumes that the items in the two sets should be "evenly mixed", which may not be what you want. Maybe all the items of set 1 should be ranked above all the items in set 2. It also runs the risk of having two items with the same rank, particularly 1 and x.