Percentile Difference between two numbers - Help

a precentile is based on 100%

so the 79.05% - 73.00% = 6.05%

You need to specify which of the two numbers is your "reference value". The percentage difference is then solved by the equation:
[(actual value - ref. value) / ref. value] x 100

In your example, assuming 73.00 is the reference value, the percent difference is
[(79.05 - 73.00)/73.00]*100 = 8.288%

In Excel, put your reference values in column A, with the other values in column B. To make column C represent the percent error, in cell C1 enter the formula:
=((B1-A1)/A1)*100
and copy down.

Thanks to the Lab Rat
Hi Lab Rat,

Thanks for your help - much appreciated. In hindsight, I should've specified which was the reference value. Sometimes small little math problems like that can throw me for a loop.

This was a work related task so I had to be sharpe with my formulas etc.

All's good. Thanks again.

Mike

Just a heads up. Lab rat gave you the correct formula for percentage difference.

The term percentile has a different meaning altogether.

Percentage is probably what you want. But if someone is asking for percentile, they are asking for something different.

Considering the scenario where you want to calculate the 90th percentile (not percentage) difference, what would be the formula? Can it be a straight subtraction?

https://percentagecalculator.net/

For example, how much greater is 79.05 than 73.00?

8.28767123287671%