trendline equation
Same data set are used, but my boss like to see the trendline equation
(non-liner Exponential)
I think the equation for Exponential is y = B*e ^(Ax)
Will =LINEAT works to extract the number (B and A)?
If so, what is the set up?
If not, what will be the best way to extract the numbers?
"Terry" wrote:
We have XY (scatter-connected by line) chart.
When I use trendline (polynomial, order of 2) I can ask show up the equation.
But now we would like extract all number from equation shown in individual
trendline, and put into a separate file, so we can do detail and complex
statistical analysis.
In linear trandline, I can extract number by just computing slope, and
intercept.
Can anyone tell me how to extract number of polynomial equation?
|