Microsoft Office Tutorials and References
In Depth Information
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
all describe the central
tendencies of a data set.
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.
Search JabSto ::

Custom Search