Solved

Calculate precentage complement.

Posted on 2007-03-22
3
1,593 Views
Last Modified: 2012-08-13
I am trying to calculate precentage change and percentage complement.
Let's p = 20% and pComp = ?
Here is a manual calculation of pComp
100 + p(20%) = 120
now
120 - pComp = 100
pComp = 16.6%

Is there a simple formula for it ?
0
Comment
Question by:psokolo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 18772217
pComp = ((pValue - 100)/pValue)*100


pValue = 120

AW
0
 

Author Comment

by:psokolo
ID: 18772245
I would need a formula that would calculate pComp with p as the only parameter.

Thanks for intput.
0
 
LVL 12

Accepted Solution

by:
jkmyoung earned 500 total points
ID: 18772357
pComp = p/(1+p)

Derivation:
(1 + p) * (1 - pComp) = 1
1 + p - pComp - p*pComp = 1
p - pComp - p*pComp = 0
pComp (-p - 1) = -p
pComp = p/(1+p)

Eg.
p = 20% = 0.2
0.2/(1+0.2) = 0.2 /1.2 = 1/6 = 0.16666... = 16.7%
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Probability Distribution 8 69
Compound interest rate 3 75
How to install SVN Command Line Client? 5 134
One Standard Deviation from the Mean 2 43
How to Win a Jar of Candy Corn: A Scientific Approach! I love mathematics. If you love mathematics also, you may enjoy this tip on how to use math to win your own jar of candy corn and to impress your friends. As I said, I love math, but I gu…
We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question