From the course: Excel: Analytics Tips

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Outlier detection

Outlier detection - Microsoft Excel Tutorial

From the course: Excel: Analytics Tips

Start my 1-month free trial Buy for my team

Outlier detection

“

we're getting a little bit more advanced. This is a four-star analytics tip. We're going to talk about how to find or detect outliers using a combination of stats functions and conditional formatting. Now, what we're going to do here is use functions like median and quartile to actually calculate statistical outliers So in this case, we're looking at athlete data. Names in Column A, we've got heights in Column B, and weights in Column C. And what we'll be doing is creating the outlier calculations using those stats functions, calculate the median value, the first quartile, third quartile, the inter-quartile range or IQR and something called the fence multiplier. And that fence is essentially what determines how far out of the norm a value must fall in order to be labeled as an outlier. And what we'll end up with is a range of values defined by the inner or lower fence or the upper or outer fence, meaning that any values that fall outside of that range will technically be labeled as an…

Contents