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

Syntax:

QUARTILE.EXC(Range, n)

Description:

This returns one of the quartiles of a data set, based on a percentile range from 0 to 1 (exclusive).

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

n determines which quartile is to be returned. 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, the function will return a #NUM! error value.

Example:

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

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

Note:

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