MODE

Get the mode of a group of numbers

Example

Related Functions

MODE

Summary 

The Excel MODE function returns the most frequently occurring number in a numeric data set. 

Purpose 

Get the mode of a group of numbers

Return value 

A number representing the mode.

Syntax 

=MODE (number1, [number2], ...)

Arguments 

  • number1 - A number or cell reference that refers to numeric values.
  • number2 - [optional] A number or cell reference that refers to numeric values.

Usage notes 

The MODE function returns the mode (most frequently occurring number) in a group of supplied arguments. For example, =MODE(1,2,4,4,5,5,5,6) returns 5.

Numbers can be supplied as numbers, ranges, named ranges, or cell references that contain numeric values. Up to 255 numbers can be supplied.

If the set of supplied numbers does not contain any duplicates, MODE will return #N/A

Note: MODE is now classified as a "compatibility function". Microsoft recommends that MODE.SNGL or MODE.MULTI be used instead.

0 votes. 0 / 5