# How to make a box and whisker plot?

## How to make a box and whisker plot?

Step One: The first step to creating a box and whisker plot is to arrange the values in the data set from least to greatest.

• Step Two: Identify the upper and lower extremes (the highest and lowest values in the data set). The lower extreme is the smallest value,which is 5 in this example.
• Step Three: Identify the median,or middle,of the data set. In this example,the median is 17.
• Step Four: Identify the upper and lower quartiles. To find the lower quartile and the upper quartile,start by splitting the data set at the median into lower and upper
• Step Five: To construct a box and whisker plot,start by drawing a number line that fits the data set.
• ## Who uses box and whisker plots?

The box-and-whisker plot is an exploratory graphic, created by John W. Tukey, used to show the distribution of a dataset (at a glance). Think of the type of data you might use a histogram with, and the box-and-whisker (or box plot, for short) could probably be useful.

What are the Whiskers in box plot?

In a box and whisker plot: the ends of the box are the upper and lower quartiles, so the box spans the interquartile range the median is marked by a vertical line inside the box the whiskers are the two lines outside the box that extend to the highest and lowest observations.

How to make a box and whisker plot in Excel?

Add a blank row in the box plot’s data range.

• Type the label, “Average” in the first column
• In the remaining columns, enter an AVERAGE formula, to calculate the average for the data ranges.
• Copy the cells with the Average label, and the formulas
• Click on the chart, and on the Ribbon’s Home tab, click the arrow on the Paste button
• Click Paste Special.
• In the Paste Special dialog box, choose “New Series”, Values in Rows, and “Series…