This article describes how to go from a numeric table...
...to a table with Average Rank added to it:
Requirements
A table showing averages.
Method
- Select your table.
- Go to Data > Rules in the object inspector.
- Select Plus (+) > Calculation > Add Rank Column.
- OPTIONAL: Tick Reverse ranking (highest score is given a rank of 1) if appropriate.
- Set Treatment of ties to either Average rank or Highest rank to break ties.
- Press OK.
Please note the following:
- By default, the highest value is given the highest rank. For example, if there are 6 items, the value with the highest value is given a rank of 6, even if all the other values are missing. If Reverse ranking (highest score is given a rank of 1) is checked, the highest value is instead given a value of 1.
- Where Treatment of ties is set to Average rank, tied values are assigned the average rank. For example, if there are 6 items, and three of them share the highest value, they will be given a rank of 5 (i.e., (4 + 5 + 6) / 3).
- Where Treatment of ties is set to Highest rank, the highest possible value is set. For example, if there are 6 items, and three share the highest value, they are all assigned a value of 6, unless Reverse ranking (highest score is given a rank of 1) is checked, in which case they are assigned a value of 1.
- Where Treatment of ties is set to Average rank and Reverse ranking (highest score is given a rank of 1) is checked, this corresponds to the Excel function RANK.AVG.
- Where Treatment of ties is set to Highest rank and Reverse ranking (highest score is given a rank of 1) is checked, this corresponds to the deprecated Excel function RANK.
- NETs are given ranks of NaN.
Next
UPCOMING WEBINAR: 10 Market Research Predictions Over the Next 4 Years