The bottom line that is connected with box is representing the minimum value in data set. But what is the interpretation of this chart. So Now we have the box and whisker plot in excel. Interpretation of Box and Whiskers chart in excel:
Go to Insert tab ? Charts ? Statistical Charts ? Box and Whiskers chart.
BOXPLOT IN EXCEL 2016 FOR MAC HOW TO
Now let's learn, how to make a box and whisker plot in excel.įollow these steps how to create a boxplot in excel: To make it easy to understand, I have sorted it already. This data is sorted but it does not need to be. To understand the the box plot in excel, here a I have a simple number series in range A2:A6. They are basically minimum (0th percentile) and maximum (100th percentile) value in data.īox and Whiskers Chart with Simple Numbers The bottom line of box is median of first quartile and upper line of box is median of other half (3rd quartile).Īn x or cross represent the mean of data.Īny value that goes beyond the 1st and 3rd quartile is represented as whiskers. The line itself is median of the whole data set. a line dividing the box into 1st quartile and 3rd quartile. The box itself represents the first range between first and 3rd quartile. It comes under statistical charts category.Ī Box and Whiskers plot consists a box.
The Box and Whiskers chart is used in analytics to visualise mean, median, upper bound and lower bound of a data set. In this article, we will learn how to create a box and whiskers chart in excel. Since then, it is being used in statical plotting and graphing. The Box and Whisker chart was invented by John Tukey in 1977.