STATISTICAL FUNCTION - MODE

[g$]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

can the MODE function in excel be made to display more than one mode if more than one mode exists? or does it always just display the first (i.e., lowest) number it finds to be a mode? i have a set of data where 4, 5 and 6 all appear twice, but the MODE function only returns the number 4 as the mode. it ought to return 4, 5 and 6 but it doesn't. is this a limitation of excel or am i missing something?

 

[Mike Middleton]

g$ -

Excel's MODE function finds only a single mode.

For one discussion, see
http://www.eggheadcafe.com/software/aspnet/30546279/using-the-mode-function.aspx

Or, browse to google.com, and search for "excel more than one mode" (without
the quotes).

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel