Manuals/calci/TRIMMEAN
Jump to navigation
Jump to search
TRIMMEAN(ar, p)
Where' ar' is the array and p is the incomplete number of data points.
It returns the mean which taken by excluding the top and bottom data.
- If percent < 0 or percent > 1, TRIMMEAN returns zero value when percent is grater than .
TRIMMEAN
Lets see an example,
B
8
9
10
11
5
6
7
8
=TRIMMEAN(B2:B9,0.2) is 8
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 8 | 8 | ||
| Row2 | 9 | |||
| Row3 | 10 | |||
| Row4 | 11 | |||
| Row5 | 5 | |||
| Row6 | 6 | |||
| Row7 | 7 | |||
| Row8 | 8 |
