- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - TRIMMEAN Function
Description
The TRIMMEAN function 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.
Syntax
TRIMMEAN (array, percent)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Array | The array or range of values to trim and average. | Required |
| Percent | The fractional number of data points to exclude from the calculation. | Required |
Notes
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.
If percent < 0 or percent > 1, TRIMMEAN returns the #NUM! error value.
If the supplied array is empty, TRIMMEAN returns the #NUM! error value.
If the percent is non-numeric, TRIMMEAN returns the #VALUE! error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
