How generate trendline equations for Power, Exp and Log trendlines

I

Incoherent

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
 
B

bj

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.
 
I

Incoherent

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.
 
I

Incoherent

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...
 
D

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
 
Top