Finding the modes in bimodal and multimodal data sets

[edvolchok]

Excel's MODE function incorrectly reports a single mode in bimodal and
multimodal data sets. Does anyone know of a way to get Excel to report
the modes in bimodal and multimodal data sets?

Thanks.

 

[JE McGimpsey]

Excel's MODE function incorrectly reports a single mode in bimodal and
multimodal data sets. Does anyone know of a way to get Excel to report
the modes in bimodal and multimodal data sets?

I might take exception to "incorrectly" - Help *does* say "value", not
"values", and the first mode in a bimodal distribution *is* a mode.

In any case, this is a fairly frequently asked question. Here's an array
formula solution, depending on your distribution:

http://groups.google.com/group/microsoft.public.excel.worksheet.functions
/msg/19107f96d4be172b

And a UDF solution (that will turn into a pumpkin with XL08):

http://google.com/[email protected]

 

[edvolchok]

I might take exception to "incorrectly" - Help *does* say "value", not
"values", and the first mode in a bimodal distribution *is* a mode.

In any case, this is a fairly frequently asked question. Here's an array
formula solution, depending on your distribution:

http://groups.google.com/group/microsoft.public.excel.worksheet.funct...

And a UDF solution (that will turn into a pumpkin with XL08):

http://google.com/[email protected]

Thanks for the response. It would be nice if the folks at Microsoft
would make the MODE function more robust.

EV

 

[JE McGimpsey]

Thanks for the response. It would be nice if the folks at Microsoft
would make the MODE function more robust.

Make sure you give feedback to MS (via Help/Send feedback...).