SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / TRIMMEAN
In This Topic
    TRIMMEAN
    In This Topic

    This function returns the mean of a subset of data excluding the top and bottom data.

    Syntax

    TRIMMEAN(array,percent)

    Arguments

    This function has these arguments:

    Argument Description
    array Array of values to trim and find the mean
    percent Fractional amount of data in array to trim (to exclude from calculation)

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    TRIMMEAN(A1:A17,0.25)

    See Also