Public Function TrimMean( _ ByVal vPercent As Variant _ , ParamArray vValues() As Variant _ ) As Variant
TrimMean(0.0, SampleData) = 145.152173913043 TrimMean(0.1, SampleData) = 144.654761904762 TrimMean(0.2, SampleData) = 144.108108108108 TrimMean(0.3, SampleData) = 143.878787878788See 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.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.