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.

Spreadsheet

	A	B	C	D
1	3	4	1	2	1

=PERCENTRANK(A1:A5,2) = 0.5

2.

Spreadsheet

	A	B	C	D	E	F
1	7	6	2	5	9	1

=PERCENTRANK(B1:B6,3) = 0.267

See Also

• MAX
• MIN
• MEDIAN
• QUARTILE
• PERCENTILE

References

Percentile Rank