TRIMMEAN function

TRIMMEAN(values, percentage) TRIMMEAN(values; percentage)

values — { Number }

The values the calculation is based on.

percentage — Number or { Number }

The percentage of values at the beginning and end of the array which should be ignored. If .1 (10%) is given and the given array contains 100 values, the first five values and the last five values are ignored, for a total of ten ignored values (10% * 10010% * 100).

Returns — Number or { Number }

The mean (average) of all given values which are not discarded.

Returns the mean (average) of the given values, ignoring a percentage of array elements at the beginning and end of the given array. The array is sorted first before values are discarded, meaning that the smallest and largest values are removed (if any).

Use AVERAGE or AVERAGEA instead if you don't need to trim the smallest and largest values before calculating the average.

Examples

TRIMMEAN({ 1, 3, 7, 19, 23, 29, 45, 48, 92, 93 }, 0)TRIMMEAN({ 1; 3; 7; 19; 23; 29; 45; 48; 92; 93 }; 0)

Returns 36, which is the mean of all values of the array. Specifying 0 as the second parameter ensures that no values are removed.

AVERAGE(1, 3, 7, 19, 23, 29, 45, 48, 92, 93)AVERAGE(1; 3; 7; 19; 23; 29; 45; 48; 92; 93)

Returns 36, which is the mean of all values of the array. Specifying 0 as the second parameter to TRIMMEAN and using AVERAGE produce identical results.

TRIMMEAN({ 1, 3, 7, 19, 23, 29, 45, 48, 92, 93 }, 0.2)TRIMMEAN({ 1; 3; 7; 19; 23; 29; 45; 48; 92; 93 }; 0,2)

Returns 33.25, which is the mean of all values of the array, excluding 3 and 93. Specifying 0.2 for the second parameter ensures that 10% of all values are removed at the beginning and 10% are removed at the end, before performing the calculation.

AVERAGE({ 3, 7, 19, 23, 29, 45, 48, 92 })AVERAGE({ 3; 7; 19; 23; 29; 45; 48; 92 })

Returns 33.25, which is the mean of all values of the array. This array is identical to the { 1, 3, 7, 19, 23, 29, 45, 48, 92, 93 }{ 1; 3; 7; 19; 23; 29; 45; 48; 92; 93 } array of the other examples, but has had 1 and 93 removed.