Difference between revisions of "Manuals/calci/LOG"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=LOG(n, base)= | =LOG(n, base)= | ||
| − | *Where | + | *Where <math>n</math> is a positive real number and |
| − | * | + | *<math>base</math> is the base of the logarithm. |
LOG() determines the logarithm of a number to a specified base. | LOG() determines the logarithm of a number to a specified base. | ||
| Line 18: | Line 18: | ||
LOG(4, 0.5) ''returns -2'' | LOG(4, 0.5) ''returns -2'' | ||
| − | *The number should be a positive real number. Else Calci displays NaN error message. | + | *The number <math>n</math> should be a positive real number. Else Calci displays NaN error message. |
| − | *The base should be a positive real number. Else Calci displays NaN error message. | + | *The <math>base</math> should be a positive real number. Else Calci displays NaN error message. |
| − | *If the base is omitted, Calci assumes it to be 10. | + | *If the <math>base</math> is omitted, Calci assumes it to be 10. |
*LOG() can be used in an equation as - | *LOG() can be used in an equation as - | ||
LOG(LOG(10,2),3) + LOG(10,2) ''returns 4.414711580210549'' | LOG(LOG(10,2),3) + LOG(10,2) ''returns 4.414711580210549'' | ||
Revision as of 16:00, 13 December 2013
LOG(n, base)
- Where is a positive real number and
- is the base of the logarithm.
LOG() determines the logarithm of a number to a specified base.
Description
LOG(n, base)
For Example,
LOG(10, 2) returns 3.3219280948873626
LOG(100,10) returns 2
LOG(4, 0.5) returns -2
- The number should be a positive real number. Else Calci displays NaN error message.
- The should be a positive real number. Else Calci displays NaN error message.
- If the is omitted, Calci assumes it to be 10.
- LOG() can be used in an equation as -
LOG(LOG(10,2),3) + LOG(10,2) returns 4.414711580210549
- The function can be used to find the logarithm of array of numbers with a specified base.
e.g. LOG(10..15, 2) that displays the output as below -
| n | base | LOG Output |
|---|---|---|
| 10 | 2 | 3.3219280948873626 |
| 11 | 2 | 3.4594316186372977 |
| 12 | 2 | 3.5849625007211565 |
| 13 | 2 | 3.700439718141092 |
| 14 | 2 | 3.8073549220576037 |
| 15 | 2 | 3.9068905956085187 |
Examples
| 10 | 2 | |
| 50 | 10 | |
| 7.5 | 7.5 | |
| 120 | ||
| 700 |
=LOG(A1,B2) : Calculates the logarithm of 10 with base 10. Returns 1 as a result. =LOG(A4:A5,B1) : Calculates the logarithm of values 120, 700 with base B1 (2).Returns 6.906890595608519, 9.451211111832329 as a result. =LOG(A4) : Calculates the logarithm of 120. Here base is assumed to be 10. Returns 2.0791812460476246 as a result. =LOG(100,B3) : Calculates the logarithm of 100 with base 7.5. Returns 2.2855542619359994 as a result.