How generate trendline equations for Power, Exp and Log trendlines

[Guest]

I am able to generate polynomial coefficients that match using LINEST but I
wonder if anyone knows how to get the coefficients and exponents for the
other type of trendlines.

Thanks

 

[Guest]

have you tried graphing the data and adding the different trendlines with
option for equation to be shown? Note you will normally need to increase the
number of decimal places shown.

 

[Jerry W. Lewis]

The archives of these newsgroups are generally a good place to start

http://groups.google.com/group/microsoft.public.excel.misc/msg/02687207210e1cde

Jerry

 

[Guest]

Thanks for the reply.
I would typically be using this in a template where the raw data changes. I
want a formula to do this rather than copy/paste from a chart.

 

[Guest]

Thanks again Jerry. That linked post gets me half way, I see one of the
coefficients in each case but the intercept is eluding me. I'll play around a
bit.
Interesting that the trendline numbers differ after about 10 decimal places...

 

[Guest]

I just found this site

http://j-walk.com/ss/excel/tips/tip101.htm

It should do what you want

 

[Guest]

Cool, thanks for that. I had figured out some of it, this completes the rest.

 

[David J. Braden]

If you do a Google search among the Groups, you will find "Code Post:
Extract Trendline coefficients" by David J. Braden, dated Mar 5 2003.
Related code is at "Code Post: Trendline/Regression Routines", Jul 23 1999,
David J. Braden