Check Sheet Logo
Check Sheet

RANK.AVG

RANK.AVG is a statistical function that returns the rank of a specified value within a dataset. The rank is determined by comparing the value to the other values in the dataset. This function is commonly used to determine the relative position of a value within a range of values.

Usage

Use the RANK.AVG formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:

=RANK.AVG(value, data, [is_ascending])
Parameters:
  1. value (required):
    The value whose rank is to be determined.
  2. data (required):
    The range or array of values to be ranked.
  3. is_ascending (optional):
    An optional boolean value that specifies whether the ranking should be in ascending order or not. The default value is TRUE, which means the ranking will be in ascending order.

Examples

Here are a few example use cases that explain how to use the RANK.AVG formula in Google Sheets.

Ranking students

A teacher can use RANK.AVG to rank the grades of students in a class. This makes it easy to determine which students are doing well and which students need extra help.

Ranking sales

A business owner can use RANK.AVG to rank the sales of their products. This helps them to identify which products are selling well and which products need to be improved or discontinued.

Determining relative position

A researcher can use RANK.AVG to determine the relative position of a data point within a larger dataset. This can help them to identify outliers or unusual patterns in the data.

Common Mistakes

RANK.AVG not working? Here are some common mistakes people make when using the RANK.AVG Google Sheets Formula:

Not providing a range for the data parameter

One common mistake is to provide a single value for the data parameter instead of a range of values. This will result in an error.

Providing a range that includes non-numeric values

If the range provided to the function includes non-numeric values, the function will return an error.

The following functions are similar to RANK.AVG or are often used with it in a formula:

  • RANK

    The RANK function returns the rank of a specified value within a dataset. The rank of a value is its size relative to other values in the dataset. The function can be used to determine the rank of a single value or an entire dataset. The rank can be calculated in ascending or descending order. This function is commonly used in data analysis to determine the relative position of a value within a set of values.

  • RANK.EQ

    The RANK.EQ function returns the rank of a specified value in a list of numbers. The rank of a number is its size relative to other values in the list. It is often used to determine the relative standing of values in a dataset. The function can be used to rank values in ascending or descending order, and can handle ties in several ways.

  • PERCENTRANK

    The PERCENTRANK formula in Google Sheets returns the percentage rank of a specified value within a dataset. It calculates the percentage of values in a given range that are less than or equal to the specified value. This formula is commonly used in statistical analysis to determine the relative standing of a particular value within a dataset.

  • PERCENTRANK.INC

    The PERCENTRANK.INC function calculates the rank of a value in a dataset as a percentage between 0 and 1, inclusive. This function is commonly used in statistical analysis to determine the relative standing of a value within a dataset.

  • PERCENTRANK.EXC

    The PERCENTRANK.EXC function returns the rank of a specified value in a dataset as a percentage between 0 and 1, exclusive. This is commonly used in statistics to determine the relative standing of a value within a dataset. The function takes three arguments: the dataset as a range or array, the value whose rank is being calculated, and an optional number of significant digits to use in the calculation. If the significant_digits parameter is omitted, the default value of 3 is used.

Learn More

You can learn more about the RANK.AVG Google Sheets function on Google Support.