Hello, Excellers welcome to another #formulafriday blog post with yet another an awesome Excel tip. No – one likes to be ignored right?….wrong?…let you decide that one, but I was asked recently about calculating an average of a data set which was being skewed by some very rogue or outlying looking values in the range and data. Today we are going use TRIMMEAN to Ignore Outliers.. The values could have been extracted or input incorrectly, but it did affect the average of the data set. Here is a sanitised version of the data to work through this example and tip.
Have you signed up to the Excel Newsletter?. 3 free Excel tips The first Wednesday of every month.? Sign up in the box to the right or in the link at the bottom of this blog post. See you next Month!.
TRIMMEAN has simple enough syntax with two required arguments
array -The array or range of values to trim and average.
per cent – The fractional number of data points to exclude from the calculation.
Back to our example, how does the TRIMMEAN affect our data?.
What Next? Want More Tips?
If you want more Excel and VBA tips then sign up for my Monthly Newsletter where I share 3 Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips and check out all of my Formula Friday Blog posts below.
Do You Need Help With An Excel Problem?.
Finally, I am pleased to announce I have teamed up with Excel Rescue, where you can get help with Excel FAST. Why not check it out?.