[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

MODE

Syntax:

MODE ( argument-list )

Description: Computes the most frequently occurring of the numeric values of its arguments. If the set of values contains more than one most-frequent value, the first occurrence of any most-frequent value in the list is used as the result.

Arguments:

Name

Type

Description

argument-list

logical, number, name, arrays, reference to number. Any argument can be an array or a reference to an array.

The arguments in argument-list designate the values whose mode is to be computed. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

 

Return Type and Value: number – The most frequently occurring of the values of its arguments.

However, if the data set contains no duplicate data points, #N/A is returned.

[Example:

MODE(9,1,5,1,9,5,6,6) results in 9
MODE(1,9,5,1,9,5,6,6) results in 1
MODE(5,1,9,5,1,9,6,6) results in 5

end example]