View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton
 
Posts: n/a
Default copy trendline logarithmic constants to a cell

David -

Excel's logarithmic trendline fits y = c*LN(x) + b.

Excel's exponential trendline fits y = c*EXP(b*x).

Excel's LOGEST function fits y = b*m^x. The b value corresponds to c in the
trendline exponential function, and the m corresponds to EXP(b).

So, LOGEST is a worksheet equivalent to exponential trendline, not to
logarithmic trendline.

- Mike
www.mikemiddleton.com

"David Biddulph" wrote in message
...
"Cheetha" wrote in message
...
Is it possible to copy trendline logarithmic constants to a cell for
further
calculations.


Can't you use the LOGEST() function?
--
David Biddulph