View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis
 
Posts: n/a
Default TRIMMEAN with different percentiles?

Per Help, TRIMMEAN({1,1,1,1,1,1,1,1,2,2},10%) =
AVERAGE({1,1,1,1,1,1,1,1,2,2}); since 10% of 10 < 2, nothing is trimmed.

Jerry

"Jerry W. Lewis" wrote:

....
Although the exact calcuation for TRIMMEAN({1,1,1,1,1,1,1,1,2,2},10%) is
unclear ...