Documentation/Calc Functions/MODE.MULT

Function name:
MODE.MULT

Category:
Statistical Analysis

Summary:
Finds the most common values in a data set. An error occurs when no value appears more than once. It is an array function, and the most common values are returned in a vertical array.

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

Returns:
Returns a vertical array of real numbers which are the most common values in the list of arguments. The function will return more than one value when there are multiple modes sharing the same frequency of occurrence.

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:

 * The number of values that are returned depends on
 * how many different values are considered to be the most common, and
 * how big the defined array is
 * The function returns the required values in the cells selected as an array and passed for the function but if more cells are included in the array than values, then the remaining cells contain #N/A.

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 MODE]

ODF standard:
None

Equivalent Excel functions:
MODE.MULT