|
 |
|
|
 |
  |
 |
 |
|
 |
|
|
|
The
MODE() function returns the most frequently
occurring value in a distribution.
- The syntax for the function is MODE (number
1 , number 2, ....number n).
The arguments for
the function "number
1, number 2.." can be a
series of up to 30 values, a range of
cells, an array or a named range.The MODE
function is a measure of the center for
a range of data points. It uses the
frequency of a value to describe the trends
and patterns of a series of values in the
range. For example:
MODE (6,2,15,7,15,9) = 15 as the number
15 occurs most frequently. When two numbers
occurring equally often the MODE function
returns the number with the highest value
e.g. MODE( 6,2,15,7,15,9,7) = 15 as the
two numbers occurring most often are 15
and 7 with the largest value being 15.
This is also true for negative
numbers eg. MODE (6,2,-15,7,-15,8,7) =
-15 .
|
How
to use the MODE() function:
- Type " =MODE( "
- Enter
the coordinate of the first
data cell "A2"
- Type a colon.
- Enter
the coordinate of the last
data cell "A7"
- Type ")" then
press the "Enter" key.
|
|
|
|
If
the range of values do not contain
repeating values the MODE function will
display a #N/A error value.
Note: Referenced
cells that do not contain information are
ignored but cells with a value of zero are
included in the calculation of the average.
For symmetrical distributions the AVERAGE,
MODE and MEDIAN give identical measures of
center. |
|
 |
 |
 |
|
