Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11TRIMMEAN 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.
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:
- In the cell to calculate enter the formula : = TRIMMEAN (D6: J6, D7)
- Press Enter -> The average value inside of the data set is:
- In case the data rate to be removed is greater than 1 or less than 0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using TRIMMEAN function in Excel.
Good luck!
Micah SotoYou should read it
- AVEDEV function - The function returns the average absolute deviation of data points from their midpoint in Excel
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
- LARGE function - The function returns the kth largest value in a dataset in Excel
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
- KURT function - The function returns the sharp coefficient of a dataset in Excel
- PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
- PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
- GEOMEAN function - The function returns the average of a positive array or range of data in Excel
May be interested
- GEOMEAN function - The function returns the average of a positive array or range of data in Excel
geomean function: the function returns the average of a positive array or range of data. use the function to calculate the average growth when knowing the gross profit with variable interest rates. syntax: geomean (number1, [number2], ...) - SMALL function - The function returns the kth smallest value in a dataset in Excelsmall function: the function returns the kth smallest value in a dataset. syntax: small (array, k)
- AVERAGEIF function (returns the average value according to the condition) in Excelthe averageif () function returns the average value of all selected cells that meet the conditions you specify.
- AVERAGEIF function - The function returns the average of the arguments with the conditions specified in Excelaverageif: the function returns the average of the arguments given the specified condition. syntax: averageif (range, criteria, [average_range])
- How to use the DAVERAGE function in Exceldaverage in excel is a function that calculates the average value of data with given conditions in a spreadsheet. so, how to use this function?
- AVEDEV functionavedev function: the function returns the average absolute deviation of the data points from their midpoint. the avedev function allows you to measure the variability of a dataset. syntax: avedev (number1, [number2], ...)
- Basic Excel functions that anyone must knowthe basic functions in excel such as the excel function, the excel statistics function we summarized below will be very helpful for you who often have to work on excel spreadsheets, especially in the field of accounting. let's refer to offline.
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
- AVERAGEIFS function - The function returns the average of the arguments that meet multiple conditions in Excelaverageifs function: the function returns the average of the arguments that meet multiple conditions. syntax: averageifs (average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
- NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excelnorm.s.inv function: the function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1. support from excel 2010 onwards. syntax: norm.s.inv (probability)
Office information
- VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
- VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
- VARA - Function that calculates variance based on a sample, including logical values and text in Excel
- VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excel
- Z.TEST function - The function returns one-sided value of the z test in Excel
- LINEST function - The function returns a line description array using the least square method in Excel
VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
VARA - Function that calculates variance based on a sample, including logical values and text in Excel
VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excel
Z.TEST function - The function returns one-sided value of the z test in Excel
LINEST function - The function returns a line description array using the least square method in Excel