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, Correlation, RankCorrel, Regression, Cdf, Pdf
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
Other types of data
Date and Time: MakeDate, DateAdd, DatePart, Today
Text: 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: Cumulate, Uncumulate, CumProduct, Normalize, Integrate, Rank, Sort, Aggregate
Tables and functions to make arrays: Array, Table, SubTable, MultiTable, DetermTable, ProbTable, AddIndex
Interpolation: StepInterp, LinearInterp, CubicInterp, MonoCubicInterp
Matrix: MatrixMultiply, Transpose, Invert, Determinant, Decompose, EigenDecomp, SingularValueDecomp
Information about arrays: Size, IndexesOf, IndexNames, MemoryInUseBy
Relational tables: MdTable, MdArrayToTable
Other array functions: Aggregate
Financial: Pv, Fv, Npv, XNpv, Rate, NPer, Pmt, PPmt, IPmt, CumIPmt, Irr, XIrr
User interaction and dialog
Dialog boxes: MsgBox, Error, AskMsgText, AskMsgChoice, AskMsgNumber, ShowProgressBar
Types and type conversion
Get or test type: TypeOf, IsDateTime, IsHandle, IsNaN, IsNull, IsNumber, IsRealNumber, IsReference, IsText, IsUndef, IsResultComputed
Integration with other applications
Reading and writing data: ReadFromUrl, OpenURL, ReadImageFile, ReadTextFile, WriteTextFile, ShowPdfFile
Spreadsheet access: SpreadsheetOpen, SpreadsheetSave, SpreadsheetCell, SpreadsheetRange, SpreadsheetSetCell, SpreadsheetSetRange, SpreadsheetInfo, SpreadsheetSetInfo
Database and ODBC access: SqlDriverInfo, DbLabels, DbQuery, DbTable, DbTablenames, DbWrite, MdxQuery
COM API: COMArray, COMCallMethod, COMCreateObject, COMGetProperty
Error handling: Error, IgnoreWarnings, Try, ReThrow
Set functions: SetContains, SetDifference, SetEvaluationFlag, SetIntersection, SetUnion
Objects and meta-inference
- ListOfHandles, Dereference Operator: #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
Linked List Library.ana: LL_First, 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)
- Lorenzian (Distribution variations.ana)
Multivariate Distributions.ana: Multinomial, MultiNormal, MultiUniform, Normal_additive_gro, Normal_compound_gro, Normal_correl, Normal_serial_correl
- NegBinomial (Distribution Variations.ana)
Optimizer functions
- DefineOptimization, OptObjective,
- OptEngineInfo
- OptFindIIS
- OptGuess
- OptInfo
- OptObjectiveSa
- OptRead
- OptReducedCost
- OptRhsSa
- OptScalarToConstraint
- OptScalarToDecision
- OptShadow
- OptSlack
- OptWrite
- OptWriteIIS
Enable comment auto-refresher