WorksheetFunction.TrimMean(Object, Double) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public:
 double TrimMean(System::Object ^ Arg1, double Arg2);

public double TrimMean (object Arg1, double Arg2);

Public Function TrimMean (Arg1 As Object, Arg2 As Double) As Double

Parameters

Arg1: Object

Array - the array or range of values to trim and average.

Arg2: Double

Percent - 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.

Returns

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.

Applies to