All articles with 'percentileif' Tag
{ 22 Comments }
How to make Box plots in Excel [Dashboard Essentials]
Published on Jul 31, 2012 in Charts and Graphs
![How to make Box plots in Excel [Dashboard Essentials]](https://img.chandoo.org/dashboards/bp/box-plot-in-excel-how-to.png)
Whenever we deal with large amounts of data, one of the goals for analysis is, How is this data distributed?
This is where a Box plot can help. According to Wikipedia, a box plot is a convenient way of graphically depicting groups of numerical data through their five-number summaries: the smallest observation (sample minimum), lower quartile (Q1), median (Q2), upper quartile (Q3), and largest observation (sample maximum)
Today, let us learn how to create a box plot using MS Excel. You can also download the example workbook to play with static & interactive versions of box plots.
Continue »