Sort the data from smallest to largest
Count the total number of values
Find the rank using the percentile formula
Use the formula: Rank = (Percentile / 100) × (Total Values + 1)
If the rank is a whole number, take the value at that position
If the rank is a decimal, interpolate between the two nearest values
For a value’s percentile rank, use: Percentile Rank = (Number of values below it / Total Values) × 100
Compare the result with the ordered data to identify the percentile value