Difference between revisions of "Manuals/calci/MODE"

Revision as of 02:42, 3 January 2014

MODE(n1,n2,...)

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 $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.
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 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

@@ Line 6: / Line 6: @@
 *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(n1,n2...)</math>, <math>n1</math> is required.<math>n2,n3...</math> are optional.
-*In this function <math> n1,n2...</math> 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.
+*In this function <math> n1,n2...</math> are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
-*This function will show the result as Error ,when the numbers are error values or text that cannot change in to numbers.
+*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 in to numbers.
 *The MODE function measures central tendency.
 *The three most common measures of central tendency are: A.M, Median,& Mode.