Mathematical Functions

 esProc provides the following mathematical functions that return mathematical values.

Ø  abs()

Return the absolute value

Ø  acos()

Return the arc cosine value

Ø  acosh()

Return the inverse hyperbolic cosine

Ø  and()

Perform bitwise AND operation on integers

Ø  asin()

Return the arc sine value

Ø  asinh()

Return the inverse hyperbolic sine

Ø  atan()

Return the arc tangent value

Ø  atanh()

Return the inverse hyperbolic tangent

Ø  bit1(x)

Get the number of 1s in a specified number’s complement binary

Ø  bit1(x,y)

Calculate bitwise XOR on the specified numbers and get the number of 1s in the result’s complement binary

Ø  bits()

Convert to decimal numbers

Ø  A.bits()

Convert a sequence of bit values to a sequence of long numeric values

Ø  B.bits(n)

The inverse operation of A.bits() function; get value of the nth bit

Ø  ceil()

Truncate data at the specified position, and carry the remaining part if any

Ø  combin()

Return the number of combinations

Ø  cos()

Return the cosine value

Ø  cosh()

Return the hyperbolic cosine

Ø  det()

Calculate the determinant of a square matrix

Ø  digits()

Convert a numeric string of certain numeral system to a specific numeral system

Ø  dis()

Calculate the Euclidean distance between two vectors

Ø  exp()

Return e to the nth power

Ø  fact()

Return the factorial

Ø  floor()

Truncate data at the specified position, and reject all the remaining part if any

Ø  gcd()

Return the greatest common divisor

Ø  hash()

Return a hash value

Ø  I()

Generate an identity matrix of a specified size

Ø  inf()

Return positive infinity value

Ø  -inf()

Return negative infinity value

Ø  inverse()

Calculate the inverse of a square matrix

Ø  lcm()

Return the least common multiple

Ø  lg()

Return the logarithm

Ø  linefit()

Perform linear fitting using the least squares method

Ø  ln()

Return the natural logarithm

Ø  mae()

Calculate the mean absolute error between two vectors

Ø  mse()

Calculate the standard error of the mean between two vectors

Ø  mul()

Calculate the product of two matrices or vectors

Ø  norm()

Normalize a matrix or a vector

Ø  not()

On integers, perform bitwise NOT operation to get the logical negation on each bit

Ø  ntile()

Get the bucket number of the subset where a certain member of the set settles

Ø  or()

Perform bitwise OR operation on integers

Ø  pearson()

Calculate Pearson’s correlation coefficient between two vectors

Ø  permut()

Return the number of permutations

Ø  pi()

The ratio of a circle’s circumference to its diameter

Ø  polyfit()

Calculate the coefficient between two vectors in polynomial fitting

Ø  power()

Perform exponentiation or find the nth root of a number

Ø  product()

Return the product of a set of numbers

Ø  rand()

Return a random value

Ø  rankm()

Return the rank of a matrix

Ø  remainder()

Calculate remainder for degree to radian conversion

Ø  rgb()

Convert the red, green, blue, and transparency values to the corresponding color value

Ø  round()

Truncate data at the specified position and round off the remaining part

Ø  spearman()

Calculate Spearman’s correlation coefficient between two vectors

Ø  shift()

Perform a shift operation

Ø  sign()

Judge whether the parameter is a positive or negative number or a 0

Ø  sin()

Return the sine value

Ø  sinh()

Return the hyperbolic sine

Ø  sqrt()

Return the square root

Ø  tan()

Return the tangent value

Ø  tanh()

Return the hyperbolic tangent

Ø  transpose()

Transpose a matrix

Ø  var()

Calculate the generalized variance of a vector (sequence)

Ø  var(x)

Calculate the overall variance for the aggregation field value

Ø  xor()

Perform bitwise XOR operation on integers