TRIMMEAN(array,percent) returns the mean of the interior of a data set : TRIMMEAN « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =TRIMMEAN(A2:A12,0.2). Press Enter to get the result.
Input the formula: =TRIMMEAN(A2:A12,0.2)

Referenced from Excel Help

21.75.TRIMMEAN
21.75.1.TRIMMEAN(array,percent) returns the mean of the interior of a data setTRIMMEAN(array,percent) returns the mean of the interior of a data set