We have this set of data containing some number values for this example.

Excel will calculate the median and take it as middle number. We will insert a box and whisker chart for Excel data that has an even number set of data. Third Quartile (Q3) - It is the upper side of the box represents 75% of the data.Įxample 1: Insert a simple box and whisker chart.First Quartile (Q1) - It is the bottom side of the box represents 25% of the data.

Median is calculated by finding the two middle numbers from the selected data range and divide them from 2.

Middle - This is the median or middle value for the selected set of data that plots inside the box plot in the chart.

Max - It is the maximum value in the selected data set.

It is plotted at the far bottom of the chart.

Min - It is the minimum value in the selected data set.

This box and whisker chart contains five elements whose detail is as follows. Elements of box and Whisker chartīasically, the box and whisker chart has five numbers summery as it contains five elements in this chart, i.e., Min, Max, Median, Q1, and Q3. The line bar on the whisker represents the min and max value of the selected dataset. Q1 represents the first quartile and Q3 to third quartile.Ī vertical line goes from min to max through this box in the chart that is called whisker. This box is drawn from the first quartile to the third quartile. It means that - this chart is made up of whisker and box plot.īox plot represents the middle value or medium for the selected set of data.

This chart is divided into two parts: Whisker and Box plot. What is the box and whisker chart?īox and Whisker chart is also known as a box plot, and it is a way to represent the spread and center of a data set. This chapter will take you to each step of creating box and whisker chart and help you understand it. Box and Whisker chart is also called box chart. Box represents to the middle value between the selected range and the whisker chart represents the minimum and maximum value of the selected range. You might not get the point of the box plot right now, but by following this chapter below, you will get it much better.Įxcel does not have box plot, but it has a chart called box and whisker chart that has two charts in one. With the help of a box plot, you can see the distribution of numbers in data. When you do statistical analysis, you may require a standard box plot to show the distribution of a set of data.

How to make a boxplot in excel 2010