TRIMMEAN Function in Excel: Syntax, Examples and Free Practice
TRIMMEAN is an Excel Statistical function. Returns the mean of a data set, excluding a percentage from each end.
TRIMMEAN syntax
Arguments
array: The range or array to evaluatepercent: The percentage of values to exclude from each end
When to use TRIMMEAN
TRIMMEAN is used in data analysis work to summarize or test patterns across a data set.
Practice TRIMMEAN online, free
Open the live Excel-style spreadsheet and try TRIMMEAN yourself. No Excel install or sign-up needed to start.
Practice TRIMMEAN now →More Statistical functions
Frequently asked questions
What does the TRIMMEAN function do in Excel?
Returns the mean of a data set, excluding a percentage from each end.
What is the syntax of TRIMMEAN in Excel?
The syntax is =TRIMMEAN(array, percent). array: The range or array to evaluate; percent: The percentage of values to exclude from each end.
Where can I practice TRIMMEAN online for free?
Open the free live spreadsheet on Cellgrids and try TRIMMEAN yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts