Trend Line constants

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken - 15 Dec 2005 20:42 GMT

I have created and X Y Scatter chart and placed an Exponential Trend Line on
it with a good R2 result. I have added the equation to be shown on the chart.

How can I put the Constant values of this equation into separate cells
within the worksheet.

i.e. equation is Y = bE (cX)

I want to put the value of "b" and "c" into separate cells. Can anyone help?

Signature

Ken

Reply to this Message

MrShorty - 15 Dec 2005 23:05 GMT

Look at the LOGEST and LINEST worksheet function

Reply to this Message

Jerry W. Lewis - 16 Dec 2005 02:18 GMT

See repies under your post in microsoft.public.excel.misc
Please do not separately post the same question to multiple newsgroups.

Jerry

> I have created and X Y Scatter chart and placed an Exponential Trend Line on
> it with a good R2 result. I have added the equation to be shown on the chart.
[quoted text clipped - 5 lines]
>
> I want to put the value of "b" and "c" into separate cells. Can anyone help?

Reply to this Message