View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
terry terry is offline
external usenet poster
 
Posts: 193
Default 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?