Functions by category

---

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

Loops: While..Do, For..Do

Grouped expressions: (expr; expr), BEGIN expr; expr END

Comments: { comment }, /* comment */

Local variables: VAR x, Index i; MetaVar v; MetaIndex i; Alias a, Local Index Operator::A.I

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

Set functions: SetContains, SetDifference, SetEvaluationFlag, SetIntersection, SetUnion

Complex numbers: RealPart, ImPart, ComplexDegrees, ComplexRadians, Conj

Signal processing: FFT, FFTInv

Dates, Text, Financial

Date and Time: MakeDate, DateAdd, DatePart, Today, ParseDate, IsDateTime

Text: SelectText, FindInText, TextReplace, SplitText, JoinText, Text Concatenation: t1&t2, TextLength, TextLowerCase, TextUpperCase, TextSentenceCase, TextTrim

Financial: Pv, Fv, Npv, XNpv, Rate, NPer, Pmt, PPmt, IPmt, CumIPmt, Irr, XIrr

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, Slice Operator: [@I=n], StepInterp

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

Statistics and Probability distributions

Statistics: Median, Mean, SDeviation, Variance, Skewness, Kurtosis, Statistics, Probability, Frequency, 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

Sensitivity analysis: Dydx, Elasticity, WhatIf, WhatIfAll , Tornado charts, X-Y plots, Scatter plots

Functions for distributions: ProbWilcoxon, CumWilcoxon, CumWilcoxonInv, BetaI, BetaIInv, GammaI, GammaIInv, CumNormal, CumNormalInv, Erf, ErfInv

SIPs and SLURPs: SipDecode, SipEncode

Distribution Variations.ana: Gamma_m_sd, GammaFn, GammaI, GammaIInv, InverseGaussian, InvertedWishart, Lorenzian, NegBinomial

Multivariate Distributions.ana: Gaussian, Multinomial, MultiNormal, MultiUniform, Normal_additive_gro, Normal_compound_gro, Normal_correl, Normal_serial_correl

Distribution Densities.ana: LDens_InvertedWishart, LDens_Wishart, LGamma

User interaction and dialogs

User input: Choice, Checkbox, [Choice menus and Checkboxes in an edit table|Choices & Checkboxes in an Edit table]]

Dialog boxes: MsgBox, Error, AskMsgText, AskMsgChoice, AskMsgNumber, ShowProgressBar

Types and type conversion

Convert type: Chr, Asc, NumberToText, ParseDate, ParseNumber

Get or test type: TypeOf, IsDateTime, IsHandle, IsNaN, IsNull, IsNumber, IsRealNumber, IsReference, IsText, IsUndef, IsResultComputed, IsNotSpecified

Optimizer functions

Optimizer formulation: DefineOptimization, OptSolution, OptInfo, OptObjective, GroupedInteger, OptGuess, OptEngineInfo

Optimizer diagnostics: OptStatusNum, OptStatusText, OptFindIIS, OptWriteIIS, OptObjectiveSa, OptRead, OptWrite, OptReducedCost, OptRhsSa, OptScalarToConstraint, OptScalarToDecision, OptShadow, OptSlack

Integration with other applications

Reading and writing data: ReadFromUrl, OpenURL, ReadImageFile, ReadTextFile, WriteTextFile, ShowPdfFile

Spreadsheet access: SpreadsheetOpen, SpreadsheetCell, SpreadsheetRange, SpreadsheetSetCell, SpreadsheetSetRange,SpreadsheetSave,, SpreadsheetInfo, SpreadsheetSetInfo

Database and ODBC access: SqlDriverInfo, DbLabels, DbQuery, DbTable, DbTablenames, DbWrite, MdxQuery

Run other applications: RunConsoleProcess

COM API: COMArray, COMCallMethod, COMCreateObject, COMGetProperty

Special functions

Meta-inference: Handle, HandleFromIdentifier, ListOfHandles, FindObjects, Dereference Operator: #R IndexesOf, IndexNames, GetVariableByName, IndexValue, AttribGet

Evaluation: Mid, Sample, Evaluate, EvaluateScript, GetEvaluationContext

Error handling: Error, IgnoreWarnings, Try, ReThrow

'Miscellaneous: Discrete, Dispatch, FunctionOf, Dynamic, Iterate, FindPolynomialZeroes

Domain expressions: Continuous, Discrete, Integer, Boolean and Discrete

Domain Access Functions: DomainType, DomainType, DomainLowerBound, DomainUpperBound, DomainIntegerGroup

Attributes

User editable for variables: Class, Identifier, Title, Units, Description, Definition, Domain, MetaIndex, User-defined attributes

User editable for Functions: Parameters

User editable for Models, Modules, and Libraries: Author, Savedate, Filename

Computed: Value, Probvalue, Inputs, Outputs

Internal: Diagwindow, ObjectWindow .....

System variables: Run, Time, AnalyticaLicenseInfo, GetProcessInfo, GetRegistryValue, MemoryInUseBy

Function parameter qualifiers

Data types: Number, Text, Positive, NonNegative, Ascending, Descending, Reference, Handle, Coerce <type>

Object class: Index, Variable, Object

Optional and repeated parameters: Optional, Default, Repeated parameters (...)

Arrays: Atom or scalar, Vector, Array, Reduced

Libraries

Standard libraries, Extra libraries, GCD function library.ana: GCD

Optimization Functions.ana: GoalSeek, Gradient

Financial library.ana: Implied_volatility_c, Implied_volatility_p

ODBC Library.ana: InsertRecSql,

Generalized Regression.ana: InvLogit, Logistic_Regression, Logit

Linked List Library.ana: LL_First, LL_Length, LL_Nth, LL_Push, LL_Remove_First, LL_To_Array, LL_to_RArray

Obsolete and deprecated functions