Use Excel TRIMMEAN Function For Average That Excludes Outliers
HTML-код
- Опубликовано: 3 июл 2024
- www.contextures.com/excelavera... Visit this page to download the sample file for this video. The example is on the TRIMMEAN sheet in the sample workbook.
In Excel, you can use the AVERAGE function to calculate the average (mean) for a set of numbers.
If the data includes some unusually high and low numbers, you might want to see the average without those numbers included.
With Excel's TRIMMEAN function, you can select a range of cells, and specify the percentage of high/low cells -- the outliers -- that you want to exclude. The TRIMMEAN function returns the average for the inner range of cells, and excludes the highest and lowest cells.
00:00 AVERAGE Function
00:26 Outliers - high and low numbers
00:45 TRIMMEAN Function
01:00 Conditional Formatting to Highlight Low/High Numbers
01:34 TRIMMEAN Formula
01:41 Enter Trim Percentage in Cell
02:01 Type the TRIMMEAN Formula
02:30 Compare AVERAGE and TRIMMEAN
02:39 How TRIMMEAN Works
03:54 Verify the TRIMMEAN
04:51 Conclusion
05:00 Get the Sample File
Watch this video to see how to create a TRIMMEAN formula, and compare it with the average. - Наука
Thank you for the clear explanation!
Awesome! Love the color!
Thanks ExcelIsFun -- I try to save the colours for special occasions.
Awesome I was in need to know how it works and I got it from your video, God bless you
Great explanation! Thanks!
Thank you!
Thanks, really helpful
Perfectly explained
Thank you!
Very helpful!
Thanks Oz du Soleil -- glad you found the video helpful!
thanks
Thanks Debra. Take care of that cold. Your voice sounded a bit froggy today. 😊
Thanks krn14242 and I hope this cold ends soon!