copy trendline logarithmic constants to a cell

[Cheetha]

Is it possible to copy trendline logarithmic constants to a cell for further
calculations.

[Tushar Mehta]

For my enhancements to Dave Braden's code to do the needful:
http://groups.google.com/group/micro.../msg/0eda30f29
434786d?hl=en&

To get the results directly in a worksheet:
Trendline Coefficients and Regression Analysis
http://www.tushar-mehta.com/excel/ti...efficients.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <798491F6-A322-46C1-BBB0-0EF43CDD47FC@microsoft.com>,
Cheetha@discussions.microsoft.com says...
> Is it possible to copy trendline logarithmic constants to a cell for further
> calculations.
>

[David Biddulph]

"Cheetha" <Cheetha@discussions.microsoft.com> wrote in message
news:798491F6-A322-46C1-BBB0-0EF43CDD47FC@microsoft.com...
> Is it possible to copy trendline logarithmic constants to a cell for
> further
> calculations.

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

[Mike Middleton]

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" <david@biddulph.org.uk> wrote in message
news:444f8bc1_1@glkas0286.greenlnk.net...
> "Cheetha" <Cheetha@discussions.microsoft.com> wrote in message
> news:798491F6-A322-46C1-BBB0-0EF43CDD47FC@microsoft.com...
>> Is it possible to copy trendline logarithmic constants to a cell for
>> further
>> calculations.
>
> Can't you use the LOGEST() function?
> --
> David Biddulph