Simple exponential FoxPro value, how do I do this?

[Dan Musicant]

y and z are known numberic values

z = x^y

How do I ask FoxPro to solve for x?

My usage is to find out the compounded return over a certain period of
time. For instance, if an investment account is increased by a factor of
6 in 8 years, what is the percent annual return, compounded. I believe
the mathematical question above solves that when z=the increment factor
(6 in this case), x is the return (e.g. 1.10 for a ten percent return),
and y is the number of years.

Thanks!

Dan


Email: dmusicant at pacbell dot net

[Bernhard Sander]

Hi Dan,

Post by Dan Musicant
y and z are known numberic values
z = x^y
How do I ask FoxPro to solve for x?
My usage is to find out the compounded return over a certain period of
time. For instance, if an investment account is increased by a factor of
6 in 8 years, what is the percent annual return, compounded. I believe
the mathematical question above solves that when z=the increment factor
(6 in this case), x is the return (e.g. 1.10 for a ten percent return),
and y is the number of years.

x = exp(log(z)/y)

Regards
Bernhard Sander

[Dan Musicant]

On Mon, 15 Jul 2013 12:22:29 +0200, Bernhard Sander <***@kein.spam>
wrote:

:Hi Dan,
:
:> y and z are known numberic values
:>
:> z = x^y
:>
:> How do I ask FoxPro to solve for x?
:>
:> My usage is to find out the compounded return over a certain period of
:> time. For instance, if an investment account is increased by a factor of
:> 6 in 8 years, what is the percent annual return, compounded. I believe
:> the mathematical question above solves that when z=the increment factor
:> (6 in this case), x is the return (e.g. 1.10 for a ten percent return),
:> and y is the number of years.
:
:x = exp(log(z)/y)
:
:Regards
:Bernhard Sander

Yes, that works precisely! Thank you Bernhard!

Dan Musicant



Email: dmusicant at sonic dot net