Alphabetical Function List

(Back to Analytica Reference)

See also: functions by category.

• =,<,>,<>,<=,>= : Comparison operators
• [I=x]  : Subscript operator
• [@I=x]  : Slice operator
• \ : Reference operator
• # : Dereference operator
• @ : Index Position operator
• := : Assignment operator
• & : Text concatenation operator
• A.I : Dot operator, to access a local index of an array
• Abs
• Aggregate
• AnalyticaLicenseInfo
• And
• ArcCos
• ArcCosH
• ArcSin
• ArcSinH
• ArcTan
• ArcTan2
• ArcTanH
• Area
• Argmax
• Argmin
• Array
• Asc
• AskMsgNumber
• AskMsgText
• Assignment Operator:: ::= : Assignment operator
• AttribGet
• Average
• Bernoulli
• BesselJ, BesselY, BesselI, BesselK
• Beta
• Beta_m_sd (Distribution variations.ana)
• Betafn
• BetaI
• BetaIInv
• Binomial
• BiNormal (Multivariate distributions.ana)
• Boolean
• CAbs (Complex Library.ana)
• CAdjoint (Complex Library.ana)
• Calloption (Financial Library.ana)
• Capm (Financial Library.ana)
• CArcCos (Complex Library.ana)
• CArcSin (Complex Library.ana)
• CArcTan (Complex Library.ana)
• CCos (Complex Library.ana)
• CDeterminant (Complex Library.ana)
• Cdf
• CDiv (Complex Library.ana)
• Ceil
• Certain
• CExp (Complex Library.ana)
• ChanceDist
• Change_index (Expand Index.ana)
• ChiSquared
• Choice
• CInverse (Complex Library.ana)
• Chr
• CLn (Complex Library.ana)
• CMatMult (Complex Library.ana)
• CMult (Complex Library.ana)
• Coerce_to_Numeric (Flat file library.ana)
• Combinations
• Comparison Operators: =, <, >, <>, <=, >=
• Complex (Complex Library.ana)
• CompressMemoryUsedBy
• ComputedBy
• Concat
• Concat<N> (Concatenation UDFs.ana
• ConcatRows (Concatenation UDFs.ana)
• Condmax
• Condmin
• Continuous
• CopyIndex
• Correlate_Dists (Multivariate Distributions.ana)
• Correlate_With (Multivariate Distributions.ana)
• Correlation
• Cos
• Cosh
• CostCapme (Financial Library.ana)
• CostCapmm (Financial library.ana)
• CRoots (Complex Library.ana)
• CSin (Complex Library.ana)
• CSqrt (Complex Library.ana)
• CTan (Complex Library.ana)
• CTheta (Complex Library.ana)
• CToPolar (Complex Library.ana)
• CubicInterp
• CumBinomial (Distribution Densities Library)
• CumChiSquared (Distribution Densities Library)
• CumChiSquaredInv (Distribution Densities Library)
• CumDist
• CumExponential (Distribution Densities Library)
• CumExponentialInv (Distribution Densities Library)
• CumFDist (Distribution Densities Library)
• CumFDistInv (Distribution Densities Library)
• CumIPmt
• CumLogistic (Distribution Densities Library)
• CumLogisticInv (Distribution Densities Library)
• CumLogNormal (Distribution Densities Library)
• CumLogNormalInv (Distribution Densities Library)
• CumNormal
• CumNormalInv
• CumPoisson (Distribution Densities Library)
• CumPrinc
• CumProduct
• CumStudentT (Distribution Densities Library)
• CumStudentTInv (Distribution Densities Library)
• CumTriangular (Distribution Densities Library)
• CumTriangularInv (Distribution Densities Library)
• Cumulate
• CumUniform (Distribution Densities Library)
• CumUniformInv (Distribution Densities Library)
• CumWeibull (Distribution Densities Library)
• CumWeibullInv (Distribution Densities Library)
• CurrentDataDirectory
• CurrentModelDirector
• DateAdd
• DatePart
• DbLabels
• DbQuery
• DbTable
• DbTablenames
• DbWrite
• Decompose
• Degrees
• Dens_Beta (Distribution Densities Library)
• Dens_ChiSquared (Distribution Densities Library)
• Dens_CumDist (Distribution Densities Library)
• Dens_Exponential (Distribution Densities Library)
• Dens_FDist (Distribution Densities Library)
• Dens_Gamma (Distribution Densities Library)
• Dens_Gaussian (Distribution Densities Library)
• Dens_Logistic (Distribution Densities Library)
• Dens_LogNormal (Distribution Densities Library)
• Dens_Normal (Distribution Densities Library)
• Dens_ProbDist (Distribution Densities Library)
• Dens_StudentT (Distribution Densities Library)
• Dens_Triangular (Distribution Densities Library)
• Dens_Uniform (Distribution Densities Library)
• Dens_Weibull (Distribution Densities Library)
• Dereference Operator: #R : Return the value pointed to by a reference R.
• Determinant
• DetermTable
• Dirichlet (Multivariate distributions.ana)
• Discrete
• Dispatch
• Dist_additive_growth (Multivariate distributions.ana)
• Dist_compound_growth (Multivariate distributions.ana)
• Dist_reshape (Multivariate distributions.ana)
• Dist_serial_correl (Multivariate distributions.ana)
• DomainAllowed
• DomainIntegerGroup
• DomainLowerBound
• DomainNullOk
• DomainType
• DomainUpperBound
• DotProduct
• Dydx
• Dynamic
• EigenDecomp
• Elasticity
• Erf
• ErfInv
• Erlang (Distribution variations.ana)
• Error
• Evaluate
• EvaluateScript
• Exp
• Exponential
• expr1 ; expr2 : Expression Sequence Operator
• Factorial
• FindInText
• FindPolynomialZeroes
• Floor
• For..Do
• Fractiles
• Frequency
• FunctionOf
• Fv
• Gamma
• Gamma_m_sd (Distribution Variations.ana)
• GammaFn
• GammaI
• GammaIInv
• Gaussian (Multivariate Distributions.ana)
• GCD (GCD function library.ana)
• Geometric
• GetFract
• GetProcessInfo
• GetRegistryValue
• GetVariableByName
• GoalSeek (Optimization Functions.ana)
• Gradient (Optimization Functions.ana)
• GroupedInteger
• HyperGeometric
• If-Then-Else
• Ifall-Then-Else
• Ifonly-Then-Else
• If0
• Ifpos
• IgnoreWarnings
• Im (Complex Library.ana)
• Implied_volatility_c (Financial library.ana)
• Implied_volatility_p (Financial library.ana)
• Index Position Operator: @I, @[I=x]  : Get the numeric position of index elements
• IndexesOf
• Index..Do
• IndexNames
• IndexValue
• InsertRecSql (ODBC Library.ana)
• Integer
• Integrate
• InverseGaussian (Distribution Variations.ana)
• Invert
• InvertedWishart (Distribution Variations.ana)
• InvLogit (Generalized Regression.ana)
• IPmt
• Irr
• IsHandle
• IsNaN
• IsNotSpecified
• IsNull
• IsNumber
• IsReference
• IsResultComputed
• IsText
• IsUndef
• Iterate
• Join
• JoinText
• Kurtosis
• LDens_InvertedWishart (Distribution Densities.ana)
• LDens_Wishart (Distribution Densities.ana)
• LGamma
• LinearInterp
• ListOfHandles
• 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)
• Ln
• 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)
• LogTen
• Lorenzian (Distribution variations.ana)
• LpDefine
• LpFindIIS
• LpObjSa
• LpOpt
• LpRead
• LpReducedCost
• LpRhsSa
• LpShadow
• LpSlack
• LpSolution
• LpStatusNum
• LpStatusText
• LpWrite
• LpWriteIIS
• MakeDate
• MatrixMultiply
• Max
• MdArrayToTable
• MdTable
• MdxQuery
• Mean
• Median
• MemoryInUseBy
• Mid
• Min
• Mod
• MonoCubicInterp
• MsgBox
• Multinomial (Multivariate Distributions.ana)
• MultiNormal (Multivariate Distributions.ana)
• MultiUniform (Multivariate Distributions.ana)
• NegBinomial (Distribution Variations.ana)
• NlpDefine
• Normal
• Normal_additive_gro (Multivariate Distributions.ana)
• Normal_compound_gro (Multivariate Distributions.ana)
• Normal_correl (Multivariate Distributions.ana)
• Normal_serial_correl (Multivariate Distributions.ana)
• Normalize
• Not
• NPer
• Npv
• OpenExcelFile -- depreciated: use SpreadsheetOpen
• OptEngineInfo
• OptFindIIS
• OptGuess
• OptInfo
• OptObjective
• OptObjectiveSa
• OptRead
• OptReducedCost
• OptRhsSa
• OptScalarToConstraint
• OptScalarToDecision
• OptShadow
• OptSlack
• OptSolution
• OptStatusNum
• OptStatusText
• OptWrite
• OptWriteIIS
• Or
• Pareto (Distribution Variations.ana)
• ParseDate
• ParsedExprFunction
• ParsedExprParameters
• ParseNum (Flat file library.ana - for Analytica 4.1)
• ParseNumber
• Pdf
• Permutations
• Pert (Distribution Variations.ana)
• Pmt
• Poisson
• PolarToC (Complex Library.ana)
• Position Operator: @I, @[I=x]  : Get the numeric position of index elements
• PositionInIndex
• PPmt
• Probability
• ProbBands
• ProbDist
• Probit_Regression (Generalized Regression.ana)
• ProbTable
• Prob_Bernoulli (Distribution Densities Library)
• Prob_Binomial (Distribution Densities Library)
• Prob_ChanceDist (Distribution Densities Library)
• Prob_Geometric (Distribution Densities Library)
• Prob_HyperGeometric (Distribution Densities Library)
• Prob_Poisson (Distribution Densities Library)
• Product
• Putoption (Financial Library.ana)
• Pv
• Pvgperp (Financial Library.ana)
• Pvperp (Financial Library.ana)
• QpDefine
• Q_infromrec
• Q_makerect
• Q_squareinterp
• Radians
• Random
• Rank
• RankCorrel
• Rate
• Rayleigh (Distribution variations.ana)
• Re (Complex Library.ana)
• ReadCsvFile (Flat File Library.ana)
• ReadFromUrl
• ReadImageFile
• ReadTextFile
• Reference Operator: \X : Return a reference to X
• Reform
• Regression
• RegressionDist (Multivariate Distributions.ana)
• RegressionFitProb (Multivariate Distributions.ana)
• RegressionNoise (Multivariate Distributions.ana)
• Round
• RunConsoleProcess
• Sample
• SampleCorrelation (Multivariate Distributions.ana)
• SampleCovariance (Multivariate Distributions.ana)
• SaveExcelWorkbook -- deprecated: use SpreadsheetSave
• ScanAttFromModelFile
• SchedulePublish
• SDeviation
• SelectText
• Sequence
• Sequence Operator: first..last
• SetContains
• SetDifference
• SetIntersection
• SetUnion
• ShowPdfFile
• ShowProgressBar
• Shuffle
• Sign
• Sin
• SingularValueDecomp
• Sinh
• SipDecode
• SipEncode
• Size
• Skewness
• Slice
• Slice Operator: [@I=n]
• Smooth_Fractile (Distribution variations.ana)
• Solve (Optimization Functions.ana)
• SolverInfo
• Sort
• SortIndex
• Split
• SplitText
• SpreadsheetCell
• SpreadsheetOpen
• SpreadsheetRange
• SpreadsheetSave
• SpreadsheetSetCell
• SpreadsheetSetRange
• SqlDriverInfo
• Sqr
• Sqrt
• Statistics
• StepInterp
• StringLength
• StringLowercase
• StringMixedCase
• StringReplace
• StringUpperCase
• StudentT
• SubFindString
• SubIndex
• Subscript
• Subscript Operator: [I=x]
• Subset
• SubString
• SubTable
• Sum
• Sys_coordindex
• Sys_localindex
• Table
• Tan
• Tanh
• TestHeapConsistency
• Text Concatenation Operator: A&B : Concatenate two text strings
• TextLength
• TextLowerCase
• TextReplace
• TextSentenceCase
• TextTrim
• TextUpperCase
• Today
• Transpose
• Triangular
• Triangular_10_50_90 (Distribution Variations.ana)
• Triangular_10_mode_90 (Distribution Variations.ana)
• Truncate
• TypeOf
• Uncumulate
• Uniform
• UniformSpherical (Multivariate distributions.ana)
• Unique
• Using..Do
• Var..Do
• Variance
• VarTerm
• Wacc (Financial Library.ana)
• Wald (Distribution Variations.ana)
• Warp_Dist (Distribution variations.ana)
• Weibull
• WhatIf
• WhatIfAll
• While..Do
• Wishart (Distribution variations.ana)
• WorksheetCell -- deprecated: use SpreadsheetCell
• WorksheetRange -- deprecated: use SpreadsheetRange
• WriteCsvFile (Flat file library.ana)
• WriteTableSql (ODBC Library.ana)
• WriteTextFile
• WriteWorksheetCell -- deprecated: use SpreadsheetSetCell
• WriteWorksheetRange -- deprecated: use SpreadsheetSetRange
• XIrr
• XNpv
• YearFrac