Solved

How to calculate a percentage

Posted on 2014-12-27
2
117 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
[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
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

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
Discrete Values 2 71
hardness of water, iron in it, and effect on humans.. 6 93
Most Consistent Performer 4 39
Calculation of speed from point A to point B. 4 63
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.
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
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…

710 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