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.