log trendline formula
ln IS A FUNCTION IN EXCEL
Log is usually referes to base 10
Log(10) = 1
Log(100) = 2
Log( 1000) = 3
If we did Log for base 3
Log(3) = 1
Log(9) = 2
Log(27) = 3
LN is the Log using e as the base where e equals approximately 2.3
"dr chuck" wrote:
This is a log trendline formula from Excel semilog graphing.
y = 0.8065Ln(x) + 3.4412
can anyone tell me how the " 0.8065Ln(x) " part of this formula works?
I know y and i am solving for "x"
not sure the significance of the "Ln"
do i have to use some "log" function?
--
dr chuck
|