Dear All,
I would like to compute average removing top & bottom 10% of the data points.
Following is the sample data set across A1:A10.
<tbody>
</tbody>
Average of the data set is 40.7 and the trimmean is also yielding the same result.
Could some body tell me the issue here.
I would like to compute average removing top & bottom 10% of the data points.
Following is the sample data set across A1:A10.
10 |
18 |
37 |
9 |
58 |
6 |
65 |
100 |
46 |
58 |
<tbody>
</tbody>
Average of the data set is 40.7 and the trimmean is also yielding the same result.
Could some body tell me the issue here.