Understanding Mean, Median, Mode, and Range

This video tutorial explains how to calculate the mean, median, mode, and range using Excel. It covers the process of finding the average by summing values and dividing by the count, determining the median by identifying the middle number, finding the mode as the most frequent number, and calculating the range by subtracting the minimum from the maximum value. The tutorial provides step-by-step instructions for using Excel functions to perform these calculations.

What is the formula to calculate the mean of a set of numbers?

• Sum of numbers divided by the number of numbers

• Difference between the highest and lowest numbers

• Number that appears most frequently

• Middle number in a sorted list

Which Excel function can be used to find the total of a column of numbers?

• AVERAGE

• MEDIAN

• COUNT

• SUM

How do you determine the median in a data set with an even number of values?

• Select the lowest number

• Select the highest number

• Average the two middle numbers

• Choose the middle number

What is the median of the following numbers: 72, 74, 79, 81, 85, 85, 86, 96?

• 83

• 85

• 81

• 86

Which number is the mode in the data set: 79, 82, 82, 82, 86, 86, 88, 90?

• 79

• 82

• 86

• 90

What does the mode represent in a data set?

• The average of all numbers

• The middle number

• The difference between the highest and lowest numbers

• The number that appears most frequently

How is the range of a data set calculated?

• By identifying the most frequent number

• By subtracting the minimum value from the maximum value

• By selecting the middle number

• By finding the average of all numbers

Which Excel function is used to find the maximum value in a data set?

• AVERAGE

• MODE

• MAX

• MIN

What is the range of the following numbers: 72, 74, 79, 81, 85, 85, 86, 96?

• 22

• 26

• 24

• 14

Which of the following is NOT a measure of central tendency?

• Mean

• Median

• Mode

• Range