View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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