Documentation/Calc Functions/TRIMMEAN

Function name:
TRIMMEAN

Category:
Statistical Analysis

Summary:
Calculates the mean of a data set ignoring a percentage of the values at the margins.

Syntax:
TRIMMEAN(Data; Alpha)

Returns:
Returns a real number which is the mean of a data set ignoring a specified percentage of data at the margins.

Arguments:
Data is an array or a reference to a range of cells of data in the sample.

Alpha is a real number between 0(inclusive) and 1(exclusive) which is the percentage of the marginal data that will not be taken into consideration. It is such that the same number of points are dropped at each end.


 * If Data contains a text value either passed in double-quotes in an array or a reference to the cell containing that text then the function ignores that value. However, while passing in an array if the text is not enclosed in double-quotes then the function returns an error value (Err:539).
 * If Alpha is less than 0 or greater than or equal to 1 then the function returns an error value.

Additional details:

 * The formula for TRIMMEAN is:

We sort the values in Data before using them. So

and TRIMEAN =



where sortedDatai is the ith value after sorting the Data in ascending order, n is the number of data points in Data and Alpha is Alpha.
 * It is TRIMMEAN(data, 0) = AVERAGE(data).

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/AVERAGE AVERAGE]

[[Special:MyLanguage/Documentation/Calc_Functions/GEOMEAN GEOMEAN]

[[Special:MyLanguage/Documentation/Calc_Functions/HARMEAN HARMEAN]

ODF standard:
Section 6.18.80, part 2

Equivalent Excel functions:
TRIMMEAN