TRIMMEAN

Syntax:

TRIMMEAN ( array , percent )

Description: Computes the mean of the interior of a data set by excluding a percentage of data points from the top and bottom tails of a data set. TRIMMEAN rounds the number of excluded data points down to the nearest multiple of 2. For symmetry, TRIMMEAN excludes a single value from the top and bottom of the data set.

Arguments:

Name

Type

Description

array

array, reference

The numeric values to trim and average.

percent

number

The fractional number of data points to exclude from the calculation.
example: : If percent = 0.2, 4 points are trimmed from a data set of 20 points (20x0.2): 2 from the top and 2 rom the bottom of the set.

Return Type and Value: number – The mean of the interior of a data set.

However, if percen  < 0 or percen > 1, #NUM! is returned.

example: