Question

How do you calculate percentile in excel? How many students scored lower than 490?

Mean 540
2.5% Bound 400
97.5% Bound 680
Student's Score 490

Answer 1

Calculate rank percentile in Excel

To calculate the rank percentile of a list data, you can use a formula. Select a blank cell that you will place the rank percentile at, type this formula =RANK. EQ(B2,$B$2:$B$9,1)/COUNT($B$2:$B$9), press Enter key and drag fill handle down to calculate all rank percentiles.