Using the Excel QUARTILE.INC Function
SummaryThe Excel QUARTILE.INC function returns the quartile of a given data set based on percentile values from 0 to 1, inclusive. 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.INC, along with QUARTILE.EXC, 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.INC (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.INC returns the quartile for a given set of data based on percentile values ranging from 0 to 1, inclusive. The function can return the minimum value, first quartile, second quartile, third quartile, and maximum value.
1) #NUM! error if array is empty;
2) #NUM! error if quart < 0 or if quart > 4