Microsoft Office Tutorials and References

In Depth Information

**Syntax**

cluded. If the data set contains no duplicate data points, MODE returns an

#N/A error.

It is possible to have multiple values that tie as the mode. In the MODE.SNGL

calculation, when two values tie as the mode, only the first mode value ap-

pears as the result. In
Figure 14.4
,
the MODE.SNGL in E4 is reported as 88,

even though both 88 and 82 appear most frequently in the data set. Microsoft

added MODE.MULT to Excel 2010 to handle the situation where multiple val-

ues tie as the mode.

Figure 14.4.

Figure 14.4.
AVERAGE

AVERAGE,, MEDIAN

MEDIAN, and

all describe the central

tendencies of a data set.

, and MODE.SNGL

MODE.SNGL all describe the central

tendencies of a data set.

Figure 14.4
shows examples of AVERAGE, MEAN, and MODE.SNGL. Cell E2

calculates the arithmetic mean of the test scores in column B: 81.4444. The

median in cell E3 is higher: 82.5. This means that half the students scored

above 82.5 and half scored below 82.5. The mode in cell E4 as reported by

MODE.SNGL is 88. A formula in E5 indicates that 82 is also tied as a mode.

This is because 82 and 88 each appeared three times in the data set.

The range in
Figure 14.4
demonstrates two anomalies with the median and mode.

In this case, there are an even number of entries
—
18. It is impossible to fig-

ure out a median in this case, so Excel takes the average of the two values in

the middle
—
82 and 83
—
to produce 82.5. This is the only situation in which the

median is not a value from the table.