3.5.2.1 Basic Mathematical Functions

Name Brief Example
Abs Returns the absolute value of x Example
Acos Returns the inverse of the corresponding trigonometric function.
Acot Returns the inverse of the corresponding trigonometric function.
Acoth Returns the inverse of the corresponding hyperbolic cotangent.
Acsc Returns the inverse of the corresponding trigonometric function.
Acsch Return the inverse hyperbolic cosecant. Example
Angle Returns the angle in radians measured between the positive X axis and the line joining the origin (0,0) with the point given by (x, y).
Angleint1 returns angle with one line which through two points(x1, y1) and (x2, y2) with X axis. Returns degrees if unit=1 or radians if unit=0, default is radians.
Angleint2 returns angle with two lines. Returns degrees if unit=1 or radians if unit=0, default is radians.
Asec Returns the inverse of the corresponding trigonometric function.
Asech Returns the inverse of the hyperbolic secant. Example
Asin Returns the inverse of the corresponding trigonometric function.
Atan Returns the inverse of the corresponding trigonometric function.
Atan2 Returns the angle in radians measured between the positive X axis and the line joining the origin (0,0) with the point given by (x, y). Example
Asinh Returns the inverse hyperbolic sine. Example
Acosh Returns the inverse hyperbolic cosin. Example
Atanh Return the inverse hyperbolic tangent. Example
Ceil Returns a value by adjusting the given value d away from 0 and to the multiple of significance nearest to d. Example
Combina Returns the number of k-combinations (with repetitions) from a given set with n elements. Example
Combine Returns the number of k-combinations from a given set with n elements. Example
Cos Return value of cosine for each value of the given x.
Cosh Returns the hyperbolic form of cos(x) .
Cot Return value of cotangent for each value of the given x.
Coth Returns the hyperbolic cotangent.
Csc Return value of cosecant of given x.
Csch Returns the hyperbolic cosecant of given x.
Degrees Converts the radians into degrees. Example
Derivative Returns the derivative of the data list in a give vector. Example
DerivativeXY Return the derivative of the curve whose XY coordinates denoted by vector vx and vy. Example
Distance Returns the distance with two points.
Distance3D Returns the distance with two points in 3D.
Exp Returns the exponential value of x.
Expm1 Returns the value of exp(x)-1 accurately for the small values of x. Example
Fact Returns the factorial of a non-negative integer n. Example
FactDouble Returns the double factorial of the specified number. Example
Floor Returns a value by adjusting the given value d towards 0 and to the multiple of significance nearest to d. Example
Frac Returns the fractional part of a number. Example
gcd Returns the greatest common divisor of a group of given integers n1, n2, n3, etc. Example
Imatan Returns the complex value of inverse tangent for complex input number Example
Imatanh Returns the complex value of inverse hyperbolic tangent for complex input number Example
Index Return the row index where x occurs in a strictly monotonic dataset, according to condition defined by ctrl. Example
Int Return the truncated integer of x.
Integral Returns the integral value of the specified integrand. Example
Integrate Returns the cumulative areas as dataset from the integration. Example
IntegrateXY Used to integrate area under curve specified by vectors vx and vy. Missing values will be ignored.
Interp Used to perform 1D interpolation or extrapolation on a group of XY data to find Y at the given X value using 4 alternative methods.
Ln Return the natural logarithm value of x. Example
Ln1p Return the natural logarithm value of x when x is very approaching to 1. Example
Log Return the base 10 logarithm value of x.
Mod Return the integer modulus (the remainder from division) of integer x divided by integer y.
Mod2 Return the integer modulus (the remainder from division) of integer n divided by integer m.
Movavg Return the adjacent average in a specific range of certain cell.
Nint Return value of the nint(x) function is identical to round(x, 0).
Permut Returns the number of k-permutations from a given set with n elements. Example
Permutationa Returns the number of k-permutations (with repetations) from a given set with n elements. Example
Prec Returns a factor. (Quality Control D3 Factor) Example
Radians converts degrees into radians.
Rmod Return a value (or a dataset) such that the numbers contain p places of significance. Example
Rmod2 Return the real modulus (the remainder from division) of real number x divided by real number y. Example
Round Return a value (or a dataset) with p decimal places accuracy.
Secant Return value of secant for each value of the given x.
Sech Return the hyperbolic secant.
Sign Return the sign of real number x. It returns 1 if x>0 and returns -1 if x<0; For x=0, zero is returned.
Sin Return value of sine for each value of the given x.
Sinh Return the hyperbolic form of sin(x).
Sqrt Return the square root of x.
Tan Returns value of tangent for each value of the given x.
Tanh Return the hyperbolic form of and tan(x).