Use Excel TRIMMEAN Function For Average That Excludes Outliers

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.

[azizahmedkhan]

Awesome I was in need to know how it works and I got it from your video, God bless you

[krn]

Thanks Debra. Take care of that cold. Your voice sounded a bit froggy today. 😊