Exceljet

Quick, clean, and to the point

Excel QUARTILE.INC Function

Excel QUARTILE.INC function
Summary 

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

Purpose 
Get the quartile in a data set
Return value 
Value for requested quartile
Syntax 
=QUARTILE.INC (array, quart)
Arguments 
  • array - A reference containing data to analyze.
  • quart - The quartile value to return.
Usage notes 

Use the QUARTILE.INC function to get the quartile for a given set of data. QUARTILE.INC 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

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.INC function replaces the QUARTILE function with the same behavior.

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.