Creating Box Plots in Excel

This video tutorial demonstrates how to create a box plot in Excel for Mac. It covers selecting data, inserting a box and whisker plot, and adjusting axis options for clarity. The tutorial concludes with final adjustments and a summary of the process.

What is the first step in creating a box plot in Excel for Mac?

• Insert a pie chart

• Select the data column

• Open a new Excel file

• Save the document

How many columns of data can you use to create a box plot in Excel for Mac?

• Only one column

• Two columns

• Five columns

• Multiple columns

Which button do you hold down to select the data?

• Right mouse button

• Left mouse button

• Middle mouse button

• Shift key

Which menu option do you select to insert a box and whisker plot?

• Review

• Data

• Insert

• Home

What type of chart is a box and whisker plot categorized under in Excel?

• Line chart

• Statistical chart

• Pie chart

• Bar chart

What is the first action to take after selecting the data?

• Open a new worksheet

• Click on Insert

• Go to the Home tab

• Save the document

What should you do if the box plot does not display correctly?

• Adjust the axis options

• Restart Excel

• Change the chart type

• Re-enter the data

What is the correct maximum value to set for the axis in the example?

• 50

• 75

• 100

• 150

What is the correct minimum value to set for the axis in the example?

• 10

• 0

• 30

• 20

What is the purpose of adjusting the axis options?

• To add more data

• To correct the data range

• To change the chart type

• To change the chart color