Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to calculate a percentage

Posted on 2014-12-27
2
Medium Priority
?
123 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 2000 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

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…
This article seeks to propel the full implementation of geothermal power plants in Mexico as a renewable energy source.
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…
Suggested Courses

824 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