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...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''MODE(n1,n2,...)'''</div><br/> |
| + | *<math>n1,n2,...</math> are numbers to calculate the Mode. | ||
| − | |||
| − | </ | + | ==Description== |
| − | + | *The mode is the number repeated most often. | |
| − | < | + | *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''. |
| + | *<math>MEDIAN(n1,n2,...)n1</math> is required.<math>n2,n3</math>,...,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. | ||
| + | **<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 | ||
| − | + | ==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)=NAN | ||
| + | #MODE(0,1,2,3,0)=0 | ||
| − | |||
| − | |||
| − | |||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/AVERAGE | AVERAGE ]] | ||
| + | *[[Manuals/calci/MEDIAN | MEDIAN ]] | ||
| + | *[[Manuals/calci/HARMEAN | HARMEAN ]] | ||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 03:28, 30 December 2013
MODE(n1,n2,...)
- are numbers to calculate the Mode.
are numbers to calculate the Mode.
Description
- The mode is the number repeated most often.
- 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.
- is required.,...,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.
- : 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
is required.
,...,are optional.
: 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 2Examples
- 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)=NAN
- MODE(0,1,2,3,0)=0