Difference between revisions of "Manuals/calci/MODE"

From ZCubes Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
<div style="font-size:30px">'''MODE(n1,n2,...)'''</div><br/>
+
<div style="font-size:30px">'''MODE()'''</div><br/>
−
*<math>n_1,n_2,...</math> are numbers to calculate the Mode.
+
*Parameters are set of numbers to calculate the Mode.
 +
**MODE(), returns the most common value in a data set.
  
 
==Description==
 
==Description==
 
*The mode is the number repeated most often in the given set of numbers.
 
*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''.
 
*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 <math>MODE(n_1,n_2...)</math>, <math>n_1</math> is required.<math>n_2,n_3...</math> are optional.
+
*In <math>MODE()</math>, First parameter is required.From the second parameter are optional.
−
*In this function <math> n_1,n_2...</math> are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
+
*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.
 
*If the referred array contains text,logical values or empty cells, those values are ignored.
 
*This function will show the result as Error
 
*This function will show the result as Error
Line 17: Line 18:
  
 
==ZOS==
 
==ZOS==
−
*The syntax is to calculate the mode of the given numbers in ZOS is <math>MODE(n1,n2,...)</math>.
+
*The syntax is to calculate the mode of the given numbers in ZOS is <math>MODE()</math>.
−
**<math>n_1,n_2,...</math> are numbers to calculate the Mode.
+
**Parameters are set of numbers to calculate the Mode.
−
*For e.g.,mode(10,6,2,6,7,7,8,4)
+
*For e.g.,MODE(10,6,2,6,7,7,8,4)
  
 
==Examples==
 
==Examples==
 
#=MODE(2,3,2,2,4,5) = 2
 
#=MODE(2,3,2,2,4,5) = 2
 
#=MODE(1.21,1.01,1.5,1.21,1.25,1.21) = 1.21
 
#=MODE(1.21,1.01,1.5,1.21,1.25,1.21) = 1.21
−
#=MODE(2,1,4,3) = NAN
+
#=MODE(2,1,4,3) = #N/A (MODE NOT FOUND)
 
#=MODE(0,1,2,3,0) = 0
 
#=MODE(0,1,2,3,0) = 0
  

Latest revision as of 03:23, 13 August 2020

MODE()


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

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 , 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

ZOS

  • 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)

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

Related Videos

MODE

See Also

References

Mode



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/MODE&oldid=214905"