The interquartile range (IQR) is the distance between the third quartile and the first quartile. Excel considers any data value to be an “outlier” if it is 1.5 times the IQR larger than the third quartile or 1.5 times the IQR smaller than the first quartile. The screenshot below shows the exact formulas you can use in Excel to find each of these values: For this particular example, there are no outliers. This is the largest value in the dataset that is not considered an outlier. This is the value of the third quartile in the dataset. Mean: 14.75. The tiny “x” in the middle of the box represents the mean of the dataset. Median: 15. This is the median value in the dataset. Q1: 5.25. This is the value of the first quartile in the dataset. This is the smallest value in the dataset that is not considered an outlier. Here is how to interpret the labels in the box plot: The following labels will automatically appear: Then click the green plus sign that appears in the top right corner. To see the actual values that are summarized in the box plot, click on the plot. On the Insert tab, go to the Charts group and click the Statistic Chart symbol.Ĭlick Box and Whisker. Perform the following steps to create a box plot in Excel. This tutorial explains how to create and interpret box plots in Excel. A box plot is a type of plot that we can use to visualize the five number summary of a dataset, which includes:

Create a boxplot in excel 2016