How to calculate percentile? Is it possible to get 100 percentile?How do we calculate percentile?...
How to calculate percentile? Is it possible to get 100 percentile?
How do we calculate percentile? I think it should be calculated as:
Total number of candidates
Number of candidates whose marks are below yours
That means if you are the highest in the range, and there are 200,000 candidates and if your marks are same as 7 others then;
That means in any circumstances you can't have perfect 100 percentile.
Answer & Explanation
There are different definitions of "percentile."
Usually a percentile is computed by first ranking all the data with 1 the lowest, 2 the next lowest, up through N. (The possibility of ties is a complication but does not change the essential idea.) Ranking from lowest to highest instead of highest to lowest is arbitrary but it gives definite rules. However, it would be nice if the percentile computed from ranking in one direction agreed with the percentile from ranking in the other.
You can convert a rank k into a percentile by:
- Computing 100k/N. This value will range from 100/N through . Note the asymmetry: the highest is 100 but the lowest is nonzero.
- Computing . This is the rule quoted in the question. The value will range from 0 through .
- You can make the range of percentiles symmetric. This means that the percentile corresponding to rank k is 100 minus the percentile corresponding the rank in reverse order, which is . To do this, compute . The values range from .
- There are other ways to make the range symmetric. For instance, compute . Values range from 0 through 100.
(There are yet other rules, used especially for constructing probability plots, but you get the idea.)
Either using the first rule, the last rule, or rounding to the nearest percent, can produce a 100th percentile. As I recall, Excel's function for computing percentiles can produce 100 for the top-ranked value.
To put it in words, being in the 100 percentile would mean that 100% of the group has marks below yours. But since 100% of the group would include you, and your mark could never be below your mark, then 100% of the group could not be below you. Therefore you could never be in the 100 percentile.
How to project a percentile between a range of numbers:
Suppose you have a range of integers between:
The current value to be calculated is 6. What percentile is 6 in the range? Answer:
Which breaks down to:
So that means 6 is about 14% on the way between 5 and 12.