1 | data | |||
|---|---|---|---|---|
2 | 0.1 | |||
3 | 2 | |||
4 | 3 | |||
5 | 7 | |||
6 | 8 | |||
7 | 10 | |||
8 | 13.5 | |||
9 | 17 | |||
10 | 20 | |||
11 | 23 | |||
12 | ||||
13 | ||||
14 | Result | Formula | Description | |
15 | 10.0625 | =TRIMMEAN(A2:A11, 0.2) | Two values (one from each end of the range) excluded from the data | |
16 | 10.0625 | =TRIMMEAN(A2:A11, 25%) | Two values (one from each end of the range) excluded from the data | |
17 | 9.75 | =TRIMMEAN(A2:A11, 0.4) | Four values (two from each end of the range) excluded from the data | |
18 |