Documentation/How Tos/Calc: MODE function

MODE

Returns the most common value in a data set.

Syntax:

MODE(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers.

MODE returns the number that occurs most often, or if more than one number occurs that many times, the smallest such number. If no number occurs more than once, MODE returns an error.

Example:

MODE(3; 7; 3; 9; 9; 3; 5; 1; 8; 5)

returns 3, the number occuring most often.

See also:

AVERAGE, AVERAGEA, MEDIAN

Statistical functions