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.
