Syntax
=TRIMMEAN(array, percent)Arguments
| Argument | Required | Description |
|---|---|---|
array | Required | The numbers |
percent | Required | Fraction of the values to leave out, split between both ends |
How to use TRIMMEAN
TRIMMEAN takes 2 required arguments. Type =TRIMMEAN( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=TRIMMEAN({4,5,6,7,2,3,4,5,1,2,3}, 0.2)Result Related statistical functions
- T.INVReturns the left tailed inverse of the Student's t distribution.
- T.INV.2TReturns the two tailed inverse of the Student's t distribution.
- T.TESTReturns the probability from a Student's t test that two samples come from populations with the same mean.
- TRENDReturns values along the least squares straight line that fits the known data.
- VAR.PReturns the variance of a whole population.
- VAR.SEstimates the variance from a sample.
- VARAEstimates the variance from a sample, counting text as 0 and TRUE as 1.
- VARPAReturns the population variance, counting text as 0 and TRUE as 1.
- WEIBULL.DISTReturns the Weibull distribution.