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


    This function returns the quartile (which quarter or 25 percent) of a data set based on percentile values from 0..1, exclusive.




    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

    The function returns #NUM! if the array is empty. The function returns #NUM! if quart = 0 or 4.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.




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

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also