Returns the mean of the interior of a dataset.
Sample Usage
TRIMMEAN(A1:A25,0.2)
Syntax
TRIMMEAN(range, exclude)
- range - The array or range containing the dataset to consider.
- exclude - The proportion of the dataset to exclude, from the extremities of the set.
Examples
TRIMMEAN(A1:A25,0.2) returns the mean of the interior of the data set contained in A1:A25, with 20 percent excluded from calculation.