Microsoft KB Archive/213495

= How to use a formula in Excel to calculate the average of a data sample without the highest and lowest values =

Article ID: 213495

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213495



SUMMARY
For statistical purposes, you may want to calculate the average of a data sample without the sample's highest and lowest values. To do this in Microsoft Excel, you can use the following formula:   =(SUM(region)-MAX(region)-MIN(region))/(COUNT(region)-2) Note To use this formula in Excel, you must include the parentheses the way that they appear in this formula. Do this to make sure that the function is computed in the correct order.

Additional query words: XL2000 XL2002 Median average XL2003 XL2007

Keywords: kbdtacode kbhowto kbpending kbprogramming KB213495

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.