QUARTILE function

Returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE to find the top 25 percent of incomes in a population.

 Important   This function was replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. This function is still available for compatibility with earlier versions of Excel. However, if backward compatibility is not required, you should consider using the new functions from now on, because they more accurately describe their functionality.For more information about the new function, see QUARTILE.INC function.

Syntax

QUARTILE(array,quart)

Argument Description Remarks
array The array or cell range of numeric values for which you want the quartile value.
  • If array is empty, QUARTILE returns the #NUM! error value.
quart Indicates which value to return.
  • If quart equals 0, QUARTILE returns the minimum value.

If quart equals 1, QUARTILE returns the first quartile (25th percentile).

If quart equals 2, QUARTILE returns the median value (50th percentile).

If quart equals 3, QUARTILE returns the third quartile (75th percentile).

If quart equals 4, QUARTILE returns the maximum value.

  • If quart < 0 or if quart > 4, QUARTILE returns the #NUM! error value.
  • If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point.

General remarks

MIN, MEDIAN, and MAX return the same value as QUARTILE when quart is equal to 0 (zero), 2, and 4, respectively.

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

Data  
1  
2  
4  
7  
8  
9  
10  
12  
Formula Description (Result)
=QUARTILE(A2:A9,1) First quartile (25th percentile) of the data in the list (3.5)

See also

LARGE function

MAX function

MEDIAN function

MIN function

PERCENTILE.INC function

PERCENTILE.EXC function

PERCENTRANK.INC function

PERCENTRANK.EXC function

SMALL function

List of all functions (by category)

 
 
Applies to:
Excel for Mac 2011