Arithmetic Functions

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

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.