TRIMMEAN function
Summary
Returns the mean of the interior of a data set
Syntax
TRIMMEAN(array, percent)
The TRIMMEAN function syntax has the following arguments:
• Array Required. The array or range of values to trim and average.
• Percent Required. The fractional number of data points to exclude from the calculation. For example, if percent = 0.2, 4 points are trimmed from a data set of 20 points (20 x 0.2): 2 from the top and 2 from the bottom of the set.
• Array Required. The array or range of values to trim and average.
• Percent Required. The fractional number of data points to exclude from the calculation. For example, if percent = 0.2, 4 points are trimmed from a data set of 20 points (20 x 0.2): 2 from the top and 2 from the bottom of the set.
Example
=TRIMMEAN(A2:A12,0.2)