Manuals/calci/PERCENTRANK

PERCENTRANK(ar,x)

• $ar$ is the array data and $x$ is the value

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 :$PR\%={\frac {L+(0.5*S)}{N}}$

Where, L = Number of below rank, S = Number of same rank, N = Total numbers.

• In PERCENTRANK(ar,x),ar is the array of numeric values and x is the value to find the rank. This function gives the result as error when array is empty .

Examples

1. 3

4 1 2 1 PERCENTRANK(A1:A5,2)=0.5

1. 7

6 2 5 9 1 PERCENTRANK(B1:B6,3)=0.267

See Also

• MAX
• MIN
• MEDIAN
• QUARTILE
• PERCENTILE