# PERCENTRANK

Formulas / PERCENTRANK
Calculate the percentile rank of a value in a data set.
`=PERCENTRANK(array, x, [significance])`
• array - range of data defining relative standing
• x - value to find its rank in
• significance - [OPTIONAL] parameter used to determine the number of significant digits to round the result

## Examples

• `=PERCENTRANK(A2:A11,2)`

PERCENTRANK is a Sourcetable function used to calculate the rank of a value in a dataset relative to other values in the same dataset. In the example given, , the function will return the percent rank of the value 2 within the range A2:A11. This means that 2 is ranked at what percent of the values in the range A2:A11. This function is useful for finding the rank of a number within a dataset without having to manually calculate it.

• `=PERCENTRANK(A2:A11,4)`

The PERCENTRANK function can also be used to find the relative rank of multiple values within a dataset. For example, this will return the percent rank of the value 4 within the range A2:A11.

• The PERCENTRANK function can also be used to compare the relative rank of different values within a dataset.

## Summary

The PERCENTRANK function is used to measure the relative standing of a value in a data set as a percentage. It can be used to compare the rank of a value with other values in the data set and new functions can provide improved accuracy.

• The PERCENTRANK function returns a calculated rank as a decimal value, and is commonly used to interpret a value's standing in standardized tests.
• The array and x arguments are both required, while the significance argument is optional.