Documentation/Calc Functions/MODE

Function name:
MODE

Category:
Statistical Analysis

Summary:
Finds the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when no value appears more than once.

Syntax:
MODE(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns a real number which is the most common value in the list of arguments.

Arguments:
Number 1, Number 2, …, Number 255 are numbers, references to cells or to cell ranges of numbers.


 * If any of the arguments contain text value being passed directly then the function returns a name(#NAME?) error and if with double quotes a simple error value(Err:504) is returned.
 * If a cell contains text, error value, or empty cells, then the function ignores these values. However, for logical values, TRUE is considered as 1 and FALSE as 0.
 * If a cell has 0 then the function includes it.

Additional details:
None

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/MEDIAN MEDIAN]

[[Special:MyLanguage/Documentation/Calc_Functions/AVERAGE AVERAGE]

[[Special:MyLanguage/Documentation/Calc_Functions/MODE.SNGL MODE.SNGL]

[[Special:MyLanguage/Documentation/Calc_Functions/MODE.MULT MODE.MULT]

ODF standard:
Section 6.18.50, part 2

Equivalent Excel functions:
MODE