MODE

[stef]

XL2002 SP3
Win XP HE

i have a problem with MODE function which seems to return an incorrect
value.


"MODE(number1,number2,...)

Number1, number2, ... are 1 to 30 arguments for which you want to
calculate the mode. You can also use a single array or a reference to
an array instead of arguments separated by commas."

My array is much larger than 30 values. Could it be the reason for the
incorrect value returned by MODE?

If so, is there an alternative function to calculate it
dynamically--without using the static ANOVA tables, etc.?

tx!

--

 

[Bernard Liengme]

An array reference such as A1:A100 is a single argument. SO that is NOT the
problem
Have you tried it with a small dataset for which MODE can be found manually?
How do you know you are getting the wrong value?
best wishes

 

[stef]

It's obvious I am getting the wrong value but if it's not the 30 data
points then I myself must be doing something wrong.

I'll have to look at it more closely on a different smaller dataset as
you suggest.

I'll post here again. Thanks

 

[Bernard Liengme]

Want to send me (my private email address) a sample file ?
best wishes

 

[stef]

I might. Let me check on it 1st. Thanks for the offer.