# Documentation/Calc Functions/PERCENTRANK

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

PERCENTRANK

## Category:

Statistical Analysis

## Summary:

Calculates the percentage rank of a value in a data set. The percentage rank of a value is the relative position of that value in a data set, expressed as a percentage in the range 0 to 1. In other words, it is the percentage of values in the data set that are equal to or less than itself. For example, the percentage rank of the smallest number in the data set will be 0 and that of the largest number will be 1.

## Syntax:

PERCENTRANK(**Data**; **Value**[; **Significance**])

## Returns:

Returns a real number in the range 0 to 1 (inclusive) to the specified precision, which is the percentage rank of the specified value in the specified data set.

## Arguments:

**Data** is an array or a reference to the range of cells that represents the array of data.

**Value** is a real number or a reference to the cell containing that number which represents the value whose percentile rank must be determined.

**Significance** is an integer value or a reference to the cell containing that number which specifies the number of significant digits that the returned percentage value is rounded to. If omitted, a value of 3 is used by default.

- If the
**Value**is not available in the**Data**then the function interpolates to give the correct percentage rank. However, if the**Value**falls outside the range of**Data**then the function returns a value (#VALUE!) error. - If
**Significance**is not an integer value then the function uses the floor of that value, i.e. it is truncated to an integer. However, if the value is less than 1 then the function returns an error value.

## Additional details:

- For more details on percentage rank, visit Wikiepdia.

## Examples:

Formula | Description | Returns |
---|---|---|

=PERCENTRANK(A1:A5;7;4) where A1:A5 contains 5,7,3,2,9 | The function calculates the rank of a value in a data set Data as a percentage of the data set in A1:A5. |
0.75 |

=PERCENTRANK(A1:A5;6;2) where A1:A5 contains 5,7,3,2,9 | The function calculates the interpolated value to give the correct percentage rank of the data set in A1:A5 since 6 is not available in the dataset. | 0.63 |

=PERCENTRANK(A1:A5;11;2) where A1:A5 contains 5,7,3,2,9 | The function returns a value error since 11 falls outside the total range of the data set in A1:A5. | #VALUE! |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

PERCENTRANK