next up previous contents index
Next: PERCENTRANK Up: A Function Reference Previous: OR

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


next up previous contents index
Next: PERCENTRANK Up: A Function Reference Previous: OR

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999