Microsoft Office Tutorials and References

In Depth Information

**Syntax**

If you have a range of True/False values and you want to see what per-

centage of people answered True, you can use =AVERAGEA() of the range. The

AVERAGEA function treats True values as 1 and False values as 0.

Syntax

=MEDIAN(number1,number2,...)

The MEDIAN function returns the median of the given numbers. The median is

the number in the middle of a set of numbers; that is, half the numbers have

values that are greater than the median and half have values that are less.

If there is an even number of numbers in the set, MEDIAN calculates the av-

erage of the two numbers in the middle.

The arguments number1, number2, ... are one to 255 numbers for which you

want the median. The arguments should be either numbers or names, arrays,

or references that contain numbers. Microsoft Excel examines all the num-

bers in each reference or array argument. If an array or a reference argu-

ment contains text, logical values, or empty cells, those values are ignored;

however, cells that contain the value 0 are included.

Syntax

=MODE.SNGL(number1,number2,...)

The MODE.SNGL function returns the most frequently occurring, or repetit-

ive, value in an array or a range of data. Like MEDIAN, MODE.SNGL is a loc-

ation measure. In a set of values, the mode is the most frequently occurring

value; the median is the middle value; and the mean is the average value. No

single measure of central tendency provides a complete picture of the data.

Suppose data is clustered in three areas, half around a single low value

and half around two large values. Both AVERAGE and MEDIAN may return a

value in the relatively empty middle, and MODE.SNGL may return the domin-

ant low value.

The arguments number1, number2, ... are one to 255 arguments for which you

want to calculate the mode. You can also use a single array or a reference

to an array instead of arguments separated by commas. The arguments

should be numbers, names, arrays, or references that contain numbers. If an

array or reference argument contains text, logical values, or empty cells,

those values are ignored; however, cells that contain the value 0 are in-