Solved

How to calculate a percentage

Posted on 2014-12-27
2
110 Views
Last Modified: 2014-12-27
I am trying to calculate an estimated value for year 2008 knowing the 2014 & 2011 values.
If 2014 value is $800,000, 2011 value is $560,000 the the % increase is (800000-560000)/560000 = 43%.

How can I get an estimated value for 2008?

It's driving me nuts
0
Comment
Question by:weeph
2 Comments
 
LVL 18

Accepted Solution

by:
Simon earned 500 total points
ID: 40519939
$392,000

I looked at it the other way round. The 2011 value is 70% of the 2014 value. 2008 is another 3 years back (an equal step) and if the rate of decrease is linear it would be 70% of 560,000, which is 392,000

Looking at it another way, 2014 value is 143% of 2011 value so to reverse that and go backwards use the inverse of 1.43, which is 0.7.
0
 

Author Closing Comment

by:weeph
ID: 40519965
Absolutely spot on thanks
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Whisker Plot 1 43
Cumulative Distribution 2 37
Permutation and Combination 9 86
C/R - what does it mean in postal address 2 77
A Guide to the PMT, FV, IPMT and PPMT Functions In MS Excel we have the PMT, FV, IPMT and PPMT functions, which do a fantastic job for interest rate calculations.  But what if you don't have Excel ? This article is for programmers looking to re…
Have you ever thought of installing a power system that generates solar electricity to power your house? Some may say yes, while others may tell me no. But have you noticed that people around you are now considering installing such systems in their …
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 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