Thread: student ranking question

1. 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. 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

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

Dick-Y (2016-11-30)

4. 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
•