PERCENTRANK(ar,x)
- is the array data and is the value
is the array data and 
is the valueDescription
- 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