| T O P I C R E V I E W |
| coll@inia. |
Posted - 05/21/2013 : 05:07:01 AM
Origin 8.5.
Operating System: Win7
I try to convert some column of numbers to their corresponding logarithm in base 2 and I was surprised to find no way to do it!
I googled through and was not capable of finding anything on the subject nor in the help.
Finally I did it in excel!!!.
Is there any way to make any base log calculation in origin?
Thanks, julio |
| 4 L A T E S T R E P L I E S (Newest First) |
| coll@inia. |
Posted - 05/29/2013 : 08:33:36 AM
Thank you Snow Li!
It is a little bit complicated compared to excel but..... it works !!
"My mathematics" are in the deepest of times, so I have to figure out why it works !
Thank you again, julio |
| snowli |
Posted - 05/28/2013 : 09:19:58 AM
Hello,
As Greg said we don't have log2 function in Origin.
But we have log() which is 10 based or ln() which is e based.
You can easily use log() or ln() to get log2() values.
E.g. if you want to calculate log2 of col(A), you can do open Set Column Values dialog of column A. Then enter fomula as follows:
log(col(A))/log(2)
or
ln(col(A))/ln(2)
Thanks, Snow Li
OriginLab Corp. |
| coll@inia. |
Posted - 05/28/2013 : 05:37:19 AM
Thank you greg for your effort!
However I do not understand anything of what you said!
I have a list of numbers, which are those in your formulas?
could you explain step by step what are you doing and why?
what does "ty" means?
Why do you need ln?
Thank you, julio |
| greg |
Posted - 05/21/2013 : 09:51:18 AM
You can calculate the log in any base by dividing any 'log' of the number by that 'log' of the base, so:
ans1 = log(32) / log(2);
ans2 = ln(32) / ln(2);
ty Using log : $(ans1), ln : $(ans2);
which results in:
Using log : 5, ln : 5
which is correct since 2^5 = 32.
|
