Google Answers Logo
View Question
Q: Simple variance calculation ( Answered 5 out of 5 stars,   0 Comments )
Subject: Simple variance calculation
Category: Science > Math
Asked by: charltonian-ga
List Price: $5.00
Posted: 30 Nov 2006 05:10 PST
Expires: 30 Dec 2006 05:10 PST
Question ID: 786962
Ok, what I'm after is the formula for calculating the % variance
between a current value and the previous value.
I think this should be (where a is current, b is previous) ((a-b)/a)*100
I may be wrong about that - can someone confirm what it is AND provide
a link to a reputable maths source showing that.

Subject: Re: Simple variance calculation
Answered By: palitoy-ga on 30 Nov 2006 06:06 PST
Rated:5 out of 5 stars
Hello charltonian-ga,

Thank-you for your question.

I believe the formula you are looking for is usually called the
percentage difference, rather than the percentage variance which may
be why you have trouble locating your answer.

The formula you have stated is the most common way in which you can
calculate the percentage difference, the other is: ((a/b)*100%)-100

The two different formulae are discussed here:

Further evidence of the formulae can be found here:

I hope this fully answers your question.  If you require any further
assistance please ask for clarification and I will do my best to
charltonian-ga rated this answer:5 out of 5 stars and gave an additional tip of: $1.00
Excellent. Simple enough in the end but I needed it!

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy