Math Functions

[henneberger]

Math

Additional arithmetic operations including vector functions (double array only) - modeled after java commons math.

• GCD(numeric1, numeric2): Compute the greatest common divisor of two numbers.
• LCM(numeric1, numeric2): Compute the least common multiple of two numbers.
• POW10(numeric): Raise 10 to the power of the input number.
• CBRT(numeric): Compute the cube root of a number.
• ERF(numeric): Compute the error function of a number.
• ERFC(numeric): Compute the complementary error function of a number.
• FACTORIAL(int): Compute the factorial of an integer.
• LOG1P(numeric): Compute the natural logarithm of 1 plus the input number.
• EXPM1(numeric): Compute e raised to the input number minus 1.
• HYPOT(numeric1, numeric2): Compute the hypotenuse of a right triangle given two sides.
• ISQRT(numeric): Compute the integer square root of a number.
• RADICAL(numeric1, numeric2): Calculate the n-th root of a number.
• CSI(numeric): Generate the hyperbolic inverse cosine of a number.
• ASI(numeric): Compute the hyperbolic inverse sine of a number.
• LN1P(numeric): Compute the log of 1 plus the input number.
• EXP2(numeric): Calculate 2 raised to the power of the input number.
• EXP10(numeric): Calculate 10 raised to the power of the input number.
• LOGB(numeric1, numeric2): Logarithm of numeric1 with base numeric2.
• SECH(numeric): Compute the hyperbolic secant of a number.
• CSCH(numeric): Compute the hyperbolic cosecant of a number.
• LOGB2(numeric): Compute base-2 logarithm.
• MEAN(numeric list): Calculate the average of a list of numbers.
• MEDIAN(numeric list): Find the median value in a list of numbers.
• MODE(numeric list): Determine the most frequently occurring value in a list.
• SKEW(numeric list): Compute the skewness of a data set.
• KURTOSIS(numeric list): Compute the kurtosis of a data set.
• VARIANCE(numeric list): Calculate the variance of a list of numbers.
• STDDEV(numeric list): Compute the standard deviation of a list of numbers.
• COVAR(numeric list1, numeric list2): Calculate the covariance between two data sets.
• CORR(numeric list1, numeric list2): Compute the correlation coefficient between two data sets.
• PERCENTILE_CONT(numeric, fraction): Compute the continuous percentile rank of a given value.
• PERCENTILE_DISC(numeric, fraction): Compute the discrete percentile rank of a given value.
• LINEAR_REGRESSION(x, y): Perform a simple linear regression calculation.
• EXP_REGRESSION(x, y): Perform exponential regression analysis.
• LOG_REGRESSION(x, y): Perform logarithmic regression analysis.
• SQRTB2(numeric): Compute binary base square root.
• CONVERT_BASE(number, from_base, to_base): Convert a number from one base to another.