|
|
#1
01-07-2012, 05:44 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel 2010 formula rounds - arithmetic average calculation
|
YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |
| 'AVERAGE' Formula | nfphilpot | Excel | 3 | 11-24-2010 02:19 PM |
|
Average of many rows
|
speedycorn1 | Excel | 1 | 10-30-2010 07:54 PM |
| calculate average depending on drop-down values | virencm | Word | 0 | 08-06-2010 06:10 PM |
Windows 7 
Office 2007
Threaded Mode