If you're an inbound marketer, chances are you have lots of data to analyze and you base your most important decisions on quantitative measures. In this blog series, I discuss some the most useful tools and tricks for analyzing your data in Excel.
An alternative to the median is the TRIMMEAN function. This function calculates the average, but it enables you to exclude the most extreme values. For example, if you had 100 values in your dataset and you trimmed 20% of the values, TRIMMEAN would exclude the lowest 10 and the highest 10 values from the average.