Submitted by Anonymous (not verified) on Thu, 2008-04-03 15:33.
Neither Excel nor your Calculator likely have a binary logarithmic base. Thus you need to use the "change of base" formula for logaritms:
the log base A of value B is equal to the log base C of value B divided by log base C of value A.
In other words:
log2 3 = log10 3 / log10 2
where 10 was chosen because they can be done on the calculator.
Thus log2 9/14 = log(9/14)/log(2)
and you should be able to get a value fro the whole equation.
Although -- I've only ever gotten 0.9403 so I'm not certain how the author got 0.947
addition of values via Excel or Calculator
Neither Excel nor your Calculator likely have a binary logarithmic base. Thus you need to use the "change of base" formula for logaritms:
the log base A of value B is equal to the log base C of value B divided by log base C of value A.
In other words:
log2 3 = log10 3 / log10 2
where 10 was chosen because they can be done on the calculator.
Thus log2 9/14 = log(9/14)/log(2)
and you should be able to get a value fro the whole equation.
Although -- I've only ever gotten 0.9403 so I'm not certain how the author got 0.947