Formulas and functions > Functions from A to Z > PERCENTILE.EXC (percentiles of a data set)

Syntax:

PERCENTILE.EXC(Range, k)

Description:

Returns the k-th percentile of a data set.

For example, if k is 0.5, the 0.5 percentile (i.e., the median) will be returned.

Range is a range with numeric data – usually a reference to a cell range in which numbers are entered.

k is the percentile to be returned. Must be in the range 0 to 1 (exclusive) with 0=0% and 1=100%.

Example:

If A1:A9 contain the values 1, 2, 3, 4, 5, 6, 7, 8, 9:

PERCENTILE.EXC(A1:A9, 0.75) returns 7.5

Note:

The PERCENTILE.EXC function supplements, together with PERCENTILE.INC, the previous PERCENTILE function.

PERCENTILE.INC returns the same result as PERCENTILE (values 0 to 1 inclusive).

PERCENTILE.EXC (values 0 to 1 exclusive) is completely new.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.