Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trend Line constants
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? -- Ken |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trend Line constants
Look at the LOGEST and LINEST worksheet function. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=493945 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trend Line constants
See repies under your post in microsoft.public.excel.misc
Please do not separately post the same question to multiple newsgroups. Jerry Ken wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trend Line Constants | Excel Discussion (Misc queries) | |||
Chart confidence intervals around regression (or trend) line | Charts and Charting in Excel | |||
Adding a Trend line | Charts and Charting in Excel | |||
How to put coefficients of trend line into spreadsheet? | Charts and Charting in Excel | |||
trend line does not appear | Charts and Charting in Excel |