Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to calculate a percentage

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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…
Article by: Nicole
This is a research brief on the potential colonization of humans on Mars.
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.
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

670 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