Spread Formula Reference
Formula Functions / Functions T to Z / 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)

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    GEOMEAN | HARMEAN | Statistical Functions