Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    The MODE function

    How does Excel decide which value is the mode when more than one value occurs the same number of times? For example, the mode of 1,2,2,2,3,4,5,6 is 2 but the mode of 1,1,2,2,3,4,5,5 is returned as 1.
    Thanks in advance.

    Paul

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: The MODE function

    I can't find any documentation anywhere that says for sure, but my experimentation seems to indicate that, if there are more than one value have the same number of occurances, then the value that appears first in the list is chosen.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •