Description Computes the mean of a list of numbers after reducing a specified percent of the members of the list. The list is sorted in ascending order, then half of F percent of the list members are eliminated from the top and half from the bottom of the list, and finally the mean of the remaining members is taken.
This function is useful for eliminating outliers in a sample.
Syntax TRIMMEAN ( numbers, F)
| Argument | Description |
|---|---|
| numbers | A range reference or array constant containing numbers. All numeric values, including 0, are used. Text and logical values in cell references and arrays is ignored. Empty cells are ignored. |
| F | The percent of the members of the list of values that you want to eliminate. The list will be sorted in ascending order and half of this percentage of members will be eliminated from the bottom of the list, half from the top. The percentage will be rounded down. For example, if you chose to eliminate 15% of a 100-member list, 7 members will be deleted from the top and 7 from the bottom of the list, totalling only 14% eliminated. |
Example This function returns 5.5:
First, the top 10% and bottom 10% of the list members (1 and 15) are eliminated. Then the mean of the remaining numbers is taken.
See Also AVERAGE
