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

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




    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)


    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.




    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