Functions by category

Function list (to be categorized) (Back to Analytica Reference)

Language, control, and syntax

Operators

+ - * / ^ : Arithmetic operators
x^y : Exponentiation
= < > <> <= >= : Comparison operators
Logical operators: And, Or, Not
x[I=x], x[@I=x] : Subscript and slice operators
\, #: Reference and dereference operators
:= : Assignment operator
& : Text concatenation operator
A.I: Dot operator, to access a local index of an array
... : Repeated parameter forwarding
Index Position Operator: @I, @[I=x] : Get the numeric position of index elements
PositionInIndex

Constructs and loops

expr1 ; expr2 : Expression Sequence Operator
If-Then-Else, Ifall-Then-Else, Ifonly-Then-Else
While..Do, For..Do
If0, Ifpos

Declarations of local variables

Mathematics

Basic math

Abs, Sign, Round, Ceil, Floor

Sqr, Sqrt, Exp, Ln, LogTen

Factorial

Degrees, Radians

=Trigonometry

Probability distributions

Statistics

Return statistics from random samples:

Mean, SDeviation, Variance, Skewness, Kurtosis
Statistics
Probability
GetFract, ProbBands
RankCorrel
Regression

Custom distribution functions

Discrete distribution functions

Continuous distribution functions

Uniform, Normal, Beta, Triangular, Poisson
Exponential, Gamma, StudentT, Weibull, Wilcoxon
BesselJ, BesselY, BesselI, BesselK

Modifying distributions

Functions for distributions

Date and Time: Today, MakeDate, DateAdd, DatePart

Text functions

SelectText, FindInText, TextReplace
SplitText, JoinText
Text Concatenation Operator: A&B : Concatenate two text strings
TextLength
TextLowerCase, TextUpperCase, TextSentenceCase
TextTrim

Array functions

Make an Index

Size
Reform

= Array reducing

Subscript, selection, lookup

Slice, Subscript, StepInterp

Array mapping

Cumulate, Uncumulate, CumProduct
Rank

Tables and functions to make arrays

Interpolation

StepInterp, LinearInterp, CubicInterp

Matrix

Other array functions

Financial

User interaction and dialog

User input

Choice, Checkbox

User dialog boxes

Types and type conversion

Chr, Asc
NumberToText, Coerce_to_Numeric (Flat file library.ana)
ParseDate, ParseNumber
TypeOf
IsDateTime
IsHandle
IsNaN
IsNotSpecified
IsNull
IsNumber
IsRealNumber
IsReference
IsResultComputed
IsText
IsUndef

Integration with other applications

Reading data

Spreadsheet access

OpenExcelFile -- depreciated: use SpreadsheetOpen

Database and ODBC access

AttribGet

RunConsoleProcess

COM API

Error handling

Complex numbers

Set functions

Objects and meta-inference

ListOfHandles
Dereference Operator: #R : Return the value pointed to by a reference R.
IndexesOf, IndexNames
GetVariableByName
IndexValue

User modifiable attributes

Other common attributes

Rare attributes

Sensitivity analysis

Special

Dynamic

Evaluation

Analytica information

AnalyticaLicenseInfo, GetProcessInfo

GetRegistryValue

Function parameter qualifiers

Boolean

Functions still to be categorized

FindPolynomialZeroes

Gamma_m_sd (Distribution Variations.ana)
GammaFn
GammaI
GammaIInv
Gaussian (Multivariate Distributions.ana)
GCD (GCD function library.ana)

GoalSeek (Optimization Functions.ana)
Gradient (Optimization Functions.ana)

Im (Complex Library.ana)
Implied_volatility_c (Financial library.ana)
Implied_volatility_p (Financial library.ana)

Index..Do

InsertRecSql (ODBC Library.ana)
Integer
Integrate
InverseGaussian (Distribution Variations.ana)
Invert
InvertedWishart (Distribution Variations.ana)
InvLogit (Generalized Regression.ana)

Iterate
Join

LDens_InvertedWishart (Distribution Densities.ana)
LDens_Wishart (Distribution Densities.ana)
LGamma
LinearInterp

LL_First (Linked List Library.ana)
LL_Length (Linked List Library.ana)
LL_Nth (Linked List Library.ana)
LL_Push (Linked List Library.ana)
LL_Remove_First (Linked List Library.ana)
LL_To_Array (Linked List Library.ana)
LL_to_RArray (Linked List Library.ana)

Local Index Operator::A.I : Get an index (usually a local index) of an array
Logistic
Logistic_Regression (Generalized Regression.ana)
Logit (Generalized Regression.ana)
LogNormal
Lognormal_m_sd (Distribution variations.ana) - obsolete, use LogNormal (mean:m,stddev:sd)

Lorenzian (Distribution variations.ana)

Max
MdArrayToTable
MdTable
MdxQuery
Mean
Median
MemoryInUseBy
Mid
Min
Mod
MonoCubicInterp
MsgBox
Multinomial (Multivariate Distributions.ana)
MultiNormal (Multivariate Distributions.ana)
MultiUniform (Multivariate Distributions.ana)
Normal_additive_gro (Multivariate Distributions.ana)
Normal_compound_gro (Multivariate Distributions.ana)
Normal_correl (Multivariate Distributions.ana)
Normal_serial_correl (Multivariate Distributions.ana)
NegBinomial (Distribution Variations.ana)

Normalize

OpenURL

Optimizer functions

GroupedInteger

Obsolete optimizer