|
 |
|
|
 |
  |
 |
 |
|
 |
|
|
|
The
MEDIAN() fucntion returns the most frequently
occuring value in a distribution.
- The syntax for the function
is MEDIAN (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 or a named range.The MEDIAN
function is a measure of the center for
a range of data points.It
arranges the given arguments in order of
value and finds the middle value of the
distribution. For example: MEDIAN(3,8,4,6,2,5,7)
= 5 as when the numbers are ordered in
acending order 2,3,4,5,6,8 the middle value
is 5.When there
are an even number of values in the distribution
the middle value is calculated by fiinding
the average of the two middle values. e.g.
MEDIAN(10,12,13,15) = 12.5. as the two
middle values are 12 and 13 the average
12.5.
|
How
to use the MEDIAN() function:
- Type " =MEDIAN( "
- 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.
|
|
|
|
Note: 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 identicle measures of center. |
|
 |
 |
 |
|
