In general, how to write formulas / functions in excel logarithms is using syntax:
LOG (number, base)
with:
Number is the positive real number for which you want the logarithm.
Base is the base of the logarithm. If base is omitted, it is assumed to be 10
.
A simple example application of the reduction formula and the distribution of the logarithm can be seen below
ª log b / c = ª log b - log c ª
To calculate in Excel can follow the following procedure:
1. Create a table as below
Column A is the logarithmic base
Columns B and C is filled with data
Column D and E will filled with logaritm formula
2. Perform calculations by fitting logarithmic formula
a. in cell D4 , type the formula
= LOG (B4/C4, A4)
b. in cell E4, type the formula
= LOG (B4, A4) - LOG (C4, A4)
That can be seen
In line 4, ª log b / log b c = ª - ª log c = 10 log 8 / 4 = 10 log 80-10 log 4 = 0.301
In line 5, ª log b / log b c = ª - ª log c = 2 log 9 / 7 = 2 log 9-2 log 7 = 0.3625
You can download example file in xls format here logaritm reduction
No comments:
Post a Comment