How to Use the TRIMMEAN Function in Excel

This guide explains how to use TRIMMEAN Function in Excel, including its syntax, required arguments, practical examples, and common errors.

How to Use the TRIMMEAN Function in Excel screenshot

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:

How to Use the TRIMMEAN Function in Excel screenshot 2

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

How to Use the TRIMMEAN Function in Excel screenshot 3

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

How to Use the TRIMMEAN Function in Excel screenshot 4

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

How to Use the TRIMMEAN Function in Excel screenshot 5

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

Good luck!

FAQ

What does the TRIMMEAN function do in Excel?

The TRIMMEAN function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.

How do I enter the TRIMMEAN function correctly?

Start with an equals sign, enter TRIMMEAN, add the required arguments inside parentheses, and confirm that cell references and separators are correct.