Google Sheets-functie

MODE

Returns the most frequently occurring value in a dataset.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

MODE(number1, [number2], …)

The MODE function identifies the value that appears most often in a given set of numbers. If there are multiple values with the same highest frequency, it returns the first one encountered. Note that this function is available for compatibility with older versions of Excel; for newer versions, MODE.SNGL or MODE.MULT are recommended.

Argumenten

number1vereistThe first number or range of numbers for which you want to calculate the mode.
number2optioneelAdditional numbers or ranges up to 255 arguments.

Voorbeelden

=MODE(1, 2, 3, 3, 4)

Resultaat: 3

The number 3 appears twice, which is more frequent than any other number.

Veelgestelde vragen

What happens if there is no mode in the data?

If no two numbers are the same, the function returns the #N/A error.

Gerelateerde functies

MEDIAN AVERAGE