You can create a formula that supports transcendental functions, such as logarithmic functions for any base, functions for combinatorial calculations, the Beta function, and several gamma functions. See Transcendental Functions in the Scripting Guide for details about syntax.
Calculates the natural logarithm (base e). To change the default base, highlight the argument and type a comma or click the insert key on the keypad. The base appears and is editable. The Log argument can be any numeric expressions. The expression Log(e) evaluates as 1, and Log(32,2) is 5. The Log10 function calculates the logarithm of base 10 only.
Also known as Squish or Logistic, is an efficient computation of the function 1 / (1+e-x), where x is any numeric column, variable, or expression.
Calculates the root of its argument as specified by the index. Root initially shows with an index of 2. To change the index, highlight the index argument and enter the value that you want.
Returns the product of all numbers 1 through the argument that you specify. For example, Factorial(5) evaluates as 120.
Returns the number of n things taken k at a time (n select k) and is computed in the standard way using factorials, as n! / (k!(n – k)!). For example, NChooseK(5,2) evaluates as 10.
Adds the two parameter Beta function and is written terms of the Gamma function as:
Gamma with a single argument is the same as Gamma(x, infinity). The optional second argument changes the upper integer from infinity to the value that you enter. Other interesting gamma function relationships are
•
|
•
|
•
|
Γ(0.5) = the square root of π
|
Is the natural log of the result of the gamma function evaluation. You get the same result using the Log (natural log) function with the Gamma function. However, the LGamma function computes more efficiently than do the Log (natural log) and the Gamma functions together. NChooseK is implemented using LGamma functions. The result is not always an exact integer. If the result is close to an integer, it is rounded up using the Floor function.
The logarithmic derivative of the Gamma function.