ExcelFlux

TRIMMEAN function

the mean of the interior of a data set.

Statistical · Guided Excel example

Where can you use it?

Analytics, quality and research teams. Use this group to examine distributions, variability or relationships in measurements, sales or service durations.

Scenario in the workbook

Trim observations in pairs from both ends. The first two inputs trim nothing; the final one removes both extremes.

A worked example from the workbook

RowAB
6ReadingThreshold
710
830.15
990.67
Record 1
=TRIMMEAN($A$7:$A$9,B7)

Illustrative output4.333333333

See the inputs and instructions for all 3 examples

Syntax

TRIMMEAN(array, percent)

Worked examples

Trim observations in pairs from both ends. The first two inputs trim nothing; the final one removes both extremes.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B
6 Reading Threshold
7 1 0
8 3 0.15
9 9 0.67
Trial Expression Sample output
Record 1 =TRIMMEAN($A$7:$A$9,B7) 4.333333333
Record 2 =TRIMMEAN($A$7:$A$9,B8) 4.333333333
Record 3 =TRIMMEAN($A$7:$A$9,B9) 3
Microsoft Excel reference