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

Syntax:

PERCENTILE.INC(Range, k)

Description:

This 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 desired percentage. This must be within the range from 0 to 1 (inclusive) with 0=0% and 1=100%.

Example:

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

PERCENTILE.INC(A1:A9, 0.75) returns 7

Note:

The PERCENTILE.INC and PERCENTILE.EXC functions supplement 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. The function is unknown in older versions.