## Box and Whisker Plot MakerExcel Template

Create a 5-number summary in seconds for up to two datasets with our Box and Whisker Plot Maker Excel Template. Easily identify trends and distribution with our simple to use formulas and chart.

## 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

#### 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.

#### How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

# Excel Template

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.

## \$49

(no bundle savings)

• 45+ Customizable Excel Templates
• One User
• One-Time Payment

## \$199

(\$699 bundle savings)

• 100+ Customizable Excel Template
• Personal Membership Portal
• Excel, PowerPoint, & Word 101 Courses (\$199 bundle savings)
• Two Users
• One-Time Payment