next up previous contents index
Next: PERCENTRANK Up: A. Function Reference Previous: OR, XLOR   Contents   Index


PERCENTILE

Syntax: PERCENTILE(R, N)

R = A range of data
N = A numeric value between 0 and 1, inclusive

PERCENTILE returns the datum from the range R which is at the Nth percentile in R. Only numeric data in R are considered.

The result will be interpolated if N is not a multiple of 1/(s-1), where s is the size of R.

Examples:

PERCENTILE(A1..A4, 0.65) = 2.95, where A1..A4 = 1, 2, 3, 4

PERCENTILE(B1..B6, 0.75) = 21.35, where A1..A6 = 3.8, 23, 4, 12, 67, 0.2

Excel function: PERCENTILE


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