Excel Function : TRIMMEAN

Download now!

Excel Function : TRIMMEAN

Category

Statistical

Description

Returns the mean of the interior of a data set

Microsoft Excel Reference Page

https://support.office.com/en-us/article/TRIMMEAN-function-d90c9878-a119-4746-88fa-63d988f511d3

Syntax and Description of the TRIMMEAN Excel Function

The syntax for the TRIMMEAN function in Microsoft Excel is: TRIMMEAN(array, percentile) array is the range of cells that you want to calculate the trimmed mean for. percentile is the percent of values in the array that you want to exclude from the calculation.

About TRIMMEAN Excel Function

TRIMMEAN removes a percentage of data from the top and bottom of a data set, and then takes the mean of the remaining data. The percentage is based on the number of data points in the data set.