To make a box and whisker plot, start by organizing the numbers in your data set from least to greatest and finding the median. Then, find the first quartile, which is the median of the beginning of the data set, and the third quartile, which is the median of the end of the data set.
In some box plots, the minimums and maximums outside the first and third quartiles are depicted with lines, which are often called whiskers. While Excel 2013 doesn't have a chart template for box plot, you can create box plots by doing the following steps:
What is a box and whisker plot? A box and whisker plot—also called a box plot—displays the five-number summary of a set of data. The five-number summary is the minimum, first quartile, median, third quartile, and maximum. In a box plot, we draw a box from the first quartile to the third quartile. A vertical line goes through the box at the median.
A Box Plot is also known as a Box and Whisker Plot and it is a graphical tool used to understand the distribution of numerical data. It shows the median, quartiles and possible outliers in a simple visual form.