Measures of Central Tendency and Excel Functions

The video tutorial explains how to use Excel to calculate frequency, sum, mean, median, and mode. It demonstrates the use of formulas to sum columns and calculate the mean by dividing the total by the number of entries. The tutorial also covers finding the median by identifying the middle value in a dataset and discusses how changes in data affect these calculations. Practical examples in Excel illustrate these concepts, emphasizing the importance of understanding data distribution and the impact of outliers.

What does the fourth column in the table represent?

• The maximum number of visits recorded

• The average number of visits per person

• The frequency of visits multiplied by the number of people

• The total number of visits

Which Excel function is used to sum up a range of cells?

• SUM

• PRODUCT

• COUNT

• AVERAGE

How do you calculate the mean of a dataset?

• Add the total to the number of data points

• Divide the total by the number of data points

• Subtract the number of data points from the total

• Multiply the total by the number of data points

What symbol is used for division in Excel formulas?

• The percent (%)

• The backslash (\)

• The asterisk (*)

• The slash (/)

How do you find the median in a dataset with an odd number of values?

• Select the lowest value

• Select the middle value

• Choose the highest value

• Find the average of all values

What do you do if there are two middle numbers when finding the median?

• Ignore both numbers

• Find the average of the two numbers

• Choose the lower number

• Choose the higher number

How can you find the median without listing all numbers?

• By using the mode

• By using the range

• By using the mean

• By using the frequency distribution

What happens to the mean if a single data point is significantly increased?

• The mean remains the same

• The mean decreases

• The mean becomes zero

• The mean increases

How does a large outlier affect the mode?

• The mode increases

• The mode decreases

• The mode remains unchanged

• The mode becomes zero

Which measure of central tendency is least affected by extreme values?

• Median

• Range

• Mean

• Mode