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
|