Difference between revisions of "Functions by category"
m |
m |
||
| Line 12: | Line 12: | ||
* [[Arithmetic Operators|+ - * / ^]] : Arithmetic operators | * [[Arithmetic Operators|+ - * / ^]] : Arithmetic operators | ||
* [[Exponentiation of negative numbers|x^y]] : Exponentiation | * [[Exponentiation of negative numbers|x^y]] : Exponentiation | ||
| − | * [[Comparison Operators|= | + | * [[Comparison Operators|= < > <> <= >=]] : Comparison operators |
* [[Logical operators]]: [[And]], [[Or]], [[Not]] | * [[Logical operators]]: [[And]], [[Or]], [[Not]] | ||
* [[Subscript/Slice Operator| x[I=x], x[@I=x] ]] : Subscript and slice operators | * [[Subscript/Slice Operator| x[I=x], x[@I=x] ]] : Subscript and slice operators | ||
| Line 21: | Line 21: | ||
* [[Repeated Parameter Forwarding|...]] : Repeated parameter forwarding | * [[Repeated Parameter Forwarding|...]] : Repeated parameter forwarding | ||
* [[Index Position Operator::@|Index Position Operator: @I, @[I=x] ]] : Get the numeric position of index elements | * [[Index Position Operator::@|Index Position Operator: @I, @[I=x] ]] : Get the numeric position of index elements | ||
| + | * [[PositionInIndex]] | ||
== Constructs and loops == | == Constructs and loops == | ||
| Line 38: | Line 39: | ||
===Basic math== | ===Basic math== | ||
* [[Abs]] | * [[Abs]] | ||
| + | * [[Sqr]] | ||
| + | * [[Sqrt]] | ||
| + | * [[Round]] | ||
* [[Ceil]] | * [[Ceil]] | ||
| + | * [[Sign]] | ||
| + | * [[Exp]] | ||
| + | * [[Degrees]] | ||
| + | * [[Radians]] | ||
===Trig functions== | ===Trig functions== | ||
| + | * [[Trig Functions| Sin, Cos, Tan]] | ||
| + | * [[Trig Functions| Sinh, Cosh, Tanh]] | ||
* [[ArcCos]] | * [[ArcCos]] | ||
* [[ArcCosH]] | * [[ArcCosH]] | ||
| Line 49: | Line 59: | ||
* [[ArcTan2]] | * [[ArcTan2]] | ||
* [[ArcTanH]] | * [[ArcTanH]] | ||
| + | |||
| + | === Input functions === | ||
| + | |||
| + | * [[Choice| Choice]] | ||
==Probability distributions== | ==Probability distributions== | ||
| + | |||
| + | === Statistical functions === | ||
| + | |||
| + | Return statistics from random samples: | ||
| + | |||
| + | * [[Probability]] | ||
| + | * [[ProbBands]] | ||
| + | * [[RankCorrel]] | ||
| + | * [[SDeviation]] | ||
| + | * [[Variance]] | ||
| + | * [[Skewness]] | ||
| + | * [[Statistics]] | ||
| + | * [[Regression]] | ||
===Custom distribution functions=== | ===Custom distribution functions=== | ||
* [[ChanceDist]] | * [[ChanceDist]] | ||
| + | * [[CumDist]] | ||
| + | * [[ProbDist]] | ||
| + | * [[ProbTable]] | ||
| + | * [[Random]] | ||
===Discrete distribution functions=== | ===Discrete distribution functions=== | ||
| Line 64: | Line 95: | ||
* [[Geometric]] | * [[Geometric]] | ||
* [[HyperGeometric]] | * [[HyperGeometric]] | ||
| + | * [[Permutations]] | ||
===Continuous distribution functions=== | ===Continuous distribution functions=== | ||
| − | * [[ | + | * [[Uniform]] |
* [[Beta]] | * [[Beta]] | ||
* [[Triangular]] | * [[Triangular]] | ||
| + | * [[Poisson]] | ||
| + | * [[Exponential]] | ||
| + | * [[Gamma]] | ||
| + | * [[StudentT]] | ||
| + | * [[Weibull]] | ||
| + | * [[Wilcoxon]] | ||
| + | * [[BesselJ]], [[BesselY]], [[BesselI]], [[BesselK]] | ||
| + | |||
| + | === Modifying distributions === | ||
| + | |||
| + | * [[Sample]] | ||
* [[Truncate]] | * [[Truncate]] | ||
| + | * [[Shuffle]] | ||
| + | |||
| + | === Functions for distributions === | ||
| − | * [[ | + | * [[ProbWilcoxon]] |
* [[Betafn]] | * [[Betafn]] | ||
* [[BetaI]] | * [[BetaI]] | ||
* [[BetaIaInv]] | * [[BetaIaInv]] | ||
* [[BetaIInv]] | * [[BetaIInv]] | ||
| + | * [[ChiSquared]] | ||
| + | * [[CumNormal]] | ||
| + | * [[CumNormalInv]] | ||
| − | * [[ | + | * [[Cdf]] |
| + | * [[Pdf]] | ||
| + | * [[SipDecode]] | ||
| + | * [[SipEncode]] | ||
| − | * [[ | + | |
| − | * [[ | + | === Date and Time === |
| + | |||
| + | * [[Today]] | ||
| + | * [[DateAdd]] | ||
| + | * [[DatePart]] | ||
== Functions that return an Index== | == Functions that return an Index== | ||
| Line 104: | Line 160: | ||
== Array functions == | == Array functions == | ||
| + | |||
| + | * [[Size]] | ||
| + | * [[Reform]] | ||
=== Array-reducing functions == | === Array-reducing functions == | ||
* [[Sum]] | * [[Sum]] | ||
| + | * [[Product]] | ||
* [[Average]] | * [[Average]] | ||
* [[ArgMin_and_ArgMax]] | * [[ArgMin_and_ArgMax]] | ||
| + | * [[Slice]] | ||
| + | * [[Subscript/Slice Operator| Slice Operator: [@I=n] ]] | ||
| + | * [[Functions_Min_and_Max| Condmax]] | ||
| + | * [[Functions_Min_and_Max| Condmin]] | ||
| + | |||
| + | === Array mapping functions === | ||
| + | |||
| + | * [[CumProduct]] | ||
| + | * [[Rank]] | ||
| + | * [[Uncumulate]] | ||
| + | |||
=== Tables and functions to make arrays === | === Tables and functions to make arrays === | ||
* [[Array]] | * [[Array]] | ||
| + | * [[Table]] | ||
* [[DetermTable]] | * [[DetermTable]] | ||
| + | * [[SubTable]] | ||
* [[AddIndex]] | * [[AddIndex]] | ||
| Line 120: | Line 193: | ||
* [[AnalyticaLicenseInfo]] | * [[AnalyticaLicenseInfo]] | ||
| + | === Interpolation functions === | ||
| + | |||
| + | * [[StepInterp]] | ||
| + | * [[CubicInterp]] | ||
| + | |||
| + | === Other array functions === | ||
* [[Area]] | * [[Area]] | ||
| + | * [[Sort]] | ||
| + | * [[SortIndex]] | ||
| + | * [[Split]] | ||
| + | * [[SubIndex]] | ||
| + | * [[Subset]] | ||
| + | * [[Unique]] | ||
| + | |||
| + | == Financial functions == | ||
| − | * [[ | + | * [[Rate]] |
| + | * [[Pmt]] | ||
| + | * [[Pv]] | ||
| + | * [[CumIPmt]] | ||
| + | * [[PPmt]] | ||
| + | * [[XIrr]] | ||
| + | * [[XNpv]] | ||
== User interaction and dialog functions == | == User interaction and dialog functions == | ||
| Line 134: | Line 227: | ||
* [[ShowProgressBar]] | * [[ShowProgressBar]] | ||
| − | == | + | == Types and type conversion functions == |
* [[Chr]] | * [[Chr]] | ||
| Line 140: | Line 233: | ||
* [[ParseDate]] | * [[ParseDate]] | ||
* [[ParseNumber]] | * [[ParseNumber]] | ||
| + | * [[Asc]] | ||
| + | * [[Data_Type_Functions#Function_TypeOf| TypeOf]] | ||
| + | |||
| + | == Integration with other applications == | ||
| + | |||
| + | [[RunConsoleProcess]] | ||
| + | |||
| + | === Reading data == | ||
| + | |||
| + | * [[ReadFromUrl]] | ||
| + | * [[ReadImageFile]] | ||
| + | * [[ReadTextFile]] | ||
* [[ShowPdfFile]] | * [[ShowPdfFile]] | ||
| + | * [[WriteTextFile]] | ||
== Spreadsheet functions == | == Spreadsheet functions == | ||
| Line 152: | Line 258: | ||
* [[SpreadsheetSetRange]] | * [[SpreadsheetSetRange]] | ||
| − | == | + | === Database functions === |
| − | |||
| − | |||
| − | |||
| − | * [[ | + | * [[SqlDriverInfo]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * [[ | + | * [[AttribGet]] |
| − | |||
| − | |||
| + | * [[Boolean]] | ||
| + | * [[ReThrow]] | ||
| + | * [[Try]] | ||
| + | == Complex number functions == | ||
| + | * [[RealPart]] | ||
| + | * [[ComplexDegrees]] | ||
| + | * [[ComplexRadians]] | ||
== COM functions == | == COM functions == | ||
| Line 197: | Line 282: | ||
* [[COMCreateObject]] | * [[COMCreateObject]] | ||
* [[COMGetProperty]] | * [[COMGetProperty]] | ||
| − | |||
| − | + | ||
| − | |||
* [[CompressMemoryUsedBy]] | * [[CompressMemoryUsedBy]] | ||
* [[ComputedBy]] | * [[ComputedBy]] | ||
| Line 207: | Line 290: | ||
* [[ConcatN|Concat<N>]] (Concatenation UDFs.ana | * [[ConcatN|Concat<N>]] (Concatenation UDFs.ana | ||
* [[ConcatRows]] (Concatenation UDFs.ana) | * [[ConcatRows]] (Concatenation UDFs.ana) | ||
| − | + | ||
| − | |||
* [[Continuous]] | * [[Continuous]] | ||
* [[CopyIndex]] | * [[CopyIndex]] | ||
| Line 216: | Line 298: | ||
* [[Trig Functions| Cos]] | * [[Trig Functions| Cos]] | ||
* [[Trig Functions| Cosh]] | * [[Trig Functions| Cosh]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[CumPrinc]] | * [[CumPrinc]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[CumWilcoxon]] | * [[CumWilcoxon]] | ||
* [[CumWilcoxonInv]] | * [[CumWilcoxonInv]] | ||
* [[Cumulate]] | * [[Cumulate]] | ||
| − | + | ||
| − | |||
| − | |||
| − | |||
* [[CurrentDataDirectory]] (''Replaced with [[CurrentDataFolder]] as of [[Analytica 4.6]]'') | * [[CurrentDataDirectory]] (''Replaced with [[CurrentDataFolder]] as of [[Analytica 4.6]]'') | ||
| Line 259: | Line 309: | ||
* [[CurrentDataFolder]] | * [[CurrentDataFolder]] | ||
* [[CurrentModelFolder]] | * [[CurrentModelFolder]] | ||
| − | + | ||
| − | |||
== Database functions == | == Database functions == | ||
| Line 270: | Line 319: | ||
== Matrix functions == | == Matrix functions == | ||
| + | |||
| + | * [[DotProduct]] | ||
| + | * [[EigenDecomp]] | ||
* [[Decompose]] | * [[Decompose]] | ||
| − | |||
* [[Determinant]] | * [[Determinant]] | ||
* [[Transpose]] | * [[Transpose]] | ||
| + | * [[SingularValueDecomp]] | ||
== Set functions == | == Set functions == | ||
| Line 282: | Line 334: | ||
* [[SetUnion]] | * [[SetUnion]] | ||
| + | |||
| + | * [[Discrete]] | ||
| + | * [[Dispatch]] | ||
| + | * [[Dereference Operator::#|Dereference Operator: #R]] : Return the value pointed to by a reference R. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
=== Sensitivity analysis === | === Sensitivity analysis === | ||
| Line 327: | Line 351: | ||
=== Special functions === | === Special functions === | ||
| + | * [[Dynamic]] | ||
* [[Evaluate]] | * [[Evaluate]] | ||
* [[EvaluateScript]] | * [[EvaluateScript]] | ||
| Line 332: | Line 357: | ||
* [[Erf]] | * [[Erf]] | ||
* [[ErfInv]] | * [[ErfInv]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
* [[Factorial]] | * [[Factorial]] | ||
Revision as of 05:42, 31 July 2015
Function list (to be categorized) (Back to Analytica Reference)
See also: functions by category. Functions to be organized Rare and deprecated functions
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
- Using..Do
- Var..Do
- If0
- Ifpos
Mathematics
=Basic math
=Trig functions
Input functions
Probability distributions
Statistical functions
Return statistics from random samples:
Custom distribution functions
Discrete distribution functions
Continuous distribution functions
- Uniform
- Beta
- Triangular
- Poisson
- Exponential
- Gamma
- StudentT
- Weibull
- Wilcoxon
- BesselJ, BesselY, BesselI, BesselK
Modifying distributions
Functions for distributions
Date and Time
Functions that return an Index
Text functions
- JoinText
- FindInText
- SelectText
- TextReplace
- SplitText
- Text Concatenation Operator: A&B : Concatenate two text strings
- TextLength
- TextLowerCase
- TextUpperCase
- TextSentenceCase
- TextTrim
Array functions
= Array-reducing functions
Array mapping functions
Tables and functions to make arrays
Interpolation functions
Other array functions
Financial functions
User interaction and dialog functions
Types and type conversion functions
- Chr
- Coerce_to_Numeric (Flat file library.ana)
- ParseDate
- ParseNumber
- Asc
- TypeOf
Integration with other applications
RunConsoleProcess
= Reading data
Spreadsheet functions
- SpreadsheetCell
- SpreadsheetInfo
- SpreadsheetOpen
- SpreadsheetRange
- SpreadsheetSave
- SpreadsheetSetCell
- SpreadsheetSetInfo
- SpreadsheetSetRange
Database functions
Complex number functions
COM functions
- CompressMemoryUsedBy
- ComputedBy
- COMPutProperty
- Concat
- Concat<N> (Concatenation UDFs.ana
- ConcatRows (Concatenation UDFs.ana)
- Continuous
- CopyIndex
- Correlate_Dists (Multivariate Distributions.ana)
- Correlate_With (Multivariate Distributions.ana)
- Correlation
- Cos
- Cosh
- CurrentDataDirectory (Replaced with CurrentDataFolder as of Analytica 4.6)
- CurrentModelDirector (Replaced with CurrentDataFolder as of Analytica 4.6)
- CurrentDataFolder
- CurrentModelFolder
Database functions
Matrix functions
Set functions
- Discrete
- Dispatch
- Dereference Operator: #R : Return the value pointed to by a reference R.
Sensitivity analysis
Special functions
- Gamma_m_sd (Distribution Variations.ana)
- GammaFn
- GammaI
- GammaIInv
- Gaussian (Multivariate Distributions.ana)
- GCD (GCD function library.ana)
- GetEvaluationContext
- GetFract
- GetProcessInfo
- GetRegistryValue
- GetVariableByName
- GoalSeek (Optimization Functions.ana)
- Gradient (Optimization Functions.ana)
- GroupedInteger
- IgnoreWarnings
- Im (Complex Library.ana)
- ImPart
- Implied_volatility_c (Financial library.ana)
- Implied_volatility_p (Financial library.ana)
- 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
- IsDateTime
- IsHandle
- IsNaN
- IsNotSpecified
- IsNull
- IsNumber
- IsRealNumber
- IsReference
- IsResultComputed
- IsText
- IsUndef
- Iterate
- Join
- 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)
- MultiTable
- MultiUniform (Multivariate Distributions.ana)
- NegBinomial (Distribution Variations.ana)
- NegativeBinomial
- 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
- NPer
- Npv
- NumberToText
- OpenExcelFile -- depreciated: use SpreadsheetOpen
- OpenURL
Optimizer functions
Comments
Enable comment auto-refresher