TRIMMEAN Function (Average Excluding Outliers in Excel)
Calculate average excluding outliers in Excel with the TRIMMEAN function.
This function allows you to enter a percentage of values to exclude from the range. This percentage can be entered as a constant or be a cell value, though you can calculate the values to exclude, for example, the max and min.
📗 Download the '40 Excel tips' booklet: https://bit.ly/40ExcelTips
Related Resources
➡️ Moving Average in Excel: • Moving Average in Excel (Seven-Day Ro...
➡️ Average the top 5 values only: • Average the Top 5 Values - Two Excel ...
➡️ Weighted average with SUMPRODUCT: • Weighted Average with the SUMPRODUCT ...
Use the Excel TRIMMEAN function to calculate the average in Excel while excluding outliers from both ends of the value range. This quick Excel tutorial shows two examples of TRIMMEAN in Excel and the differences to a standard AVERAGE.
Connect with us
LinkedIn ► / alanmurray-computergaga
Instagram ► / computergaga1
Twitter ► / computergaga1
TikTok ► / computergaga
