Results 1 to 4 of 4

Ranking Numbers

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2006
    Posts
    26

    Ranking Numbers

    Hi

    Running into a little problem. I have a data set as follows

    A 2
    B 2
    C 2
    D 7
    E 8
    F 4
    G 9
    H 10

    I am using the function trimmean to find the average of the middle 50%. But I want to know what numbers are contributing to this data. For example, what is the middle 50% of the data ( in the example above, excluding the top 2 and low 2 numbers). I have used the "rank" function, but I fall into problems because there can be multiple #1 ranks, ect.

    Any ideas?
    Last edited by Nike6106; 01-27-2010 at 10:45 AM.

Thread Information

Users Browsing this Thread

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

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