Box and Whisker
What's Inside the Box and Whisker Plot Template?
Details | 2 Sheets
Supported Versions | Excel 2010, 2013, 2016, 2019, Office 365 (Mac)
Category | Operations, Data Analysis
Tags | 5 Number Summary, Mean, Median, Average, Quartile
Why Professionals Choose Simple Sheets
It's simple. Access to the largest library of premium Excel Templates, plus world-class training.
100+ Professional Excel Templates
Optimized for use with Excel. Solve Excel problems in minutes, not hours.
World-Class Excel University
With our university, you'll learn how we make templates & how to make your own.
Inside Our Box and Whisker
Society loves talking about averages. We understand why, but any statistician will tell you how misleading averages can be without overall context of distribution and outliers. That’s where our Box and Whisker Plot Excel Calculator comes in handy. It automates your Box and Whisker Plot charting and creates a five number summary for your inputs to help you understand outliers, dispersion and skewness in your data.
A five-number summary is useful for understanding the distribution of your data set. It contains five numbers, hence the name; the minimum, the first quartile (25%), the median, the third quartile (75%) and the maximum.
These points will be charted on the Box and Whisker Plot. The lines outside the box display the range below the first quartile or above the third quartile. The minimum and maximum points help you understand if there are outliers within your dataset.
Before we dive into the brief instructions on how to utilize this template, you may also want to check out our Stratification Data and Panel Analysis templates. These spreadsheets are designed to quickly calculate your numbers and show relationships between sets of data via tables and graphs.
There is only one sheet in this template so we’ll start there, appropriately named Box and Whisker Plot. There are two tables for you to input your Data Sets. Simply, plug in your data to one of the tables or both if you are working with multiple data sets.
Your data will be automatically chartered above, using different colored symbols to represent different points in your five number summary. To the right of the chart is a five number summary from your dataset.
One of my favorite ways to use this spreadsheet is for analyzing fantasy football data. A couple of amazing games can skew a player's data to make them appear more productive than they actually are especially because of how small a sample size is (16 games).
Go beyond the average and see the truth behind the distribution with this easy to use Box and Whisker Plot generator.