Getting the values from a logarithmic trendline

G

Garf

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
 
D

Dave Curtis

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
 
G

Garf

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
 
G

Garf

Thanks Dave will give it a go

Dave Curtis said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top