So let us take our grades and rank them as percentiles. I am going to cover all four of those functions for you. The first two: percentile exclusive and percentile inclusive, there's a subtle difference between the two, but percentile.inc, or percentile inclusive is equivalent to the old percentile function.Īnd percent rank is equivalent to the old percent rank function.
In previous editions of excel, you only had two percentile functions: you had percentile, and percent rank. The percent rank function takes those ranks and turns them into a percentage, or a percentile. And the bottom scorer, chan at 62.1 was ranked at 9.
The rank function took a list of students and their grades and ranked them according to how well they did.įor example the top scorer here, grayson with 99 was ranked at 1. In a previous video, i showed you how to use the rank function. This is stephanie from, and in this video i am going to show you how to use the percentile function in microsoft excel 2013.
0 kommentar(er)
