Trimmean Not Yielding Desired Result

[xlmaniac]

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.
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]37[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]65[/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]46[/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[/TR]
</tbody>[/TABLE]

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.

 

[JLGWhiz]

don't know. I get the same results. Certainly does not appear to do what the MS description says it should do.

 

[shg]

TrimMean always eliminates and equal number of values from the max and min values in the list. You have 10 values, so the minimum number that can be removed is two, so the minimum fraction to exclude any values is 2/10 = 20%.

 

[AhoyNC]

If you wanted to remove the top & bottom 10% of values you could do something like this.

Excel Workbook
	A	B	C
1	10
2	18		37.625
3	37
4	9
5	58
6	6
7	65
8	100
9	46
10	58
Sheet

 

[shg]

Or =trimmean(a1:a10, 20%)

 

[JLGWhiz]

Or =trimmean(a1:a10, 20%)

That is so simple, after it has been explained. Makes me ashamed. (g)