PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values ​​0 and 1 in Excel

The following article introduces you to PERCENTRANK.INC - one of the functions in the group of statistical functions that is very popular in Excel.

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values ​​0 and 1 in Excel Picture 1

Description: The function returns the rank of a value in a dataset as a percentage including both values ​​0 and 1. The function supports Excel 2010 and later versions.

Syntax: PERCENTRANK.INC (array, x, [significance])

Inside:

- array: An array or range of data to determine percentile, which is a required parameter .

- x: The value you want to determine its rank in the dataset, is a required parameter.

- significance: The value determines the number of digits of the percentage value returned, which is an optional parameter, if omitted the default is 3 digits.

Attention:

- If array array value is empty -> the function returns the #NUM! Error value .

- If significance value <1 -> the function returns the #NUM! Error value

- If x does not match any value of the array -> interpolation function to determine the rank of the value.

For example:

Find the rank of the values ​​described in the data table below:

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values ​​0 and 1 in Excel Picture 2

- Calculate the rank of the value 12 in the array. In the cell to calculate enter the formula : = PERCENTRANK.INC (E6: K6, E7)

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values ​​0 and 1 in Excel Picture 3

- Press Enter -> rank of value 12 in the dataset is:

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values ​​0 and 1 in Excel Picture 4

- Calculate the rank of the value 26. In the cell to calculate enter the formula: = PERCENTRANK.INC (E6: K6, E8) -> press Enter -> rank is:

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values ​​0 and 1 in Excel Picture 5

Thus, the case with a rank of PERCENTRANK.INC is still calculated normally.

- Calculate the rank of the value 11. In the cell to calculate enter the formula: = PERCENTRANK.INC (E6: K6, E9) -> press Enter -> rank is:

PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values ​​0 and 1 in Excel Picture 6

In case the value 11 is not in the value array but it is in the range from 9 to 12 -> the function still calculates normally.

Above are instructions and some specific examples when using PERCENTRANK.INC function in Excel.

Good luck!