For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Statistical

TRIMMEAN Function

Returns the mean of the interior of a data set


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

TRIMMEAN excludes a percentage of data points from the top and bottom tails to return the mean of the interior of a data set. Use this function to exclude outlying data from your calculation.

Syntax

TRIMMEAN(array,percent)

xxx

Applies To

Excel 2003 and above

Remarks

xxx

Examples

xxx

Other ExcelUser Information

xxx

Other Help

  • Microsoft Help for the xxx Function

 

Charley's SwipeFile charts


Free Excel Dashboards