Logarithmic Trendline Equation

P

Phil Hageman

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
 
B

Bernard Liengme

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
 
P

Phil Hageman

Thanks Bernard, appreciate the help. Phl

Bernard Liengme said:
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
 

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