Alternative to TRIMMEAN

Originally Posted by DaleJ92

I am trying to remove some outliers from a large amount of data, currently i am using the TRIMMEAN function [....] i was wondering if you can take say 10% off the top and 30% off the bottom.

FYI, TRIMMEAN has nothing to do with ignoring outliers. Nor does your goal of arbitrarily ignoring the bottom 30% and top 10%.

For a statistical approach, I would suggest using the interquartile range (IQR) method. LMK if you want details.

I would not use the standard deviation (sd) method unless you have a normal distribution.