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:
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.
ID članka: 213495 - posljednja izmjena: 29. tra 2008. - verzija: 1