Difference between revisions of "Manuals/calci/MODE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''MODE''' ('''n1''', n2,...) where n1,n2… are the arguments to calculate the mode. </div> ---- <div id="1Spac...") |
|||
| (16 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''MODE()'''</div><br/> |
| + | *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 <math>MODE()</math>, 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. | ||
| + | **<math>A.M</math>: 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 | ||
| + | **<math>Median</math>: 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 | ||
| + | **<math>Mode</math>: 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 <math>MODE()</math>. | |
| − | + | **Parameters are set of numbers to calculate the Mode. | |
| + | *For e.g.,MODE(10,6,2,6,7,7,8,4) | ||
| − | + | ==Examples== | |
| + | #=MODE(2,3,2,2,4,5) = 2 | ||
| + | #=MODE(1.21,1.01,1.5,1.21,1.25,1.21) = 1.21 | ||
| + | #=MODE(2,1,4,3) = #N/A (MODE NOT FOUND) | ||
| + | #=MODE(0,1,2,3,0) = 0 | ||
| − | + | ==Related Videos== | |
| − | |||
| − | |||
| − | + | {{#ev:youtube|9TWBq88Bpls|280|center|MODE}} | |
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/AVERAGE | AVERAGE ]] | |
| − | + | *[[Manuals/calci/MEDIAN | MEDIAN ]] | |
| − | + | *[[Manuals/calci/HARMEAN | HARMEAN ]] | |
| − | |||
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Mode_(statistics) Mode] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | | | ||
| − | |||
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
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
, First parameter is required.From the second parameter are optional.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
: 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 2ZOS
- 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
- =MODE(2,3,2,2,4,5) = 2
- =MODE(1.21,1.01,1.5,1.21,1.25,1.21) = 1.21
- =MODE(2,1,4,3) = #N/A (MODE NOT FOUND)
- =MODE(0,1,2,3,0) = 0
Related Videos
See Also
References