Manuals/calci/MODE
MODE (n1, n2,...) where n1,n2… are the arguments to calculate the mode.
It calculates the most frequently occurring, or repetitive, value in an array or range of data.
· When the data set contains no duplicate data points, mode shows error.
MODE
|
7.8
|
9
|
9
|
12
|
34
|
9
|
Lets see an example in (Column1 Row 1:Column1Row6)
MODE (n1, n2….)
i.e. MODE (C1R1: C1R6) is 9
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | |
Row1 | 7.8 | 9 | |
Row2 | 9 | ||
Row3 | 9 | ||
Row4 | 12 | ||
Row5 | 34 | ||
Row6 | 9 |