How to calculate logarithm addition and logarithm multiplication in excel. By using Microsoft Excel, in addition to calculate logarithm reduction and log division. Can also be done multiplication and addition of logarithms. In this post the process of logarithm addition and logarithm multiplication refers to the properties of logarithms as below:
ª log a = 1
ª log 1 = 0
ª ⁿ = n log a
ª ⁿ log b = log b n • ª
log ª ª b • c = log b + log c ª
ª log b / c = ª log b - log c ª
ª ⁿ m = m log b / log b n • ª
ª a ÷ b = log b log a
ª b log log b • c • d = c log log d ª
ª b = c log log log a b c ÷
Before applying the formula logarithms , we need using syntax of logarithm in excel as :
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
One of the properties of logarithms to be used is
log ª ª b • c = log b + log c ª
In order to more easily implement it, can follow the following procedure:
1. Create the table below
Columns A, B, C will contain the data, with a logarithmic base and number
Colum D and colum W will filled with logarithm formula
Articles and tutorials about blog, internet and computer
Showing posts with label logarithm addition. Show all posts
Showing posts with label logarithm addition. Show all posts
Monday, 21 November 2011
Subscribe to:
Posts (Atom)