Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    946
    Thanks
    584
    Thanked 37 Times in 29 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,864
    Thanks
    416
    Thanked 1,576 Times in 1,427 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,344
    Thanks
    162
    Thanked 621 Times in 590 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
  •