When working with formulas, the user can use predefined arithmetic functions listed in the table:
Name | Brief description |
It returns an absolute value (module) of specified variable points. | |
It returns the absolute value (module) of points of specified variable if it contains integer values only. | |
It returns the average value of specified variable points. | |
It returns the average points value of the specified variable if it contains integer values only. | |
It returns cosine of specified variable points. | |
It returns the quotient of the pointwise division of two variables. | |
It returns the result of raising the "e" to the power specified by the variable point. | |
It returns the result of raising variable points to the specified power. | |
It returns the points factorial of specified variable. | |
It returns the result of variable points rounding up to the nearest multiple of significance with a lack. | |
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. | |
It rounds point values of specified variable to the nearest least integer. | |
It returns the points natural logarithm of specified variable. | |
It returns the logarithm points of specified variable by the specified base. | |
It returns the points 10-base logarithm of specified variable. | |
It returns the maximum value among the points of the variable. | |
It returns the maximum value among variable points if it contains integer values only. | |
It returns the expected value for the specified variable. | |
It returns the median for the specified variable. | |
It returns the minimum value among variable points. | |
It returns the minimum value among the variable points if it contains integer values only. | |
It returns the remainder of the integer division values of variable points to the specified number. | |
It returns mode of the specified variable. | |
It returns the remainder of the integer division values of variable points to the specified number. | |
It returns the product of corresponding points for two or more variables. | |
It returns the result of raising variable points to the specified power. | |
It returns the result of raising variable points to the specified power. All variable points and the power must be integers. | |
It returns the uniform distributed random number from the [0; 1) range. | |
It returns a random real number between two specified numbers | |
Returns a random integer number between two specified integer numbers | |
It returns the remainder of integer division of points values to the specified number. | |
It rounds the variable point values. | |
It performs rounding with a lack of a variable points values. | |
It rounds the variable points with a roundup. | |
It returns the sinus of specified variable points. | |
It returns the square root of the specified variable points. | |
It returns the standard deviation for the specified variable. | |
It returns the difference of corresponding points for two or more variables. | |
It returns the tangent of specified variable points. | |
It truncates variable points to the specified number of decimal places. | |
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: