What is the priority of Mode function?
 

Referring to the post in General Question

There is a list of numbers
1,1,1,1,1,2,2,3,3,4,4,5,5,5,5,5 from cell A1 to A16
Mode(A1:A16) = 1
However, if I reverse the list of numbers
5,5,5,5,5,4,4,3,3,2,2,1,1,1,1,1
Mode(A1:A16) = 5
The frequency of occurrence between 1 and 5 is same, does anyone know what
the priority of Mode function is defined under this case?
Thank for any suggestions
Eric

What is the priority of Mode function?
 

See your other post.

Must you always multi-post?

Biff

"Eric" wrote in message
...
Referring to the post in General Question

There is a list of numbers
1,1,1,1,1,2,2,3,3,4,4,5,5,5,5,5 from cell A1 to A16
Mode(A1:A16) = 1
However, if I reverse the list of numbers
5,5,5,5,5,4,4,3,3,2,2,1,1,1,1,1
Mode(A1:A16) = 5
The frequency of occurrence between 1 and 5 is same, does anyone know what
the priority of Mode function is defined under this case?
Thank for any suggestions
Eric