Box And Whisker Diagram Excel. Creating a box and whisker chart. The graph was initially called boxplot.
On the insert tab in the charts group click the statistic chart symbol. Since then it is being used in statical plotting and graphing. The box and whisker chart was invented by john tukey in 1977.
How to make a box and whisker plot in excel use excel s box and whisker plot maker.
They show you the distribution of a data set showing the median quartiles range and outliers. Box and whisker charts box plots are commonly used in the display of statistical analyses. 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. Excel doesn t offer a box and whisker chart.
