alessandroar2
New Member
- Joined
- Jun 30, 2010
- Messages
- 2
Hi,
I work at a University and I am trying calculate the students ranks based upon their GPA. I understand how to use the Rank function to determine their numerical ranking, however I need to find out each students percentage as they stand in their class.
For Example, the student with the highest and best GPA is the Top 1% of his or her class. Is there a way for Excel to automatically calculate their percentage ranking for each student, rather than having to type it in manually?
My current approach is do a percentile function 'PERCENTILE($X$186:$X$320,.99)' which will give me a GPA corresponding to that Percentage. I then have to take that GPA and manually type in the 1%, 2%, 3% and so on until I have inputted the % Ranks for each student. There must be an easier way, correct?
Thanks for your help!
Tony
I work at a University and I am trying calculate the students ranks based upon their GPA. I understand how to use the Rank function to determine their numerical ranking, however I need to find out each students percentage as they stand in their class.
For Example, the student with the highest and best GPA is the Top 1% of his or her class. Is there a way for Excel to automatically calculate their percentage ranking for each student, rather than having to type it in manually?
My current approach is do a percentile function 'PERCENTILE($X$186:$X$320,.99)' which will give me a GPA corresponding to that Percentage. I then have to take that GPA and manually type in the 1%, 2%, 3% and so on until I have inputted the % Ranks for each student. There must be an easier way, correct?
Thanks for your help!
Tony