A box plot is a graph that shows the frequency of numeric data values for a given variable. It indicates where most of the data is grouped and how much variation there is in the process. It is most useful when comparing between several data sets. This template allows you to enter up to 70 individual data points for two data sets, and the box plots will be displayed automatically to reflect your data.

This template runs in Excel, and you can use and modify it to suit your specific needs. For example, you may add additional data rows if your data per data set is larger than 70. You may also add additional data sets as required if you need to study or compare more than two.

In addition to displaying the box plots, this template will also generate a summary of descriptive statistics related to your data such as the mean and standard deviation. Note that this template is limited and intended to be used by individuals new to statistics. Therefore, it’s recommended that you perform your analysis using a more advanced statistical software program such as Minitab.