8.5.11.69. xtrimmean

xtrimmean(array, percent)

TRIMMEAN(array, percent)

• percent in [0,1); trims floor(percent*n/2) from each tail

• ignores text/booleans/blanks

• errors:

  • no numeric data -> #NUM!

  • percent < 0 or >= 1 -> #NUM!

  • trims away all data (2k >= n) -> #NUM!