Manuals/calci/MODE

MODE(n1,n2,...)

• $n1,n2,...$ 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.
• $MODE(n1,n2,...)n1$ is required.$n2,n3$,...,are optional.
• In this function $n1,n2,...$ are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.when 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 in to 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

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