The calculation performed by MEDIAN varies according to the number of numeric values provided.
When the number is odd, MEDIAN returns the middle number in the group.
When the number is even, MEDIAN returns the average of the two numbers in the middle.
The MEDIAN function takes multipleargumentsin the formnumber1,number2,number3, etc.
Arguments can be a hardcoded constant, a cell reference, or a range, in any combination.
MEDIAN ignores empty cells, text values, and the logical values TRUE and FALSE.
The MEDIAN function will accept up to 255 separate arguments.
MODE Function
The Excel MODE function returns the most frequently occurring number in a numeric data set.
For example, =MODE(1,2,4,4,5,5,5,6) returns 5.
