Arithmetic Functions

When working with formulas, the user can use predefined arithmetic functions listed in the table:

Name Brief description

Abs

It returns an absolute value (module) of specified variable points.

AbsI

It returns the absolute value (module) of points of specified variable if it contains integer values only.

Average

It returns the average value of specified variable points.

AverageI

It returns the average points value of the specified variable if it contains integer values only.

Cos

It returns cosine of specified variable points.

Division

It returns the quotient of the pointwise division of two variables.

Exp

It returns the result of raising the "e" to the power specified by the variable point.

ExpX

It returns the result of raising variable points to the specified power.

Fact

It returns the points factorial of specified variable.

Floor

It returns the result of variable points rounding up to the nearest multiple of significance with a lack.

FloorI

It returns the result of variable points rounding up to the nearest multiple of significance with a lack. The variable must only contain integer values.

Int

It rounds point values of specified variable to the nearest least integer.

Ln

It returns the points natural logarithm of specified variable.

Log

It returns the logarithm points of specified variable by the specified base.

Log10

It returns the points 10-base logarithm of specified variable.

Max

It returns the maximum value among the points of the variable.

MaxI

It returns the maximum value among variable points if it contains integer values only.

Mean

It returns the expected value for the specified variable.

Median

It returns the median for the specified variable.

Min

It returns the minimum value among variable points.

MinI

It returns the minimum value among the variable points if it contains integer values only.

Mod_

It returns the remainder of the integer division values of variable points to the specified number.

Mode

It returns mode of the specified variable.

Modulus

It returns the remainder of the integer division values of variable points to the specified number.

Mult

It returns the product of corresponding points for two or more variables.

Power

It returns the result of raising variable points to the specified power.

PowerI

It returns the result of raising variable points to the specified power. All variable points and the power must be integers.

Rand

It returns the uniform distributed random number from the [0; 1) range.

RandBetween

It returns a random real number between two specified numbers

RandBetweenI

Returns a random integer number between two specified integer numbers

Remainder

It returns the remainder of integer division of points values to the specified number.

Round

It rounds the variable point values.

RoundDown

It performs rounding with a lack of a variable points values.

RoundUp

It rounds the variable points with a roundup.

Sin

It returns the sinus of specified variable points.

Sqrt

It returns the square root of the specified variable points.

StDv

It returns the standard deviation for the specified variable.

Subtract

It returns the difference of corresponding points for two or more variables.

Tan

It returns the tangent of specified variable points.

Trunc

It truncates variable points to the specified number of decimal places.

Variance

It returns the variable variance.

NOTE. In the Modeling and Forecasting unit it is prohibited to use the AbsI, FloorI, PowerI, RandBetweenI, MinI, MaxI functions in the models calculated in transformation problem.

See also:

Functions Available in Expression Editor