Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

TRIMMEAN(array,percent) returns the mean of the interior of a data set

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