Spread Formula Reference
Formula Functions / Functions M to Q / QUARTILE
In This Topic
    QUARTILE
    In This Topic

    This function returns which quartile (which quarter or 25 percent) of a data set a value is.

    Syntax

    QUARTILE(array,quart)

    Arguments

    This function has these arguments:

    Argument Description
    array Array or cell range of numeric values for which you want the quartile value
    quart Quartile value for the array (see the table below for returned values)

    Remarks

    A quarter is 25 percent. So the quartile number is an integer between 0 (the minimum value in the data set) and 4 (the maximum value in the data set) and determines the value to return as listed in the table below.

    If the number is... Then this function returns the...
    0 Minimum value
    1 First quartile (25th percentile)
    2 Median value (50th percentile)
    3 Third quartile (75th percentile)
    4 Maximum value

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    QUARTILE(A1:A17,2)

    QUARTILE(R1C1:R17C1,3)

    QUARTILE({11,21,42,27,18,29,32,52},1) gives the result 20.25

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    PERCENTILE | PERCENTRANK | Statistical Functions