## Introduction

This article describes how to go from a numeric table...

...to a table with **Average Rank** added to it:

## Method

1. Select your table.

2. In the toolbar go to **Automate > Browse Online Library > Modify Tables or Plots > Show Average Rank**.

3. OPTIONAL: Tick **Reverse ranking (highest score is given a rank of 1)** if appropriate.

4. Set **Treatment of ties** to either **Average rank** or **Highest rank **to break ties.

5. 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*.

## Comments

0 comments

Article is closed for comments.