Difference between revisions of "Manuals/calci/MODE"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
<div style="font-size:30px">'''MODE(n1,n2,...)'''</div><br/> | <div style="font-size:30px">'''MODE(n1,n2,...)'''</div><br/> | ||
− | *<math> | + | *<math>n_1,n_2,...</math> are numbers to calculate the Mode. |
==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( | + | *In <math>MODE(n_1,n_2...)</math>, <math>n1</math> is required.<math>n_2,n_3...</math> are optional. |
− | *In this function <math> | + | *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. |
*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 | ||
− | when the numbers are error values or text that cannot change | + | when the numbers are error values or text that cannot change into numbers. |
*The MODE function measures central tendency. | *The MODE function measures central tendency. | ||
*The three most common measures of central tendency are: A.M, Median,& Mode. | *The three most common measures of central tendency are: A.M, Median,& Mode. |
Revision as of 00:13, 22 January 2014
MODE(n1,n2,...)
- are numbers to calculate the Mode.
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 , is required. are optional.
- In this function 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
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