Box Plot Concepts in Excel

This tutorial demonstrates how to create and interpret box plots using Microsoft Excel. It covers the steps to create a simple box plot, interpret its elements, and handle outliers. Additionally, it explains how to plot multiple box plots side by side and customize them. The tutorial uses Excel 365 Pro Plus and provides tips for managing outliers and adjusting plot settings.

What is another name for a box plot?

• Pie chart

• Box and whisker plot

• Histogram

• Scatter plot

Which Excel version introduced the option to insert a statistic chart?

• Excel 2019

• Excel 2016

• Excel 2013

• Excel 2010

What does the line within the box of a box plot represent?

• Mean

• Median

• Mode

• Range

What symbol does Excel use to mark the mean on a box plot?

• Triangle

• X

• Square

• Circle

How is the interquartile range calculated?

• Difference between maximum and minimum

• Sum of first and third quartiles

• Average of all data points

• Difference between third and first quartiles

What is the threshold for identifying an outlier below the box plot?

• 2 times the interquartile range added to the third quartile

• 2 times the interquartile range subtracted from the first quartile

• 1.5 times the interquartile range added to the third quartile

• 1.5 times the interquartile range subtracted from the first quartile

How can you remove outliers from a box plot in Excel?

• Use a different Excel version

• Change the chart type

• Uncheck the show outlier points option

• Delete the data points

What should you do if you want to change how quartiles are calculated in a box plot?

• Add more data points

• Adjust the data range

• Use a different chart type

• Change the quartile calculation option

What is the purpose of adding a legend to a box plot?

• To identify which box plot corresponds to which group

• To indicate the data range

• To display the median value

• To show the mean value

How can you show group names on the x-axis instead of using a legend?

• Add a text box manually

• Use a different Excel version

• Change the chart type

• Adjust the data layout in the sheet