NO BS: Construct a Box-and-Whisker Plot in Excel

This video tutorial by Kevin Tolkoff demonstrates how to create a box and whisker plot using Microsoft Excel's data analysis tool pack. The tutorial covers the steps to construct the plot, explains the components such as quartiles and median, and provides tips on customizing the plot for better visualization. The video also highlights differences between Mac and Windows versions of Excel and emphasizes the importance of downloading the data analysis tool pack for certain features.

What is the first step in constructing a box and whisker plot using Microsoft Excel?

• Highlight only numerical data

• Download the data analysis tool pack

• Sort the data manually

• Create a new Excel sheet

Which menu option in Excel allows you to insert a box and whisker plot?

• Review

• Data

• Insert

• Home

In a box and whisker plot, what does the line inside the box represent?

• Range

• Mean

• Mode

• Median

What percentage of the data is represented by the interquartile range in a box and whisker plot?

• 75%

• 50%

• 25%

• 100%

Why is it beneficial to have a vertical orientation for box and whisker plots?

• It uses less space

• It provides better resolution between median and mean

• It is the default setting in Excel

• It is easier to print