Functions by category
Function list (to be categorized) (Back to Analytica Reference)
See also: functions by category. Functions to be organized Rare and deprecated functions
Language, control, and syntax
Operators: Arithmetic: + - * / ^ Comparison: = < > <> <= >= Logical: And, Or, Not; Text concatenation: &; Subscript and slice: x[I=x], x[@I=x] :Assignment: :=, Reference: \, Dereference: #,
Conditional constructs: If-Then-Else, Ifall-Then-Else, Ifonly-Then-Else, If0, Ifpos
Grouped expressions: (expr; expr), BEGIN expr; expr END
Comments: { commented text }
Declaring local variables: Using x DO; Var x; Index i; MetaVar v; MetaIndex i; Alias a
Mathematics
Basic math: Abs, Sign, Mod, Round, Ceil, Floor, Sqr, Sqrt, Exp, Ln, LogTen, Factorial, Degrees, Radians
Trigonometry: Sin, Cos, Tan; Sinh, Cosh, Tanh; ArcSin, ArcCos, ArcTan, ArcTan2; ArcSinH, ArcCosH, ArcTanH
Complex numbers: RealPart, ImPart, ComplexDegrees, ComplexRadians, Conj
Statistics and Probability distributions
Statistics: Median, Mean, SDeviation, Variance, Skewness, Kurtosis, Statistics, Probability, GetFract, ProbBands
Custom distributions: CumDist, Fractiles, ChanceDist, ProbDist, ProbTable, Random
Discrete distributions: Bernoulli, Binomial, NegativeBinomial, Combinations, Permutations, Geometric, HyperGeometric, Certain
Continuous distribution functions: Uniform, Normal, LogNormal, Beta, Triangular, Poisson, Exponential, Gamma, StudentT, Weibull, Wilcoxon, Logistic, BesselJ, BesselY, BesselI, BesselK, ChiSquared
Modifying distributions: Mid, Sample, Truncate, Shuffle
Functions for distributions: ProbWilcoxon, CumWilcoxon, CumWilcoxonInv, BetaI, BetaIInv, GammaI, GammaIInv, CumNormal, CumNormalInv
SIPs and SLURPs: SipDecode, SipEncode
Text functions: SelectText, FindInText, TextReplace, SplitText, JoinText, Text Concatenation: t1&t2 TextLength, TextLowerCase, TextUpperCase, TextSentenceCase, TextTrim
Array functions
Make an Index: Sequence, Sequence Operator: first..last, SortIndex, SplitText, SubIndex, Subset, Unique
Array reducing: Sum, Product, Average, Max Min, ArgMin_and_ArgMax, JoinText, Condmax, Condmin, Area
Subscript, selection, lookup: Slice, Subscript, StepInterp, Slice Operator: [@I=n]
Array mapping:
Tables and functions to make arrays: Array, Table, SubTable, MultiTable, DetermTable, ProbTable
Interpolation: StepInterp, LinearInterp, CubicInterp, MonoCubicInterp
Matrix
Information about arrays: Size, IndexesOf, IndexNames, MemoryInUseBy
Relational tables:
Other array functions
Financial
User interaction and dialog
User input
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
- SpreadsheetOpen, SpreadsheetSave
- SpreadsheetCell, SpreadsheetRange
- SpreadsheetSetCell, SpreadsheetSetRange
- SpreadsheetInfo, SpreadsheetSetInfo
- OpenExcelFile -- depreciated: use SpreadsheetOpen
Database and ODBC access
COM API
Error handling
Set functions
Objects and meta-inference
- ListOfHandles
- Dereference Operator: #R : Return the value pointed to by a reference R.
- IndexesOf, IndexNames
- GetVariableByName
- IndexValue
- AttribGet
User modifiable attributes
Other common attributes
Rare attributes
Sensitivity analysis
Special
Evaluation
Analytica environment information
Function parameter qualifiers
Functions still to be categorized
- 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)
- InsertRecSql (ODBC Library.ana)
- InverseGaussian (Distribution Variations.ana)
- InvertedWishart (Distribution Variations.ana)
- InvLogit (Generalized Regression.ana)
- LDens_InvertedWishart (Distribution Densities.ana)
- LDens_Wishart (Distribution Densities.ana)
- LGamma
- 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_Regression (Generalized Regression.ana)
- Logit (Generalized Regression.ana)
- Lognormal_m_sd (Distribution variations.ana) - obsolete, use LogNormal (mean:m,stddev:sd)
- Lorenzian (Distribution variations.ana)
- 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)
Optimizer functions
- OptEngineInfo
- OptFindIIS
- OptGuess
- OptInfo
- OptObjective
- OptObjectiveSa
- OptRead
- OptReducedCost
- OptRhsSa
- OptScalarToConstraint
- OptScalarToDecision
- OptShadow
- OptSlack
- OptSolution
- OptStatusNum
- OptStatusText
- OptWrite
- OptWriteIIS
Enable comment auto-refresher