Interquartile Range (IQR), Outlier Detection, and Boxplots in Excel

This video demonstrates how to use the interquartile range (IQR) and boxplots to detect outliers and compare two variables using Microsoft Excel. The components of the boxplot such as the interquartile range, whiskers, median, mean, and outliers are reviewed.

[@fishwatch4733]

Hi sir, please make a video how do you make that boxplot in excel showing outliers. Thanks

[@monsieurlepenguin6602]

Love your psychological analysis videos and love these too. Thanks for helping me pass my business stats class

[@waqarazeemjadoon]

Dear Dr. Grande thank you very much your explanation, which make it quite easy for me to understand the Box & whisker plots. However, if it is not too much bothering, I would love to ask for your guidance on "how to draw data points on box and whisker plots in excel 2016". I want to show my data points on box and whisker plots but couldn't do so.

[@omprakashrai8211]

I get lower limit as negative since q1 is lesser dan iqr*1.5? What do we do under des circumstances

[@jitendraupadhyay1584]

In your above example, lets say those 50 data points are for different people(Assume names to be 1-50). Now when I hover over outliers, would it be possible to show the person name(1-50 in this case). Right now it shows the value.

[@karlaboeta5470]

How did you create the boxplot showing the individual values and outliers? Thank you

[@DrGrande]

Using Excel 2016, on the ribbon click Insert > Insert Statistic Chart > Box and Whisker.

[@tbabelemon686]

what of for excel 2013

[@deepikabhowmick6414]

What is the multiplier 1.5? how did you arrive to this #?

[@nakkachaitanya]

Yeah, even I have the same question. Could you please let me know why we multiplied by 1.5?

[@user-tf7te5fs2n]

What is the benefit of inter quartile for analyzing data?

[@kar2194]

To identify outliers, put the IQR into this formula, 1.5 * IQR +/- Q (1 or 3). You have your Q1 and Q3, 25th percentile and 75th percentile, you can get them using the cell formula in excel. Any numbers outside of this range is outlier.