:TRIMMEAN function to find the average-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Returns the internal average of the data set. The function TRIMMEAN removes a percentage of data points from the head and tail of a data set before averaging.

Use this function when you want to exclude calculations on a portion of the data from your analysis.

Syntax
TRIMMEAN(array,percent)
array is an array or numerical range that needs to be sorted and averaged.
percent is the data point to be removed during calculation proportion, for example, if percentage = 0.3, in a set of 20 data points, 6 will be removed

Data points (20 x 0.3): 3 removed from the head and 3 removed from the tail.

Description
• If percent < 0 or percent > 1, function TRIMMEAN returns the #NUM! error value.

• Number of data points to be removed by function TRIMMEAN Round down to the nearest multiple of 2. If percent = 0.1, 10% of 30 data points

Equals 3 data points. The function TRIMMEAN will symmetrically remove one item from the head and one item from the tail of the data set.

In the game, When we want to calculate the final score of a player, we often remove the highest score and the lowest score, and then calculate the average score.
At this time the AVERAGE function cannot be used, we can use the TRIMMEAN function.
Its function is to return the internal average of the data set. Let's give an example to help everyone understand this function. Take this score table as an example.
Suppose we find the average of this set of scores after removing the highest score and the lowest score.

￭ First select cell B2, click Insert Function, search for the TRIMMEAN function in the search box, and click OK.

￭ Here we need to enter two values.
Array: data area used to calculate the average
Percent: the proportion of data to be eliminated. For example, if percentage = 0.2, in a set of 10 data points, 2 data points will be removed. Click
(10 x 0.2): Remove 1 from the head and 1 from the tail.
Fill the score into the array, fill in the percentage with 0.2, and click OK to find out the set of scores after removing the highest score and the lowest score. the average score.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/TRIMMEAN-han-shu-qiu-ping-jun-zhi.html