Loading...

How to Create an Excel Box and Whisker Chart (Excel Box Plot)

178,962 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Sep 27, 2010

http://blog.contextures.com/archives/...
A box and whisker chart can give you a snapshot of each series in your data. What are the highest and lowest numbers? What was the median number? What was the range of numbers on either side of the median?
In this example, I create a box and whisker chart from airport security checkpoint wait time data. It shows which checkpoint has the longest wait times, and which is fastest.

To make the job of creating a box plot faster, you can use the box and whisker chart utility. Click the link to my blog article, and read the details about Jon Peltier's box plot utility.

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...