In excel Press Shift F3 and Go to "Or Select a Category"
A range of functions from Financial (Eg.Calculation of Yield) to Compatibility (ChiSquare Test ) is available absolutely free..wow ...
Infact some of the popular risk analytics model (Guassian and Wei-bull mathematical Models ) can be created using these functions easily ..without breaking Head ..Lolz..without using any statistical tools like SAS or SPSS...
Under the category Math and Trig is available Ln and Log.
Easy way to use these functions is =ln and =log in excel...same with any Math Functions.
What is the difference between Ln and Log ?
LN : Returns the natural logarithm of a number
LOG : Returns the logarithm of a number to a specified base
What is the difference between these 2 functions?
Alternatively : What is the difference between log x and ln x and how are they related?
log x is the exponent of 10 that gives you a certain number, like 10^2 = 100
so if x = 100 then log 100 = 2
------------
ln x is the exponent of e= 2.18281828459... which gives you a certain number.
if x=7.389056..... like e^2 = 7.389056..., so ln 7.389056 = 2
When do we use them in Modeling ?
When 2 TV Copies are aired at the same time and there is a multicollinearity issue and the client wants a seperate ROI and Optimal level of GRP for each of the copies ....and both the TV Copies are not appearing in the model together because of VIF issues....
We can do a log transformation of one variable and use them in the Model...One TV Copy to be used as is..and another TV Copy can be log transformed .....this will solve VIF issue...
Now the question is Ln or Log.......which transformation ....?
Time to think !
Iam still thinking which one is best...i have tried both....both works....but mostly its Ln....
A range of functions from Financial (Eg.Calculation of Yield) to Compatibility (ChiSquare Test ) is available absolutely free..wow ...
Infact some of the popular risk analytics model (Guassian and Wei-bull mathematical Models ) can be created using these functions easily ..without breaking Head ..Lolz..without using any statistical tools like SAS or SPSS...
Under the category Math and Trig is available Ln and Log.
Easy way to use these functions is =ln and =log in excel...same with any Math Functions.
What is the difference between Ln and Log ?
LN : Returns the natural logarithm of a number
LOG : Returns the logarithm of a number to a specified base
What is the difference between these 2 functions?
Alternatively : What is the difference between log x and ln x and how are they related?
log x is the exponent of 10 that gives you a certain number, like 10^2 = 100
so if x = 100 then log 100 = 2
------------
ln x is the exponent of e= 2.18281828459... which gives you a certain number.
if x=7.389056..... like e^2 = 7.389056..., so ln 7.389056 = 2
When do we use them in Modeling ?
When 2 TV Copies are aired at the same time and there is a multicollinearity issue and the client wants a seperate ROI and Optimal level of GRP for each of the copies ....and both the TV Copies are not appearing in the model together because of VIF issues....
We can do a log transformation of one variable and use them in the Model...One TV Copy to be used as is..and another TV Copy can be log transformed .....this will solve VIF issue...
Now the question is Ln or Log.......which transformation ....?
Time to think !
Iam still thinking which one is best...i have tried both....both works....but mostly its Ln....
Comments
Post a Comment