« Determining whether a year is a Leap Year | Main | Charting : Introduction »
November 02, 2004
Average a range without highest and lowest values
For statistical purposes, you may want to calculate the average of a data sample without its highest and lowest values.The formula to do this is
=(SUM(range)-MAX(range)-MIN(range))/(COUNT(range)-2)
The use of this formula is illustrated below.
Posted by Dave at November 2, 2004 05:24 AM