Excel Statistics Functions

Which function calculates the mean of a range of data in Excel?

• =AVERAGE()

• =MIN()

• =MAX()

• =SUM()

What function can be used to find the middle value in a data series in Excel?

• =AVERAGE()

• =MEDIAN()

• =MODE()

• =SUM()

Which Excel function is used to calculate the most commonly occurring value in a data series?

• =MODE.RANGE()

• =MODE.MULT()

• =MODE.SNGL()

• =MODE.AVG()

What does the standard deviation function STDEV.P measure in Excel?

• It measures the average of data points.

• It measures the highest data point in the set.

• It measures the spread of data points around the mean.

• It measures the lowest data point in the set.

What does the COUNT function do in Excel?

• Multiplies the values in a specified range

• Finds the average of values in a specified range

• Sorts the values in a specified range

• Counts the number of cells that contain numbers within a specified range.

How is the COUNTIF function used in Excel?

• The COUNTIF function divides two arguments

• The COUNTIF function multiplies two arguments

• The COUNTIF function calculates the average of two arguments

• The COUNTIF function return the number of cells in a range that match a single condition

When would you use the COUNTIFS function in Excel?

• When you need to find the maximum value of cells that meet multiple criteria.

• When you need to count cells that meet multiple criteria.

• When you need to average cells that meet multiple criteria.

• When you need to sum cells that meet multiple criteria.

Explain the difference between COUNTIF and COUNTIFS functions in Excel.

• COUNTIF and COUNTIFS functions are identical in Excel.

• COUNTIF can only be used with text values, while COUNTIFS can only be used with numerical values.

• COUNTIF counts cells based on multiple conditions, whereas COUNTIFS counts cells based on a single condition.

• COUNTIF counts cells based on a single condition, whereas COUNTIFS counts cells based on multiple conditions.

Calculate the mean of the following numbers in Excel: 10, 15, 20, 25, 30

• 20

• 28

• 18

• 22

Find the median of the following numbers in Excel: 5, 10, 15, 20, 25

• 15

• 22

• 18

• 10