QUARTILE.EXC

Using the Excel QUARTILE.EXC Function

Summary

The Excel QUARTILE.EXC function returns the quartile of a given data set based on percentile values from 0 to 1, exclusive. A quartile is often used to divide populations into groups. For example, to find the top 20% of students in a class, the top 5% of runners in a state, etc.

QUARTILE.EXC, along with QUARTILE.INC, is an improved version of the QUARTILE function. While QUARTILE is still available as a compatibility function, Microsoft recommends using QUARTILE.EXC and QUARTILE.INC.


Syntax

=QUARTILE.EXC (array, quart)

Syntax Breakdown

Array
Required. An array or range of cells consisting of numeric values for which you want to fine the quartile.

Quart
Required. Indicates which value to return. The function will truncate entries that are not an integer. The options for this argument are as follows:

Quart Value
1 First quartile - 25th percentile
2 Median value - 50th percentile
3 Third quartile - 75th percentile


Usage Notes

QUARTILE.EXC returns the quartile for a given set of data based on percentile values ranging from 0 to 1, exclusive. The function can return the first quartile, second quartile, and third quartile.

Error Values

1) #NUM! error if array is empty;

2) #NUM! error if quart <= 0 or if quart >= 4