View Single Post
 
Old 01-07-2012, 05:44 AM
markg2 markg2 is offline Windows 7 Office 2007
Expert
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default Average minus outliers?

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
Reply With Quote