Using the Excel QUARTILE.EXC Function
SummaryThe 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)
Required. An array or range of cells consisting of numeric values for which you want to fine the quartile.
Required. Indicates which value to return. The function will truncate entries that are not an integer. The options for this argument are as follows:
|1||First quartile - 25th percentile|
|2||Median value - 50th percentile|
|3||Third quartile - 75th percentile|
Usage NotesQUARTILE.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.
1) #NUM! error if array is empty;
2) #NUM! error if quart <= 0 or if quart >= 4