AVERAGE, MODE, MEAN, And MEDIAN

Average

Description
Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

Syntax
AVERAGE(number1, [number2], …)

The AVERAGE function syntax has the following arguments:

Number1 Required. The first number, cell reference, or range for which you want the average.

Number2, … Optional. Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.

Mode

Description
Returns the most frequently occurring, or repetitive, value in an array or range of data.

IMPORTANT:
This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.

Syntax

MODE(number1,[number2],…)

The MODE function syntax has the following arguments:

Number1 Required. The first number argument for which you want to calculate the mode.

Number2,… Optional. Number arguments 2 to 255 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.

Median

Description
Returns the median of the given numbers. The median is the number in the middle of a set of numbers.

Syntax
MEDIAN(number1, [number2], …)

The MEDIAN function syntax has the following arguments:

Number1, number2, … Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want the median.