Solved

Calculate precentage complement.

Posted on 2007-03-22
1,467 Views
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
Question by:psokolo

LVL 44

Expert Comment

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

pValue = 120

AW
0

Author Comment

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

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

Suggested Solutions

Introduction On a scale of 1 to 10, how would you rate our Product? Many of us have answered that question time and time again. But only a few of us have had the pleasure of receiving a stack of the filled out surveys and being asked to do somethi…
Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …