![]() |
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. |
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