How to use the Excel QUARTILE.EXC function

Summary

The Excel QUARTILE.EXC function returns the quartile for a given set of data. QUARTILE.EXC can return, first quartile, second quartile, and third quartile.

Purpose

Get the quartile in a data set

Return value

Value for requested quartile

Syntax

=QUARTILE.EXC (array, quart)

Arguments

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

Version

Excel 2010

Usage notes

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

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

QUARTILE.INC vs QUARTILE.EXC

Percentiles can be defined as "greater than or equal to" (inclusive) or "greater than" (exclusive). The QUARTILE.INC function is inclusive and has "greater than or equal to" behavior. QUARTILE.EXC is exclusive, and has "greater than" behavior. The screen below shows how QUARTILE.INC and QUARTILE.EXC return different results for the same data. Note QUARTILE.EXC cannot be used to get the minimum or maximum value like QUARTILE.INC.

QUARTILE.inc vs QUARTILE.exc

Note: Starting with Excel 2010, the QUARTILE.EXC and QUARTILE.INC functions replace the QUARTILE function, which is now classified as a compatibility function.

Related functions

Excel MIN Function

The Excel MIN function returns the smallest numeric value in the data provided. 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 the data provided. MAX ignores empty cells, the logical values TRUE and FALSE, and text values.

Excel MEDIAN Function

The Excel MEDIAN function returns the median (middle number) in the supplied set of data. For example, =MEDIAN(1,2,3,4,5) returns 3.

Excel RANK Function

The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time).

Excel PERCENTILE Function

The Excel PERCENTILE function calculates the "kth percentile" for a set of data. A percentile is a value below which a given percentage of values in a data set fall. You can use PERCENTILE to determine the 90th percentile, the 80th percentile,...

500 Formulas | 101 Functions

Exceljet

Quick, clean, and to the point

Excel QUARTILE.EXC Function

QUARTILE.INC vs QUARTILE.EXC

Download 100+ Important Excel Functions

Excel video training