1
   

Percentile Difference between two numbers - Help

 
 
Reply 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
  • Link to this Topic
Type: Discussion • Score: 1 • Views: 12,346 • Replies: 6
No top replies

 
Justthefax
 
  1  
Reply 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  
Reply 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  
Reply 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  
Reply 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  
Reply 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  
Reply 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
Copyright © 2020 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 08/13/2020 at 09:23:32