This repository was archived by the owner on Oct 26, 2021. It is now read-only.
TRIMMEAN #3
WayneLambert
announced in
Excel Guides
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
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