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 *N*th 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

Grey Trout Software

02 March 2003