**Finding Outliers in Excel**

**What are Outliers?**

**Why do we need to remove the Outliers?**

**=QUARTILE(A2:A14,1)**

**=QUARTILE(A2:A14,3)**

Lets calculate interquartile range (IQR). Because it is a range you just need to subtract values: Q3-Q1.

Calculating IQR gives us possibility to calculate lower and upper bound of data.

Lets us calculate the lower bound and upper bound values:

Lower bound = lower of Q1 or Q3 – 1.5 * IQR

Upper bound = max of Q1 or Q3 + 1.5 * IQR

Let us find the outlier by using the U bound and L bound: **=OR(A2<$F$2,A2>$G$2)**

Anything lower than lower bound and higher than upper bound is an outlier.

**Template**

You can download the Template here – Download

Further reading: Basic concepts Getting started with Excel Cell References