Learn How to Use Microsoft Excel TRIMMEAN Function

Microsoft Excel TRIMMEAN Function

The main purpose of the Microsoft Excel TRIMMEAN function is to calculate the mean excluding outliers. That implies, with the help of the TRIMMEAN function you can able to calculate the mean or average while excluding outliers. It should be noted that the number of data points to exclude is provided as a percentage. So, with the help of the TRIMMEAN function, you can able to calculate the mean excluding outliers.

Return Value of TRIMMEAN Function

The return value will be the calculated mean.

Syntax of TRIMMEAN Function

=TRIMMEAN(array, percent)

Where the arguments:

• array: These are the values to trim and average.
• percent: This is the number of data points to exclude from the calculation.

How to Use Microsoft Excel TRIMMEAN Function?

So we know that Microsoft Excel TRIMMEAN function you can able to calculate the mean excluding outliers. That implies, with the help of the TRIMMEAN function you can able to calculate the mean or average while excluding outliers. It should be noted that the number of data points to exclude is provided as a percentage. So, with the help of the TRIMMEAN function, you can able to calculate the mean excluding outliers.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel