The number of data points to exclude is provided as a percentage.

TRIMMEAN works by first excluding values from the top and bottom of a data set, then calculating mean.

The number of data points is provided as a percentage.

Excel AVERAGE function

For example, with 50 data points, 10% equals 5 values.

MODE Function

The Excel MODE function returns the most frequently occurring number in a numeric data set.

For example, =MODE(1,2,4,4,5,5,5,6) returns 5.

Excel AVERAGEIF function

Excel MODE function