Finding Outliers in Excel
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.