# 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:

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.

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