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 |
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" wrote in message ... 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 |
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" wrote in message ... 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 |
All times are GMT +1. The time now is 04:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com