WorksheetFunction.TrimMean Method
Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set. You can use this function when you wish to exclude outlying data from your analysis.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function TrimMean ( _
Arg1 As Object, _
Arg2 As Double _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Double
Dim returnValue As Double
returnValue = instance.TrimMean(Arg1, _
Arg2)
double TrimMean(
Object Arg1,
double Arg2
)
Parameters
Arg1
Type: System.ObjectArray - the array or range of values to trim and average.
Arg2
Type: System.DoublePercent - the fractional number of data points to exclude from the calculation. For example, if percent = 0.2, 4 points are trimmed from a data set of 20 points (20 x 0.2): 2 from the top and 2 from the bottom of the set.
Return Value
Type: System.Double
Remarks
If percent < 0 or percent > 1, TrimMean returns the #NUM! error value.
TrimMean rounds the number of excluded data points down to the nearest multiple of 2. If percent = 0.1, 10 percent of 30 data points equals 3 points. For symmetry, TrimMean excludes a single value from the top and bottom of the data set.