Spread Formula Reference
TRIMMEAN
Formula Functions > Functions T to Z > TRIMMEAN

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