Results 1 to 7 of 7

Mode (Most Frequency) in Ranges

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,101

    Mode (Most Frequency) in Ranges

    Hello Excel Gurus,

    I have 2 questions that I don't even know if there's a solution to it.

    Given a range of numbers (below), we can see that 0-1 (6x), 1-2 (5x), 2-3 (4x), 3-4 (3x), 4-5 (6x), 5-6 (5x), 6-7 (6x), 7-8 (2x), 8-9 (3x), 9-10 (2x)

    0, 0.1, 0.2, 0.3, 0.4, 1.0,
    1.1, 1.2, 1.5, 1.9, 2.0,
    2.1, 2.2, 2.7, 2.8,
    3.2, 3.5, 3.6,
    4.1, 4.3, 4.5, 4.7, 4.9,5.0,
    5.2, 5.4, 5.6, 5.8, 6.0,
    6.1, 6.2, 6.4, 6.5, 6.8, 6.9,
    7.5,7.9,
    8.1, 8.8, 9.0,
    9.1, 10

    The 1st question is that, How do I spit out the no. of occurance in the given range. Which is shown above. i.e. 0-1 (6x), 1-2 (5x), ... ..., 9-10 (2x). Without the 'x' of course.

    2nd question is, how to tell the user, what's the range that occured most. In our example, it will spits out 0-1, 4-5 and 6-7 as the answer.

    Updated:
    Attached Files Attached Files
    Last edited by dluhut; 04-12-2012 at 04:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1