Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.
data- Array or range containing the dataset to consider.
exclude_proportion- The proportion of the dataset to exclude, from the extremities of the set.
exclude_proportionmust be greater than or equal to
0and less than
HARMEAN: Calculates the harmonic mean of a dataset.
GEOMEAN: Calculates the geometric mean of a dataset.
AVERAGEA: Returns the numerical average value in a dataset.
AVERAGE: Returns the numerical average value in a dataset, ignoring text.
In order to use the TRIMMEAN formula, start with your edited Excellentable:
Then type in the TRIMMEAN formula in the area you would like to display the outcome:
By adding the values you would like to calculate the TRIMMEAN formula for, Excellentable will generate the outcome: