ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Log trendline function? (https://www.excelbanter.com/excel-discussion-misc-queries/78197-log-trendline-function.html)

Greg

Log trendline function?
 
Is there anyway to get a common log trendline for an EXCEL graph. I know how
to get the natural (ln) log trendline but I need a common log trendline/line
equation in order to properly analyze my ELISA experiment.

Bernard Liengme

Log trendline function?
 
There is a simple relationship between Ln(X) and Log(X)
If Y = aLn(X) then Y = 2.303*a*Log(X)
The value 2.303 is more exaclty given by =1/LOG(EXP(1))



see also
http://www.stfx.ca/people/bliengme/E...&%20LOGEST.htm
http://www.stfx.ca/people/bliengme/E...Polynomial.htm

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

"Greg" wrote in message
...
Is there anyway to get a common log trendline for an EXCEL graph. I know
how
to get the natural (ln) log trendline but I need a common log
trendline/line
equation in order to properly analyze my ELISA experiment.





All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com