How to use the Excel QUARTILE function

Summary

The Excel QUARTILE function returns the quartile (each of four equal groups) for a given set of data. QUARTILE can return minimum value, first quartile, second quartile, third quartile, and max value.

Purpose

Get the quartile in a data set

Return value

Value for requested quartile

Syntax

=QUARTILE (array, quart)

Arguments

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

Usage notes

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, and quart, indicating which quartile value to return. The QUARTILE function accepts 5 values for the quart argument, as shown the in the table below.

Quart	Return value
0	Min value
1	First quartile – 25th percentile
2	Median value – 50th percentile
3	Third quartile – 75th percentile
4	Max value

Related functions

Excel MIN Function

The Excel MIN function returns the smallest numeric value in a range of values. The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.

Excel MAX Function

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values.

Excel MEDIAN Function

The MEDIAN function returns the median (middle number) in a group of supplied numbers. For example, =MEDIAN(1,2,3,4,5) returns 3.

Good links

Microsoft QUARTILE function documentation

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.