Understanding Box Plots in Excel

Dr. Gandhi's video tutorial explains how to create and interpret box plots using Microsoft Excel 2016. The tutorial covers calculating statistical values such as minimum, quartiles, median, and maximum, and demonstrates how to generate and format box plots. It also explains how to interpret the elements of a box plot, including identifying outliers using the interquartile range.

What version of Excel is used in the video for creating box plots?

• Excel 2013

• Excel 2021

• Excel 2016

• Excel 2019

What type of scores are used in the example data?

• Z scores

• T scores

• Raw scores

• Percentile scores

What is the mean of the T scores used in the example?

• 70

• 60

• 50

• 40

Which Excel function is used to calculate quartiles?

• STDEV

• QUARTILE.INC

• AVERAGE

• MEDIAN

What is the purpose of using the F4 key in Excel?

• To insert a chart

• To calculate the average

• To delete a row

• To make a cell reference absolute

How is the range of a dataset calculated?

• Sum of all values

• Average value

• Maximum value minus minimum value

• Maximum value plus minimum value

What type of chart is used to create a box plot in Excel?

• Line chart

• Pie chart

• Box and whisker chart

• Bar chart

What does the bottom of the rectangle in a box plot represent?

• Maximum value

• Minimum value

• Median

• Quartile 1

What is the significance of the line inside the rectangle of a box plot?

• It represents the mean

• It represents the median

• It represents the mode

• It represents the range

How does Excel determine if a value is an outlier?

• By checking if it is outside the interquartile range times 1.5

• By comparing it to the mean

• By comparing it to the median

• By checking if it is below the minimum