Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

This article was previously published under Q213495

↑ Back to the top


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.

↑ Back to the top


Keywords: KB213495, kbprogramming, kbpending, kbhowto, kbdtacode

↑ Back to the top

Article Info
Article ID : 213495
Revision : 7
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 323