How do you rank in groups?
There is a formula to quickly rank values based on group. Select a blank cell next to the data, C2 for instance, type this formula, =SUMPRODUCT(($A$2:$A$11=A2)*(B2<$B$2:$B$11))+1 then drag autofill handle down to apply this formula to the cells you need.
What is the difference between rank and rank EQ?
RANK. EQ gives duplicate numbers the same rank. However, the presence of duplicate numbers affects the ranks of subsequent numbers. For example, in a list of integers sorted in ascending order, if the number 10 appears twice and has a rank of 5, then 11 would have a rank of 7 (no number would have a rank of 6).
How to see if two groups rankings differ?
” The objective is to see if the two groups rankings differ “, Peter Flom. The ranks are different if, any item i ∈ { 1, 2, …, 25 }, there exists i such that a i ≠ b i, where a i is the rank of of item i by group a and b i is the rank of the same item but by group b. Else, the ranks are not different.
How to compare Group 1 to Group 2?
But the rankings in group 1 and group 2 will differ; that is, group 1 may rank item 1 higher than group 2 does. I could compare them, item by item, getting mean or median rank of each item and doing 25 tests, but i wondered if there was some better way to do this.
How are the ranks of an item different?
The ranks are different if, any item i ∈ { 1, 2, …, 25 }, there exists i such that a i ≠ b i, where a i is the rank of of item i by group a and b i is the rank of the same item but by group b. Else, the ranks are not different.
Is there a way to compare ranked lists?
One solution here is simply to measure the minimum edit distance. I.e. what are the minimum number of edits that need to be performed on the ranked list of group a such that it becomes identical to that of group b. An edit could be defined as swapping two items, and costs costs n points depending how many hops are needed.