I. Intro
The RANK.AVG function returns the average rank of the specified value in the data set.
To use this function, enter =RANK.AVG in a cell, or click Menu > Data > Formulas > Statistical > RANK.AVG in the toolbar. Enter the arguments and press Enter.
II. About the function
- Formula: =RANK.AVG(value, data, [is_ascending])
- Arguments:
- value (required): The value for which you would like to determine the rank.
- data (required): The data set, that is, the array or reference to be evaluated.
- is_ascending (optional): Whether the "value" in the data set is ranked in ascending or descending order. Enter 0 or omit this for descending order; Enter 1 for ascending order. If identical values are in the data set, the average rank of these values is returned.
Example | Description |
250px|700px|reset | The same formula except the last argument is applied to the same set of data, so one example shows the ranks in descending and another in ascending order. |
250px|700px|reset | |
250px|700px|reset | In this example, this data set with duplicate values is ranked in descending order (the third argument is omitted, so it's in descending order). The two 30s are in 3rd and 4th positions, so their rank is the average of 3 and 4, which is 3.5. |