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

Syntax:

QUARTILE.EXC(Range, n)

Description:

Returns one of the quartiles of a data set, based on a percentile range between 0 to 1 (exclusive).

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

n determines which quartile to return. The following values are permissible:

0: The minimum

1: The 1st quartile (25th percentile)

2: The 2nd quartile (50th percentile or median)

3: The 3rd quartile (75th percentile)

4: The maximum

If n is < 0 or > 4, a #NUM! error value will be returned.

Example:

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

QUARTILE.EXC(A1:A9, 3) is equivalent to PERCENTILE.EXC(A1:A9, 0.75), which returns 7.5

Note:

The QUARTILE.EXC function supplements together with QUARTILE.INC the previous QUARTILE function.

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

QUARTILE.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.