TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel

The following article introduces you to the TRIMMEAN function - one of the functions in the statistical group is very popular in Excel.

TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel Picture 1

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:

TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel Picture 2

- In the cell to calculate enter the formula : = TRIMMEAN (D6: J6, D7)

TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel Picture 3

- Press Enter -> The average value inside of the data set is:

TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel Picture 4

- In case the data rate to be removed is greater than 1 or less than 0 -> the function returns the #NUM! Error value

TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel Picture 5

Above are instructions and some specific examples when using TRIMMEAN function in Excel.

Good luck!