Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    874
    Thanks
    517
    Thanked 35 Times in 27 Posts

    student ranking question

    I'm having s Sr. moment and could use some help figuring how to do this in Excel (I have Excel 2007):

    Assume grades for 7 students (82.03,97.14,69.10,90.44,91.46,82.41,92.95).

    The student with the average of 91.46 is the one I need to rank as in top 5%, 10%, 25%, etc.. Is there a formula to figure this out?

    Thanks for helping me get through this brain-cramp,
    Dick

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Dick,

    Not sure this is what you are after but it will tell you within what percentile of the 7 students each falls. You can do the rest of the math if you want even 5% increments.

    Dick-Y.JPG

    Place the formula: =100/COUNT($A$2:$A$8)*(ROW()-1) in B2 then fill down.

    HTH :cheers
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    Dick-Y (2016-11-30)

  4. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Dick

    Use Excel's =PERCENTILE function.

    =PERCENTILE($A$2:$A$8,0.9)

    ..this formula returns the value of 94.63, which means that 90% of the results in that range are below this value.
    So, to be 'in the top 10%', the students score must be above 94.63

    zeddy

  5. The Following 2 Users Say Thank You to zeddy For This Useful Post:

    Dick-Y (2016-11-30),RetiredGeek (2016-11-30)

Posting Permissions

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