ID EN
#Statistical

QUARTILE

Excel Functions

Get the quartile in a data set

Syntax

EXCEL
=QUARTILE(array, quart)

Arguments

Parameter Description
array A reference containing data to analyze.
quart The quartile value to return.

Return Value

Value for requested quartile

Details

Use the QUARTILE function to get the quartile for a given set of data. QUARTILE takes two arguments, the array containing numeric data to analyze, andquart, indicating which quartile value to return. The QUARTILE function accepts 5 values for the quart argument, as shown in the table below.

See Also

MIN MAX MEDIAN