I'm randomly logging my actual download and upload rates to determine how far off I am from the advertised rate. I want to eliminate from the average the top and bottom 1 or 2 outliers. I tried TRIMMEAN() but that doesn't seem to do what I need. Is there another function that would work better for this problem?



Mark

Hi Mark,

TRIMMEAN() should work.

To get the average from A:A but excluding the largest and smallest outlier:
=TRIMMEAN(A:A,(COUNT(A:A)-2)/COUNT(A:A))

To get the average from A:A but excluding the 2 largest and 2 smallest outliers:
=TRIMMEAN(A:A,(COUNT(A:A)-4)/COUNT(A:A))

Thanks Colin--

Not mathematically inclined, my attempt to use the function was based solely on the Excel help example. Be assured that my expression only had a passing resemblance to yours ;-)

Thanks again--

Mark