• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# Mathematical Functions

esProc provides the following mathematical functions that return mathematical values.

 Return the absolute value Return the arc cosine value Return the inverse hyperbolic cosine Perform bitwise AND operation on integers Return the arc sine value Return the inverse hyperbolic sine Return the arc tangent value Return the inverse hyperbolic tangent Get the number of 1s in a specified number’s complement binary Calculate bitwise XOR on the specified numbers and get the number of 1s in the result’s complement binary Convert to decimal numbers Convert a sequence of bit values to a sequence of long numeric values The inverse operation of A.bits() function; get value of the nth bit Truncate data at the specified position, and carry the remaining part if any Return the number of combinations Return the cosine value Return the hyperbolic cosine Calculate the determinant of a square matrix Convert a numeric string of certain numeral system to a specific numeral system Calculate the Euclidean distance between two vectors Return e to the nth power Return the factorial Truncate data at the specified position, and reject all the remaining part if any Return the greatest common divisor Return a hash value Ø  I() Generate an identity matrix of a specified size Return positive infinity value Return negative infinity value Calculate the inverse of a square matrix Return the least common multiple Ø  lg() Return the logarithm Perform linear fitting using the least squares method Ø  ln() Return the natural logarithm Calculate the mean absolute error between two vectors Calculate the standard error of the mean between two vectors Calculate the product of two matrices or vectors Normalize a matrix or a vector On integers, perform bitwise NOT operation to get the logical negation on each bit Get the bucket number of the subset where a certain member of the set settles Ø  or() Perform bitwise OR operation on integers Calculate Pearson’s correlation coefficient between two vectors Return the number of permutations Ø  pi() The ratio of a circle’s circumference to its diameter Calculate the coefficient between two vectors in polynomial fitting Perform exponentiation or find the nth root of a number Return the product of a set of numbers Return a random value Return the rank of a matrix Calculate remainder for degree to radian conversion Convert the red, green, blue, and transparency values to the corresponding color value Truncate data at the specified position and round off the remaining part Calculate Spearman’s correlation coefficient between two vectors Perform a shift operation Judge whether the parameter is a positive or negative number or a 0 Return the sine value Return the hyperbolic sine Return the square root Return the tangent value Return the hyperbolic tangent Transpose a matrix Calculate the generalized variance of a vector (sequence) Calculate the overall variance for the aggregation field value Perform bitwise XOR operation on integers