Mathematical Functions and Subroutines |
generates all combinations of elements taken at a time |
|
generates all permutations of elements |
|
returns the absolute value |
|
AIRY |
returns the Airy function |
BETA |
returns the value of the beta function. |
COALESCE |
returns the first non-missing value from a list of numeric arguments |
COALESCEC |
returns the first non-missing value from a list of character arguments |
COMB |
returns the number of combinations of items taken at a time |
COMPFUZZ |
returns the result of a fuzzy comparison of numeric values |
CONSTANT |
returns some machine and mathematical constants |
CNONCT |
returns the noncentrality parameter from a chi-squared distribution |
DAIRY |
returns the derivative of the Airy function |
DEVIANCE |
returns the deviance from a specified distribution |
DIGAMMA |
returns the DIGAMMA function |
ERF |
returns the normal error function |
ERFC |
returns the complementary normal error function |
returns the exponential function |
|
FACT |
returns the factorial of an integer |
FNONCT |
returns the noncentrality parameter of an F distribution |
GAMMA |
returns the gamma function |
IBESSEL |
returns a modified Bessel function |
JBESSEL |
returns a Bessel function |
LOGBETA |
returns the logarithm of the beta function |
LGAMMA |
returns the natural logarithm of the gamma function |
returns the natural (base ) logarithm |
|
LOG2 |
returns the logarithm base 2 |
LOG10 |
returns the logarithm base 10 |
CALL LOGISTIC |
returns the logistic value of each argument |
returns the remainder value |
|
returns random combinations of elements taken at a time |
|
CALL RANPERK |
randomly permutes the values of the arguments, and returns a permutation of out of values |
returns random permutations of elements |
|
PERM |
returns the number of permutations of items taken at a time |
SIGN |
returns the sign of a value |
CALL SOFTMAX |
returns the softmax value for each argument |
returns the square root of a value |
|
TNONCT |
returns the value of the noncentrality parameter from the |
TRIGAMMA |
returns the value of the TRIGAMMA function |