Return the minimum, quartiles, or maximum of a dataset.
Syntax
QUARTILE.INC(array, quart)Arguments
arrayrequired
The range of numeric values.
quartrequired
0 for min, 1 for Q1, 2 for median, 3 for Q3, 4 for max.
QUARTILE.INC returns one of five cut points from a dataset: minimum, first quartile, median, third quartile, or maximum. It is a convenient wrapper around percentile-style distribution analysis.
=QUARTILE.INC(A2:A100, 3)→88Returns the third quartile.
Select the values
Use the dataset you want to split into quartiles.
Choose quart
Use 1, 2, or 3 for the common quartile cut points.
Yes. QUARTILE.INC(array, 2) returns the median of the dataset.