Buzz
TRIMMEAN function calculates the inner portion average of dataset in Excel, or in other words, TRIMMEAN is the average of the interior portion in a dataset.
TRIMMEAN Function in Excel
How to Use TRIMMEAN Function in Excel
1. Description and Usage Syntax
This function returns the inner portion average of the dataset. It calculates by excluding a certain percentage of values at the beginning or end of the dataset.
Syntax:
The TRIMMEAN function in Excel calculates the mean (average) of data after excluding a certain percentage of data points from the top and bottom of the data set.
In this function:
- Array: The range of data to trim and calculate the mean, which is a required parameter.
- Percent: The percentage of data points to exclude from the calculation, also a required parameter.
Note:
- If Percent is less than 0 or greater than 1, the function returns an error value #NUM!
- The TRIMMEAN function rounds the number of excluded data points to the nearest multiple of 2.
2. Specific Scenario Examples
Suppose you need to calculate the trimmed mean of the dataset described in the table below:
Step 1: In the cell where you want the result, enter the formula: =TRIMMEAN(C3:I3, C4)
Step 2: Press Enter to get the trimmed mean of the dataset:
If the percentage of data to exclude is greater than 1 or less than 0, the function returns an error value #NUM!
Above is a guide along with a specific example when you use the TRIMMEAN function in Excel. This function calculates by excluding a certain percentage of values from the top or bottom of the dataset. Wish you success in working with this formula on Excel.
If you want to extract characters from the middle of a string, the MID function will be a choice for you. You can learn about the syntax and usage of the MID function through the tutorial shared on Mytour.
