From ZCubes Wiki
Jump to navigation Jump to search

  • Parameters are set of numbers to calculate the Mode.
    • MODE(), returns the most common value in a data set.


  • 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 , First parameter is required.From the second parameter are optional.
  • In this function Parametrs 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.
    • : 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
    • : 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
    • : 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


  • The syntax is to calculate the mode of the given numbers in ZOS is .
    • Parameters are set of numbers to calculate the Mode.
  • For e.g.,MODE(10,6,2,6,7,7,8,4)


  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) = #N/A (MODE NOT FOUND)
  4. =MODE(0,1,2,3,0) = 0

Related Videos


See Also