Excel to Analytica Mappings/Math Functions

This page shows how Excel Mathematical functions translate to Analytica equivalents

ABS(x)

Analytica equivalent:

Abs(x)

ACOS(x)

Analytica equivalent:

ArcCos(x)

ACOSH(x)

Analytica equivalent:

Ln(x+Sqrt( (x-1)*(x+1) )

ASIN(x)

Analytica equivalent:

ArcSin(x)

ASINH

Analytica equivalent:

Ln(x+Sqrt(x^2+1))

ATAN(x)

Analytica equivalent:

ArcTan(x)

ATAN2(x,y)

Analytica equivalent:

ArcTan2(y,x)

ATANH

Analytica equivalent:

Ln( (1+x)/(1-x) ) / 2

CEILING(x)

Analytica equivalent:

Ceil(x)

Analytica does not provide an equivalent to CEILING(x,significance). You can approximate this using:

Ceil( x / abs(significance) ) * significance

This is only an approximation since round-off errors can through it off slightly.

COMBIN(n,k)

Analytica equivalent:

Combinations(k,n)

COS(x)

Analytica equivalent:

Cos(x)

COSH

Analytica equivalent:

Cosh(x)

DEGREES(angle_in_radians)

Analytica equivalent:

Degrees(angle_in_radians)

EVEN(x)

Analytica equivalent:

2*Round(x/2)

EXP(x)

Analytica equivalent:

Exp(x)

FACT(n)

Analytica equivalent:

Factorial(n)

FACTDOUBLE(n)

This function is not provided by Analytica. The following user-defined function can be used:

Function FactDouble( n : scalar )
Definition: Product( Sequence(n,1,2) )

FLOOR(x)

Analytica equivalent:

Floor(x)

Analytica does not have an exact equivalent to FLOOR(x,significance), but this can be approximated as:

Floor(x/significance) * significance

This is only an approximation because numeric roundoff may cause slight descrepancies.

INT(x)

Analytica equivalent:

Floor(x)

LN(x)

Analytica equivalent:

Ln(x)

LOG(x,base)

Analytica equivalent:

Ln(x) / Ln(base)

LOG10(x)

Analytica equivalent:

LogTen(x)

MDETERM(array)

Analytica equivalent:

Determinant(array,I,J)

where I and J are indexes of array.

MINVERSE(array)

Analytica equivalent:

Invert(array,I,J)

where I and J are indexes of array.

MMULT(array1,array2)

Analytica equivalent:

MatrixMultiply(array1,I1,J1,array2,I2,J2)

where I1 and J1 are the indexes of array1, and I2 and J2 are the indexes of array2. J1 and I2 must be of the same length.

MOD(number,divisor)

Analytica equivalent:

Mod(number,divisor)

MROUND(number,multiple)

There is no precise equivalent to this, but you can accomplish this using:

Round(number/multiple) * multiple

MULTINOMIAL(a,b,c,...)

If the numbers are small enough so that numeric overflow is not a problem, this can be encoded as follows, where the numbers are in array A along index I:

Factorial(Sum(A,I)) / Sum(Factorial(A),I)

ODD(number)

Analytica equivalent:

Ceil((number-1)/2) * 2 + 1

PI()

Analytica equivalent:

Pi

POWER(number,power)

Analytica equivalent:

number^power

PRODUCT(number1,number2,...)

Analytica equivalent:

number1 * number2 * ....

or if your numbers are in an array:

Product(A,I)

QUOTIENT(numerator,denominator)

Analytica equivalent:

numerator / denominator

RADIANS(angle_in_degrees)

Analytica equivalent:

Radians(angle_in_degrees)

RAND( )

Analytica equivalent:

Random()

RANDBETWEEN(bottom,top)

Analytica equivalent:

Random(Uniform(bottom,top,integer:true))