This repository has been archived by the owner on Oct 26, 2021. It is now read-only.
TRIMMEAN #3
WayneLambert
announced in
Excel Guides
Replies: 0 comments
# for free
to join this conversation on GitHub.
Already have an account?
# to comment
-
TRIMMEAN
enables outliers to be discounted for a mean average calculate by removing the top and bottom x% of values. For example:=TRIMMEAN(A1:A10,20%)
will remove the top and bottom 10% of values from the range between A1 and A10 and then do a mean average of those that remain.Beta Was this translation helpful? Give feedback.
All reactions