Calculating logarithms in Rev G (AREV Specific)
At 22 MAY 1998 08:10:26AM Steve Jackson wrote:
I need to perform a complex calculation within RevG using logarithms. I performed the calculation in Excel and am now trying to emulate within RevG. The problem is that logarithms within RevG give different results to Excel. I note that the RevG manual refers to them as natural logs and this I believe differs from 'normal' logs. For example, LN(3000)=8.0064 whereas LOG of 3000 in Excel=3.477121255. I need to emulate the latter. Is there another function which I can use, or any way of manipulating a natural log to meet my requirements.
At 22 MAY 1998 01:00PM Lauren Floyd wrote:
] LN(3000)=8.0064 whereas LOG of 3000 in Excel=3.477121255. <
If I remember my trigonometry you can simply divide the natural log by 2.303. To get more precise use 2.3025851 which is the ln of 10 on my calculator (punch in 10 on your calculator and hit the 'LN' key).
Hope this helps
Lauren Floyd
LaurenFloyd@compuserve.com
At 22 MAY 1998 01:04PM Saul Mendoza wrote:
A natural log (ln) is a special kind of log function.
x=a^y then y=log(a)X for a log
x=e^y then y=log(e)X for a ln (where e ~ 2.71828…)
So if you ever want to convert from one to another:
log(X)=M*ln(X), where M=.4342944819so for your example… ln(X)=8.0064, M=.4342…, X=3000
log(3000)=(.4342944819)(8.0064)=3.47712srm@sfo.com