Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Average Excluding Min and Max Values -TRIMMEAN function in Excel formula

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1744.xlsx
Learn how to calculate the average while excluding the min and max values. See how to use TRIMMEAN function to exclude a given percentage of high and low data. points.

Trimmed Mean Calculation (Trimmean Function)
1. (00:00) Introduction
2. (00:23) Formula #1: SUM, MIN, MAX and COUNT aggregate functions.
3. (01:03) Formula #2: Learn how to use trimmean function to exclude a given percentage of high and low data points.
4. (02:09) Formula #3: TRIMMEAN to exclude only max and min values.
5. (02:27) Formula #4: How to enter multiple arguments into one argument using parentheses.
6. (03:23) Formula #5: AGGREGATE to simultaneously get MIN, MAX and SUM. See array formula tricks.
7. (04:54) Formula #6: LARGE and SEQUENCE functions inside AVERAGE function.
8. (05:51) Summary, Closing and Video Links

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunMon, August 9, 2021 1:10pm