**Public Function TrimMean( _
ByVal vPercent As Variant _
, ParamArray vValues() As Variant _
) As Variant**

**Returns the mean of the values in the middle of a data set by excluding vPercent of the data points, half at the top and half at the bottom of the data. **

**Examples:** TrimMean(0.0, SampleData) = 145.152173913043
TrimMean(0.1, SampleData) = 144.654761904762
TrimMean(0.2, SampleData) = 144.108108108108
TrimMean(0.3, SampleData) = 143.878787878788

**See also:** Average Function
Percentile Function
Quartile Function
PercentRank Function
Rank Function
StatVarType Property
TRIMMEAN Function (Microsoft Excel)

**vPercent:** The percent of data points to be excluded from the average. vPercent is expressed as a number between 0 and 1, so to exclude 20% of the data, use a vPercent value of .2. Half of the data is excluded from the bottom or the data and half from the top.

**vValues:** The values that are to be averaged. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays, or any combination of these. The current setting of the StatVarType Property determines which numeric data types are recognized by this function.

**Return value:** Function returns the mean of the remaining values in the middle of a data set. Function returns Null if none of the vValues arguments are numeric, or if vPercent is less than zero (<0) or greater than one (>1). Copyright 1996-1999 Entisoft

Entisoft Tools is a trademark of Entisoft.