get percentile rank for students in Excel

Q57. I conducted a test and the test scores are available - how can I get Percentile rank of students?

excel get percentile rank for students

To do it in Excel, here is the answer:

a) Enter the formula =PERCENTRANK($D$3:$D$22,D3,2) in "Percentile Rank" column for first student. Drag the formula all the way down to end of column.

The first argument in formula corresponds to the array containing the scores, the second argument corresponds to individual Student score and the 3rd argument define the number of significant digits in the result.

excel excel get percentile rank for students

 

You can find similar Excel Questions and Answer hereunder

1) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

2) Is there a way to get a log value of a number using Excel?

3) How do I get the principal part of loan payment for the year given Loan amount, Rate of Interest and period?

4) How do I get the rank of a number in a list of numbers?

5) How can I get the information about my current operating environment (OS version, Excel version, Current Directory)

6) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

7) How can I have text autocomplete by typing in a short code for the text?

8) Given a raw data Table, how can I find the value of a field for a specific value of another field?

9) I track a stock on a daily basis and enter the Open, High, Low and Close values for every trading day. In Excel, how can I automatically get High and Low values for the last 10 trading days?

10) How can I loop through all WorkSheets and get their names using VBA?

11) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

12) How can I get row count of filtered data?

13) How can I clear cell after activating a routine when there is a change in value of a cell?

14) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

15) Keyboard shortcut for save as in Excel