TRIMMEAN Function in LibreOffice Calc — Tested Examples
An explanation of LibreOffice Calc TRIMMEAN, including tested formulas, examples, expected results and common mistakes.
Tested: Examples checked in LibreOffice Calc 25.2.3.2. What this means
Returns the mean of a sample without including the marginal values. With values 7,5,9,3 and a trim proportion of 0.5, remove the smallest and largest, leaving 5 and 7: average 6.
Syntax and arguments
=TRIMMEAN(Data; Alpha)
LibreOffice Calc formulas generally separate arguments with semicolons (;).
| Argument | Explanation |
|---|---|
Data |
The array of the data in the sample. |
Alpha |
The percentage of marginal data that is not to be taken into account. |
Worked examples
Reproduce these source cells: Q20=7, Q21=5, Q22=9, Q23=3.
Example 1: Find the average after trimming one value from each end
=TRIMMEAN(Q20:Q23;0.5)
Expected result: 6. This value was returned in the LibreOffice Calc 25.2 test.
Example 2: Calculate the untrimmed average as a control
=TRIMMEAN(Q20:Q23;0)
Expected result: 6. This value was returned in the LibreOffice Calc 25.2 test.
How to interpret the result
With values 7,5,9,3 and a trim proportion of 0.5, remove the smallest and largest, leaving 5 and 7: average 6.
Mistakes and troubleshooting
- Check inputs and assumptions: The proportion describes the total removed from both tails, and removals occur symmetrically.
- Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
- Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.
Related functions
Tested version and primary reference
2 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.