# Manuals/calci/PERCENTRANK

Jump to navigation
Jump to search

**PERCENTRANK (Array,Number,Significance)**

- is the set of data and is the value to find the rank.
- PERCENTRANK(),returns the percentage rank of a value in a data set.

## Description

- This function gives the percentage rank of a value in a given set of numbers.
- To calculate the relative standing of a data set we can use this function.
- For example, a test score that is greater than or equal to 50% of the scores of people taking the test is said to be at the 50th percentile rank.
- Percentile ranks are commonly used to clarify the interpretation of scores on standardized tests.
- To find the percentile rank of a score is :

Where, = Number of below rank, = Number of same rank, = Total numbers.

- In , is the array of numeric values and is the value to find the rank.
- This function gives the result as error when array is empty .

## Examples

1.

A | B | C | D | E | |
---|---|---|---|---|---|

1 | 3 | 4 | 1 | 2 | 1 |

=PERCENTRANK(A1:E1,2) = 0.5

2.

A | B | C | D | E | F | |
---|---|---|---|---|---|---|

1 | 7 | 6 | 2 | 5 | 9 | 1 |

=PERCENTRANK(A1:F1,3) = 0.267

## Related Videos

## See Also

## References