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


The information in this article applies to:

  • Microsoft Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000
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.

MORE INFORMATION

For more information about statistical functions, click Microsoft Excel Help on the Help menu, type statistical functions in the Search for box in the Assistance pane, and then click Start searching to view the topic.
Modification Type:MinorLast Reviewed:10/16/2006
Keywords:kbdtacode kbhowto kbpending kbProgramming KB213495
©2004 Microsoft Corporation. All rights reserved.