Documentation/Calc Functions/MODE.SNGL

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

MODE.SNGL

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.SNGL(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.
Gnome-dialog-warning.svg

Warning:
If the data set contains no duplicate data points, MODE.SNGL returns the #VALUE! error value.


Additional details:

None

Examples:

Formula Description Returns
=MODE.SNGL(A1:A10) where A1:A10 contains 1,2,3,2,4,1,3,5,6,3 The function returns the most common value amongst the passed arguments 3
=MODE.SNGL(1,2,3,2,4,1,3) The function returns the most common value amongst the passed arguments. Here since there are three values with the highest frequency so the function returns the smaller value. 1

Related LibreOffice functions:

MEDIAN

AVERAGE

MODE.MULT

MODE

ODF standard:

None

Equivalent Excel functions:

MODE.SNGL