Returns the mean of the interior of a data set by excluding a specified percentage of data points from the top and bottom tails.
Syntaxis
TRIMMEAN(array, percent)Argumenten
arrayvereist
The array or range of data values to trim and average.
percentvereist
The fractional number of data points to exclude from the calculation (e.g., 0.1 excludes 10%).
TRIMMEAN calculates the average of a data set after removing a specific percentage of outliers from both the top and bottom ends. This function is useful for eliminating extreme values that might skew the overall average of a distribution.
=TRIMMEAN({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 0.2)→5.5Excludes 20% of 10 values (2 values total, 1 from each end), averaging the remaining 8 values (2 through 9).
Select the cell
Click on the cell where you want the trimmed mean to appear.
Enter the formula
Type =TRIMMEAN( and select your data range, followed by the percentage to trim.
It rounds the number of excluded points down to the nearest multiple of 2.