Jaw TRIMMEAN is a calculation function that returns the average of the inner part of a dataset in Excel or in other words TRIMMEAN is the average of a portion in a dataset.
TRIMMEAN function in Excel
How to use the TRIMMEAN function in Excel?
1. Description and syntax used
This is the average function that returns the interior of the data set. The function calculates by removing any percentage of the value in the first or last boundary of a dataset.
TRIMMEAN (array, percent)
– 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.
– If Percent or Percent> 1 -> function returns error value #NUM!
– Function TRIMMEAN rounds the number of excluded data points to the nearest multiple of 2.
2. Examples of specific situations
Suppose you need to calculate the inner mean of a data set described in the following data table:
Step 1: In the cell to calculate -> you enter the formula: = TRIMMEAN (C3: I3, C4)
Step 2: Press Enter ->, the mean inside value of the dataset is:
If the data to be removed is greater than 1 or less than 0 ->, the function returns an error value #NUM!
The above are instructions along a specific example when you use TRIMMEAN function in Excel. This is a function that calculates by removing any percentage of the value in the first or last boundary of a dataset. Wishing you success working with this formula in Excel.
If you are trying to cut off the middle character of a string, the MID function will be an option for you. You can understand the syntax and usage MID function Through the tutorial article has been shared on Taimienphi.vn.