Manuals/calci/MODE

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 $MODE()$ , 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.
- $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

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)