How does a WPS table calculate the average number? Average TRIMMEAN function calculation formula

Contestant rating table for a Grand Prix

In the "last score" item, we use the TRIMMEAN function provided by ET to calculate the formula: = TRIMMEAN (B3: I3, 2/8)

Let's take a look at the TRIMMEAN function:

The TRIMMEAN function returns the internal average value of a dataset. The TRIMMEAN function first removes a certain percentage of data points from the header and tail of the array, and then calculates the average value. This function can be used when you want to remove a portion of data from the analysis.

The format is TRIMMEAN (array, percentage), where "array" is the array or data area that needs to be filtered and averaged. "Percentage" is the proportion of the data points to be removed during calculation. For example, if "percentage" = 0.2, in the collection of 20 data points, we need to remove four data points (20*0.2), two for the header, and two for the tail.

Note:

If the "percentage" is <0 or 1>, the TRIMMEAN function returns the error value # NUM !.

The TRIMMEAN function returns the number of removed data points to a multiple of the nearest two. For example, "percentage" = 0.1, 10% of 30 data points is equal to 3 data points. The TRIMMEAN function removes one data in the header and tail of the dataset.