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

## Usage

Use the `PERCENTRANK.INC` formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:

Parameters:
1. data (required):
The array or range of cells representing the dataset that the value will be ranked against.
2. value (required):
The value to be ranked within the dataset.
3. significant_digits (optional):
An optional parameter that specifies the number of significant digits to use in the calculated result. If omitted, the default value is 3.

## Examples

Here are a few example use cases that explain how to use the `PERCENTRANK.INC` formula in Google Sheets.

### Calculate percentile rank of a value in a dataset

Use `PERCENTRANK.INC` to determine the percentile rank of a given value in a dataset. This can be useful for analyzing the distribution of data and identifying outliers.

### Rank students based on test scores

Use `PERCENTRANK.INC` to rank students based on their test scores. This can be useful for identifying the highest and lowest performing students in a class.

### Analyze sales performance by region

Use `PERCENTRANK.INC` to analyze sales performance by region. This can be useful for identifying regions with the highest sales and identifying areas for improvement.

## Common Mistakes

`PERCENTRANK.INC` not working? Here are some common mistakes people make when using the `PERCENTRANK.INC` Google Sheets Formula:

### Using an incorrect range

One common mistake when using the `PERCENTRANK.INC` function is selecting an incorrect range of values. Make sure the range includes all of the values you want to analyze, and that the range is properly formatted with commas separating values and semicolons separating rows.

### Omitting the value parameter

The `PERCENTRANK.INC` function requires two parameters: the dataset to be analyzed and the value for which you want to determine the percentage rank. Forgetting to include the value parameter will result in an error.

### Using a sample instead of a population

The `PERCENTRANK.INC` function assumes that the supplied dataset represents the entire population, rather than a sample. If you are working with a sample, you should use the `PERCENTRANK.EXC` function instead.

The following functions are similar to `PERCENTRANK.INC` or are often used with it in a formula:

• `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.

• `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.

• `PERCENTILE.INC`

The `PERCENTILE.INC` function returns the k-th percentile of a dataset, where k is a value between 0 and 1, inclusive. It returns an interpolated value if the percentile falls between two data points. This function is commonly used in statistical analysis.

• `QUARTILE.INC`

The `QUARTILE.INC` function calculates the quartile of a dataset, which is a measure of statistical dispersion. It is commonly used to split a dataset into four equal parts, each containing 25% of the data points. The function takes in two parameters - the dataset as `data` and the quartile number as `quartile_number` - and returns the value of the specified quartile. Quartile numbers are specified as follows: 1 for the first quartile (25th percentile), 2 for the second quartile (50th percentile, or median), and 3 for the third quartile (75th percentile).

• `AVERAGE`

The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

You can learn more about the `PERCENTRANK.INC` Google Sheets function on Google Support.