Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Average minus outliers?
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-07-2012, 05:44 AM
markg2 markg2 is offline Average minus outliers? Windows 7 Average minus outliers? Office 2007
Expert
Average minus outliers? 		 
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
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average minus outliers? 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 minus outliers? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:56 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft