1

# Percentile Difference between two numbers - Help

Sat 31 Jul, 2004 06:07 pm
Hi,

Can anyone offer information as to how to calculate the Percentile Difference between two numbers? ...thought I knew how to da that.

For example, how much greater is 79.05 than 73.00?

I'm working in Excel. Any suggestions as to formulas. All my data is in columns.

Thanks to any and all.

MB
Montreal
• Topic Stats
• Top Replies
Type: Discussion • Score: 1 • Views: 12,346 • Replies: 6
No top replies

Justthefax

1
Sun 1 Aug, 2004 11:52 pm
a precentile is based on 100%

so the 79.05% - 73.00% = 6.05%
0 Replies

lab rat

1
Mon 2 Aug, 2004 07:13 am
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.
0 Replies

urbane2000

1
Mon 2 Aug, 2004 05:33 pm
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
0 Replies

ebrown p

1
Mon 2 Aug, 2004 07:55 pm
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.
hu15t0nz

1
Thu 11 Jan, 2018 09:15 pm
@ebrown p,
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?
0 Replies

daverod

1
Mon 1 Oct, 2018 05:33 am
@urbane2000,
https://percentagecalculator.net/

For example, how much greater is 79.05 than 73.00?

8.28767123287671%
0 Replies

### Related Topics

Facs on the Famous - Discussion by gollum
URGENT!!! (BEER STATISTICS) - Question by Sarah17
WHAT TIME IS IT NOW? - Question by farmerman
Are Print Encyclopedias Obsolete? - Discussion by Phoenix32890
what d'you call a prince? - Discussion by Endymion
Collecting - Numismatics - Discussion by gollum
What a Trip - Discussion by gollum
New York State Economy - Discussion by gollum
Finding Old Articles - Discussion by gollum

1. Forums
2. » Percentile Difference between two numbers - Help