Jump to navigation Jump to search
- 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.
- 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 .
=PERCENTRANK(A1:E1,2) = 0.5
=PERCENTRANK(A1:F1,3) = 0.267