next up previous contents index
Next: PERMUT Up: A. Function Reference Previous: PERCENTILE   Contents   Index


PERCENTRANK

Syntax: PERCENTRANK(R, N)

R - A range of data
N - A number whose percentile rank to find

PERCENTRANK returns the percentile rank of the number N among the values in range R.

Examples:

PERCENTRANK(A1..A6, 4.5) = 0.7, where A1..A6 = 1, 2, 3, 4, 5, 6

PERCENTRANK(B1..B6, 21.35) = 0.77, where B1..B8 = 3.8, 23, 4, 12, 67, 0.2

Excel function: PERCENTRANK


next up previous contents index
Next: PERMUT Up: A. Function Reference Previous: PERCENTILE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003