All articles with 'percentileif' Tag

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]

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 »