Manuals/calci/MODE

MODE(n1,n2,...)

• $n_{1},n_{2},...$ are numbers to calculate the Mode.

Description

• The mode is the number repeated most often in the given set of numbers.
• The mode is not necessarily unique.The set of numbers having two modes is called bimodal. Also the set of numbers Having more than two modes is called multimodal.
• In $MODE(n_{1},n_{2}...)$, $n_{1}$ is required.$n_{2},n_{3}...$ are optional.
• In this function $n_{1},n_{2}...$ are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
• If the referred array contains text,logical values or empty cells, those values are ignored.
• This function will show the result as Error

when the numbers are error values or text that cannot change into numbers.

• The MODE function measures central tendency.
• The three most common measures of central tendency are: A.M, Median,& Mode.
  • $A.M$: It is calculating by adding the given set of numbers and divided by the count of the given set of numbers. E.g:Average of 2,4,2,7,2,3 and 5 is 3.6
  • $Median$: It is the middle number of a sorted list(Ascending order) of numbers. E.g:The median of 2,2,2,3,4,5,7 is 3
  • $Mode$: It is the most frequently repeated number in a given set of numbers. E.g.The mode of 2,2,2,3,4,5 and 7 is 2

ZOS Section

• The syntax is to calculate the mode of the given numbers in ZOS is $MODE(n1,n2,...)$.
  • $n_{1},n_{2},...$ are numbers to calculate the Mode.
• For e.g.,mode(10,6,2,6,7,7,8,4)

Examples

1. =MODE(2,3,2,2,4,5) = 2
2. =MODE(1.21,1.01,1.5,1.21,1.25,1.21) = 1.21
3. =MODE(2,1,4,3) = NAN
4. =MODE(0,1,2,3,0) = 0

See Also

• AVERAGE
• MEDIAN
• HARMEAN

References

Mode