TRIMMEAN

Try it

When to use it

When should I use TRIMMEAN?

Use TRIMMEAN when your dataset contains outliers that would distort a simple AVERAGE — it excludes the top and bottom fraction of values before averaging, giving a more robust central tendency measure for skewed or noisy data.

Used in

science · operations

Syntax

TRIMMEAN(data,percent)

Examples

=TRIMMEAN({1,1,2,3,5,8,13,21,34,55},0.05) // => 14.3
=TRIMMEAN({2,4,6,8,10,12,14,16,18,20},0.1) // => 11