Manuals/calci/PERCENTRANK

PERCENTRANK (Array,Number,Significance)

• $Array$ is the set of data and $Number$ 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 :$PR\%={\frac {L+(0.5*S)}{N}}$

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

• In $PERCENTRANK(Array,Number,Significance)$, $Array$ is the array of numeric values and $Number$ 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	E
1	3	4	1	2	1

=PERCENTRANK(A1:E1,2) = 0.5

2.

Spreadsheet

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

=PERCENTRANK(A1:F1,3) = 0.267

Related Videos

PERCENTRANK

See Also

• MAX
• MIN
• MEDIAN
• QUARTILE
• PERCENTILE

References

Percentile Rank

• List of Main Z Functions

• Z3 home