Which of the following functions calculates the average of a set of numbers?

The function that calculates the average of a set of numbers is AVERAGE(). This function takes a range of cells as its argument and computes the mean of the values within that range. This is useful for various mathematical and statistical analyses where you need to determine the central tendency of a data set.

For example, if you input a series of numbers in a range, applying the AVERAGE() function to that range will provide a single number that represents the arithmetic mean of those numbers, making it a vital function for summing up and analyzing data effectively.

Other functions like SUM() add up all the numbers in the specified range, COUNT() tallies the number of cells that contain numbers, and MEDIAN() finds the middle value of a data set when arranged in order. While these functions serve important roles in data processing and analysis, they do not calculate the average in the same manner as AVERAGE() does.