In some cases, there are no whiskers or only one whisker. The whiskers of the box plot are lines that indicate the minimum and maximum values of the data distribution that are outside the box. The box indicates the part of the data distribution that is most concentrated. The box spans the first and third quartiles and also has a line in it that defines the median which is also the second quartile. The two major components as the nickname implies are the box and the whiskers. The box plot or “box and whisker” chart consists of two major components and divides numerical data into four parts known as “quartiles”. Here’s How to Create a Box Plot in Microsoft Excel This tutorial will take us through what a box plot really is, how to create box plots using Microsoft Excel, as well as how results can be interpreted. It proffers a cool way to visualize the summary of datasets and gain more insights into how the data is distributed. The Box plot is also known as “box and whisker chart” perhaps because of its shape and appearance. Researchers have to work with a lot of statistical data and in most cases need to find measures of central tendency like the mean or median of a data set, measures of dispersion like range and variance, or signs of skewness.Ĭreating a Box Plot in Microsoft Excel comes in very handy as is makes easy to quickly identify some of these parameters in a visual summary without hassles.

How to create a boxplot in excel 2016