Logarithmic Trendline Equation

1. Logarithmic Trendline Equation

I have a logarithmic trendline with the equation Y = 533371Ln(x) - 3E+06
associated with a line series. I want to create another series using this
equation (substituting 1, 2, 3, etc. for x) but don't know what "3E+06"
means, or how to set the equation up as a formula. Can someone explain the
equation and show me how to set up my formula series?

Thanks,
Phil

2. Re: Logarithmic Trendline Equation

This is so-called scientific notation; 3E+06 would be written by hand as 3 x
10 (power of 6). Of course this is 3,000,000 or 3 million

In A1:A10 enter 1,2,3...10
In B1 enter =533371*Ln(A1)-3E+06
Copy B1 down to B10

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Phil Hageman" <PhilHageman@discussions.microsoft.com> wrote in message
news:9920D8FC-406E-42DC-A926-CE2B84F64332@microsoft.com...
>I have a logarithmic trendline with the equation Y = 533371Ln(x) - 3E+06
> associated with a line series. I want to create another series using this
> equation (substituting 1, 2, 3, etc. for x) but don't know what "3E+06"
> means, or how to set the equation up as a formula. Can someone explain
> the
> equation and show me how to set up my formula series?
>
> Thanks,
> Phil

3. Re: Logarithmic Trendline Equation

Thanks Bernard, appreciate the help. Phl

"Bernard Liengme" wrote:

> This is so-called scientific notation; 3E+06 would be written by hand as 3 x
> 10 (power of 6). Of course this is 3,000,000 or 3 million
>
> In A1:A10 enter 1,2,3...10
> In B1 enter =533371*Ln(A1)-3E+06
> Copy B1 down to B10
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Phil Hageman" <PhilHageman@discussions.microsoft.com> wrote in message
> news:9920D8FC-406E-42DC-A926-CE2B84F64332@microsoft.com...
> >I have a logarithmic trendline with the equation Y = 533371Ln(x) - 3E+06
> > associated with a line series. I want to create another series using this
> > equation (substituting 1, 2, 3, etc. for x) but don't know what "3E+06"
> > means, or how to set the equation up as a formula. Can someone explain
> > the
> > equation and show me how to set up my formula series?
> >
> > Thanks,
> > Phil

>
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1