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.
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
www.stfx.ca/people/bliengme/E...amp; LOGEST.htm
www.stfx.ca/people/bliengme/E...Polynomial.htm
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
quot;Gregquot; gt; wrote in message
...
gt; Is there anyway to get a common log trendline for an EXCEL graph. I know
gt; how
gt; to get the natural (ln) log trendline but I need a common log
gt; trendline/line
gt; equation in order to properly analyze my ELISA experiment.
- May 16 Wed 2007 20:37
Log trendline function?
close
全站熱搜
留言列表
發表留言