Microsoft Knowledge Base
Excel: Unexpected Results Using the MODE() Function
Last reviewed: September 12, 1996
Article ID: Q105431
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a, and 5.0
- Microsoft Excel for the Macintosh, version 4.0
In Microsoft Excel, if you are using the MODE() function and you are using a bimodal data set (the data set contains TWO values that occur most frequently), the function will return the bimodal value that occurs first in the data set.
Example
The formula MODE(4,4,4,5,5,5,1), returns the value 4. The formula MODE(4,5,4,5,4,5,1), returns the value 4. The formula MODE(5,4,4,5,4,5,1), returns the value 5. The formula MODE(1,5,4,5,4,5,4), returns the value 5.
REFERENCES
"Function Reference," version 4.0, pages 278-279
KBCategory: kbusage Last reviewed: September 12, 1996 |