Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Help please, solve for X - simple algebra

Posted on 2013-12-18
7
Medium Priority
?
421 Views
Last Modified: 2013-12-18
Can you help me reorder this equation?  I know it must be possible:

F = ( (X/Y)^(1/P-1) ) -1)
0
Comment
Question by:Geoff Millikan
[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
  • 4
  • 2
7 Comments
 
LVL 27

Expert Comment

by:aburr
ID: 39727693
What order do you want?

Try
let r = (1/P)-1          (not 1/(P-1)

F = (X^r)/Y^r) - 1
0
 
LVL 84

Expert Comment

by:ozo
ID: 39727694
F = ( (X/Y)^(1/P-1) ) -1
F+1 = (X/Y)^(1/P-1)
(F+1)^-(1/P-1) = (X/Y)
Y*(F+1)^-(1/P-1) = X
0
 

Author Comment

by:Geoff Millikan
ID: 39727757
ozo, your equation doesn't seem to work when I put in real numbers.  I get 18.43 on your formula but was expecting 34.

F = 2.4
X = 34
Y = 10
P = 2

2.4    = ((34/10)^(1/(2-1))-1)

10*(2.4+1)^-(1/2-1) = 18.43
0
Looking for the Wi-Fi vendor that's right for you?

We know how difficult it can be to evaluate Wi-Fi vendors, so we created this helpful Wi-Fi Buyer's Guide to help you find the Wi-Fi vendor that's right for your business! Download the guide and get started on our checklist today!

 
LVL 84

Expert Comment

by:ozo
ID: 39727781
when you plug in
X = 34
Y = 10
P = 2
( (34/10)^(1/2-1) ) -1 = -0.4576738554533 != 34
0
 
LVL 84

Expert Comment

by:ozo
ID: 39727784
((34/10)^(1/(2-1))-1)
is different from ( (X/Y)^(1/P-1) ) -1)
0
 
LVL 84

Accepted Solution

by:
ozo earned 2000 total points
ID: 39727803
(F+1)^-(1/P-1) = (X/Y)
Y*(F+1)^-(1/P-1) = X
Should have been
(F+1)^(1/P-1)^-1 = (X/Y)
Y*(F+1)^(1/P-1)^-1 = X
or if (1/P-1) was really  (1/(P-1))
(F+1)^(P-1)/1 = (X/Y)
Y*(F+1)^(P-1)/1 = X
0
 

Author Comment

by:Geoff Millikan
ID: 39728051
I get 2.4 when I cut and paste the following into Excel :  ((34/10)^(1/(2-1))-1)

But this formula works great!   Y*(F+1)^(P-1)/1 = X

For proof, I get 34 in Excel when I plug in the numbers: 10*(2.4+1)^(2-1)/1

Awesome, thanks so much!!!!!!!!!!!!!!!

Note to self:

This is the reverse CAGR formula http://www.igetit.net/newsletters/Y06_08/CalculateGrowth.aspx

F = 2.4 (CAGR, in percent, annualized)
X = 34  (Ending dollar amount)
Y = 10 (starting dollar amount)
P = 2 (period [in years])
0

Featured Post

Industry Leaders: 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

Complex Numbers are funny things.  Many people have a basic understanding of them, some a more advanced.  The confusion usually arises when that pesky i (or j for Electrical Engineers) appears and understanding the meaning of a square root of a nega…
This article provides a brief introduction to tissue engineering, the process by which organs can be grown artificially. It covers the problems with organ transplants, the tissue engineering process, and the current successes and problems of the tec…
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…
Suggested Courses

618 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