Thanks a lot for your help.. I guess I haven't been drinking enough coffee
today ;)
"Tushar Mehta" schreef:
I'm surprised you figured out the first two and then got stumped by the
last two.
y=a*ln(x)+b is of the same form as y=a*z+b!
So, a=Slope(y,ln(x)), and b=intercept(y,ln(x))
The other equation, y=a*exp(b*x), can be rewritten as
ln(y)=ln(a) + ln(exp(b*x)) or
ln(y)=ln(a) + b*x
So, a=exp(intercept(ln(y),x)) and b=slope(ln(y),x)
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions