Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the values from a logarithmic trendline
I would like to put the end logarithmic trendline value on my chart and am
struggling with the linest function my data set looks like this 01jan09 20 02jan09 60 03jan09 113 04jan09 125 05jan09 127 06jan09 129 and so on I have applied a logarithmic trendine and as i said would like to display the end value, my charts equation is y=43.972Ln(x + 41.641, im a little new to this so if anybody can help i would appreciate it |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the values from a logarithmic trendline
Unclear what you mean by "the end"
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Garf" wrote in message ... I would like to put the end logarithmic trendline value on my chart and am struggling with the linest function my data set looks like this 01jan09 20 02jan09 60 03jan09 113 04jan09 125 05jan09 127 06jan09 129 and so on I have applied a logarithmic trendine and as i said would like to display the end value, my charts equation is y=43.972Ln(x + 41.641, im a little new to this so if anybody can help i would appreciate it |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the values from a logarithmic trendline
Hi,
Try =INDEX(LINEST(B1:B6,LN(A1:A6)),1,1) and =INDEX(LINEST(B1:B6,LN(A1:A6)),1,2) for the coefficients. Dave "Garf" wrote: I would like to put the end logarithmic trendline value on my chart and am struggling with the linest function my data set looks like this 01jan09 20 02jan09 60 03jan09 113 04jan09 125 05jan09 127 06jan09 129 and so on I have applied a logarithmic trendine and as i said would like to display the end value, my charts equation is y=43.972Ln(x + 41.641, im a little new to this so if anybody can help i would appreciate it |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the values from a logarithmic trendline
Hi Bernard
by the end it was just to get what the value of sales forecasted by the trendline at the end of the campaign at say week 6 Kind Regards Garf "Bernard Liengme" wrote: Unclear what you mean by "the end" best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Garf" wrote in message ... I would like to put the end logarithmic trendline value on my chart and am struggling with the linest function my data set looks like this 01jan09 20 02jan09 60 03jan09 113 04jan09 125 05jan09 127 06jan09 129 and so on I have applied a logarithmic trendine and as i said would like to display the end value, my charts equation is y=43.972Ln(x + 41.641, im a little new to this so if anybody can help i would appreciate it |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the values from a logarithmic trendline
Thanks Dave will give it a go
"Dave Curtis" wrote: Hi, Try =INDEX(LINEST(B1:B6,LN(A1:A6)),1,1) and =INDEX(LINEST(B1:B6,LN(A1:A6)),1,2) for the coefficients. Dave "Garf" wrote: I would like to put the end logarithmic trendline value on my chart and am struggling with the linest function my data set looks like this 01jan09 20 02jan09 60 03jan09 113 04jan09 125 05jan09 127 06jan09 129 and so on I have applied a logarithmic trendine and as i said would like to display the end value, my charts equation is y=43.972Ln(x + 41.641, im a little new to this so if anybody can help i would appreciate it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logarithmic Trendline | Charts and Charting in Excel | |||
copy trendline logarithmic constants to a cell | Charts and Charting in Excel | |||
Function for Logarithmic Trendline | Charts and Charting in Excel | |||
Why is a logarithmic not always an option under trendline type? | Charts and Charting in Excel | |||
Logarithmic Trendline Equation | Charts and Charting in Excel |