Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    970
    Thanks
    610
    Thanked 38 Times in 30 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,954
    Thanks
    422
    Thanked 1,606 Times in 1,450 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
    3,416
    Thanks
    165
    Thanked 643 Times in 611 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
  •