PERCENTILE (percentiles of a data set)

<< Click to Display Table of Contents >>

PERCENTILE (percentiles of a data set)

Note: PERCENTILE is supplemented by the new identical function PERCENTILE.INC and the completely new function PERCENTILE.EXC, which are available in newer versions of Microsoft Excel (2010 or later).

Syntax:

PERCENTILE(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(A1:A9, 0.75) returns 7

See also:

PERCENTILE.INC/PERCENTILE.EXC, QUARTILE.EXC/QUARTILE.INC/QUARTILE, PERCENTRANK.EXC/PERCENTRANK.INC/PERCENTRANK, MEDIAN, MODE.SNGL/MODE, RANK.EQ/RANK.AVG/RANK