The following article introduces you to the TRIMMEAN function - one of the functions in the statistical group is very popular in Excel.
Description: The function returns the average of the interior of the data set. The function calculates by removing which percentage of the value is in the first or last boundary of the data set.
Syntax: TRIMMEAN (array, percent)
Inside:
- array: The array or range of data to trim and average, which is the required parameter.
- percent: The percentage of data points to be removed from the calculation, which is a required parameter.
Attention:
- If Percent <0 or Percent> 1 -> the function returns the #NUM! Error value
- TRIMMEAN function rounds the number of excluded data points to the nearest multiple of 2.
For example:
Calculate the internal mean of the data set described in the following data table:
- In the cell to calculate enter the formula : = TRIMMEAN (D6: J6, D7)
- Press Enter -> The average value inside of the data set is:
- In case the data rate to be removed is greater than 1 or less than 0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using TRIMMEAN function in Excel.
Good luck!