Difference between revisions of "Functions by category"
m |
m |
||
| Line 36: | Line 36: | ||
* [[Using..Do]] | * [[Using..Do]] | ||
* [[Var..Do]] | * [[Var..Do]] | ||
| − | + | * [[Index..Do]] | |
==Mathematics== | ==Mathematics== | ||
=== Basic math === | === Basic math === | ||
| − | * [[Abs]], [[Sign]], [[Round]], [[Ceil]], [[Floor]] | + | * [[Abs]], [[Sign]], [[Mod]], [[Round]], [[Ceil]], [[Floor]] |
| − | |||
* [[Sqr]], [[Sqrt]], [[Exp]], [[Ln]], [[LogTen]] | * [[Sqr]], [[Sqrt]], [[Exp]], [[Ln]], [[LogTen]] | ||
| − | |||
* [[Factorial]] | * [[Factorial]] | ||
| − | |||
* [[Degrees]], [[Radians]] | * [[Degrees]], [[Radians]] | ||
| Line 53: | Line 50: | ||
* [[Trig Functions| Sin, Cos, Tan]] | * [[Trig Functions| Sin, Cos, Tan]] | ||
* [[Trig Functions| Sinh, Cosh, Tanh]] | * [[Trig Functions| Sinh, Cosh, Tanh]] | ||
| − | * [[ArcCos]] | + | * [[ArcSin]], [[ArcCos]], [[ArcTan]], [[ArcTan2]] |
| − | * [[ArcCosH]] | + | * [[ArcSinH]], [[ArcCosH]], [[ArcTanH]] |
| − | + | ||
| − | * [[ | + | === Complex numbers === |
| − | + | ||
| − | * [[ | + | * [[RealPart]], [[ImPart]] |
| − | + | * [[ComplexDegrees]], [[ComplexRadians]] | |
==Probability distributions== | ==Probability distributions== | ||
| Line 67: | Line 64: | ||
Return statistics from random samples: | Return statistics from random samples: | ||
| − | * [[Mean]], [[SDeviation]], [[Variance]], [[Skewness]], [[Kurtosis]] | + | * [[Median]], [[Mean]], [[SDeviation]], [[Variance]], [[Skewness]], [[Kurtosis]] |
* [[Statistics]] | * [[Statistics]] | ||
* [[Probability]] | * [[Probability]] | ||
* [[GetFract]], [[ProbBands]] | * [[GetFract]], [[ProbBands]] | ||
| − | * [[RankCorrel]] | + | * [[Correlation]], [[RankCorrel]] |
| + | * [[Cdf]], [[Pdf]] | ||
* [[Regression]] | * [[Regression]] | ||
===Custom distribution functions=== | ===Custom distribution functions=== | ||
| − | * [[ | + | * [[CumDist]], [[Fractiles]] |
| − | + | * [[ChanceDist]], [[ProbDist]], [[ProbTable]] | |
| − | * [[ | ||
| − | |||
| − | |||
* [[Random]] | * [[Random]] | ||
| Line 86: | Line 81: | ||
* [[Bernoulli]], [[Binomial]], [[NegativeBinomial]] | * [[Bernoulli]], [[Binomial]], [[NegativeBinomial]] | ||
| − | * [[Combinations]] | + | * [[Combinations]], [[Permutations]] |
| − | + | * [[Geometric]], [[HyperGeometric]] | |
| − | * [[ | ||
| − | |||
* [[Certain]] | * [[Certain]] | ||
===Continuous distribution functions=== | ===Continuous distribution functions=== | ||
| − | * [[Uniform]], [[Normal]], [[Beta]], [[Triangular]], [[Poisson]] | + | * [[Uniform]], [[Normal]], [[LogNormal]], [[Beta]], [[Triangular]], [[Poisson]] |
| − | * [[Exponential]], [[Gamma]], [[StudentT]], [[Weibull]], [[Wilcoxon]] | + | * [[Exponential]], [[Gamma]], [[StudentT]], [[Weibull]], [[Wilcoxon]], [[Logistic]] |
| − | * [[BesselJ]], [[BesselY]], [[BesselI]], [[BesselK]] | + | * [[BesselJ]], [[BesselY]], [[BesselI]], [[BesselK]], [[ChiSquared]] |
=== Modifying distributions === | === Modifying distributions === | ||
| − | * [[Sample]] | + | * [[Mid]], [[Sample]], [[Truncate]], [[Shuffle]] |
| − | |||
| − | |||
=== Functions for distributions === | === Functions for distributions === | ||
| Line 111: | Line 102: | ||
* [[BetaIaInv]] | * [[BetaIaInv]] | ||
* [[BetaIInv]] | * [[BetaIInv]] | ||
| − | + | ||
* [[CumNormal]] | * [[CumNormal]] | ||
* [[CumNormalInv]] | * [[CumNormalInv]] | ||
| − | + | === SIP and SLURP === | |
| − | + | ||
| − | * [[SipDecode]] | + | * [[SipDecode]], [[SipEncode]] |
| − | |||
| Line 136: | Line 126: | ||
== Make an Index== | == Make an Index== | ||
| − | * [[Sequence]] | + | * [[Sequence]], [[Sequence Operator|Sequence Operator: first..last]] |
| − | + | * [[SortIndex]], [[Split]], [[SubIndex]], [[Subset]], [[Unique]] | |
| − | * [[SortIndex]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
* [[Size]] | * [[Size]] | ||
| Line 149: | Line 134: | ||
=== Array reducing == | === Array reducing == | ||
| − | * [[Sum]] | + | * [[Sum]], [[Product]], [[Average]] |
| − | + | * [[Functions_Min_and_Max| Max]] [[Functions_Min_and_Max| Min]] | |
| − | * [[ | ||
* [[ArgMin_and_ArgMax]] | * [[ArgMin_and_ArgMax]] | ||
| − | * [[ | + | * [[Functions_Min_and_Max| Condmax]], [[Functions_Min_and_Max| Condmin]] |
| − | + | * [[Integrate]], [[Area]] | |
| − | * [[ | ||
| − | |||
=== Subscript, selection, lookup === | === Subscript, selection, lookup === | ||
* [[Slice]], [[Subscript]], [[StepInterp]] | * [[Slice]], [[Subscript]], [[StepInterp]] | ||
| + | * [[Subscript/Slice Operator| Slice Operator: [@I=n] ]] | ||
=== Array mapping === | === Array mapping === | ||
| − | * [[Cumulate]], [[Uncumulate]], [[CumProduct]] | + | * [[Cumulate]], [[Uncumulate]], [[CumProduct]], [[Normalize]] |
* [[Rank]] | * [[Rank]] | ||
| − | |||
=== Tables and functions to make arrays === | === Tables and functions to make arrays === | ||
* [[Array]] | * [[Array]] | ||
| − | * [[Table]], [[SubTable]], [[MultiTable]] | + | * [[Table]], [[SubTable]], [[MultiTable]], [[DetermTable]], [[ProbTable]] |
| − | |||
* [[AddIndex]] | * [[AddIndex]] | ||
* [[Aggregate]] | * [[Aggregate]] | ||
| Line 178: | Line 159: | ||
=== Interpolation === | === Interpolation === | ||
| − | * [[StepInterp]], [[LinearInterp]], [[CubicInterp]] | + | * [[StepInterp]], [[LinearInterp]], [[CubicInterp]], [[MonoCubicInterp]] |
=== Matrix === | === Matrix === | ||
| − | * [[DotProduct]], [[MatrixMultiply]], [[Transpose]] | + | * [[DotProduct]], [[MatrixMultiply]], [[Transpose]], [[Invert]], [[Determinant]], [[Decompose]], [[EigenDecomp]], [[SingularValueDecomp]] |
| − | |||
=== Other array functions === | === Other array functions === | ||
| − | + | ||
* [[Sort]] | * [[Sort]] | ||
* [[SortIndex]] | * [[SortIndex]] | ||
| Line 194: | Line 174: | ||
* [[Subset]] | * [[Subset]] | ||
* [[Unique]] | * [[Unique]] | ||
| + | |||
| + | * [[MdArrayToTable]] | ||
| + | * [[MdTable]] | ||
== Financial == | == Financial == | ||
| Line 210: | Line 193: | ||
=== User dialog boxes === | === User dialog boxes === | ||
| − | * [[ | + | * [[MsgBox]], [[Error]] |
| + | * [[AskMsgText]], [[AskMsgChoice]], [[AskMsgNumber]] | ||
* [[ShowProgressBar]] | * [[ShowProgressBar]] | ||
| Line 232: | Line 216: | ||
== Integration with other applications == | == Integration with other applications == | ||
| + | |||
| + | * [[RunConsoleProcess]] | ||
=== Reading data === | === Reading data === | ||
| − | * [[ReadFromUrl]] | + | * [[ReadFromUrl]], [[OpenURL]] |
* [[ReadImageFile]] | * [[ReadImageFile]] | ||
* [[ReadTextFile]] | * [[ReadTextFile]] | ||
| Line 242: | Line 228: | ||
=== Spreadsheet access === | === Spreadsheet access === | ||
| − | * [[ | + | |
| − | + | * [[SpreadsheetOpen]], [[SpreadsheetSave]] | |
| − | * [[ | + | * [[SpreadsheetCell]], [[SpreadsheetRange]] |
| − | + | * [[SpreadsheetSetCell]], [[SpreadsheetSetRange]] | |
| − | * [[ | + | * [[SpreadsheetInfo]], [[SpreadsheetSetInfo]] |
| − | + | ||
| − | * [[ | ||
| − | |||
* [[OpenExcelFile]] -- depreciated: use [[SpreadsheetOpen]] | * [[OpenExcelFile]] -- depreciated: use [[SpreadsheetOpen]] | ||
| Line 261: | Line 245: | ||
* [[DbTablenames]] | * [[DbTablenames]] | ||
* [[DbWrite]] | * [[DbWrite]] | ||
| − | + | * [[MdxQuery]] | |
| − | * [[ | ||
| − | |||
| − | |||
| − | |||
=== COM API === | === COM API === | ||
| Line 279: | Line 259: | ||
* [[IgnoreWarnings]] | * [[IgnoreWarnings]] | ||
* [[Try]], [[ReThrow]] | * [[Try]], [[ReThrow]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Set functions == | == Set functions == | ||
| Line 303: | Line 278: | ||
* [[VarTerm Functions#Function_GetVariableByName| GetVariableByName]] | * [[VarTerm Functions#Function_GetVariableByName| GetVariableByName]] | ||
* [[IndexValue]] | * [[IndexValue]] | ||
| + | * [[AttribGet]] | ||
=== User modifiable attributes === | === User modifiable attributes === | ||
| Line 323: | Line 299: | ||
=== Evaluation === | === Evaluation === | ||
| + | * [[Mid]], [[Sample]] | ||
* [[Evaluate]] | * [[Evaluate]] | ||
* [[EvaluateScript]] | * [[EvaluateScript]] | ||
* [[GetEvaluationContext]] | * [[GetEvaluationContext]] | ||
| − | === Analytica information === | + | === Analytica environment information === |
* [[AnalyticaLicenseInfo]], [[GetProcessInfo]] | * [[AnalyticaLicenseInfo]], [[GetProcessInfo]] | ||
| − | |||
* [[GetRegistryValue]] | * [[GetRegistryValue]] | ||
| − | + | * [[MemoryInUseBy]] | |
== Function parameter qualifiers == | == Function parameter qualifiers == | ||
| − | * [[Boolean]] | + | * [[Boolean]], [[Integer]] |
== Functions still to be categorized == | == Functions still to be categorized == | ||
| Line 343: | Line 319: | ||
* [[FFT]] | * [[FFT]] | ||
* [[FFTInv]] | * [[FFTInv]] | ||
| − | |||
| − | |||
| − | |||
* [[Frequency]] | * [[Frequency]] | ||
* [[FunctionOf]] | * [[FunctionOf]] | ||
| + | * [[Iterate]] | ||
| + | * [[FindPolynomialZeroes]] | ||
| + | * [[Join]] | ||
| + | * [[Index..Do]] | ||
* [[Gamma_m_sd|Gamma_m_sd]] (Distribution Variations.ana) | * [[Gamma_m_sd|Gamma_m_sd]] (Distribution Variations.ana) | ||
| Line 356: | Line 333: | ||
* [[Gaussian]] (Multivariate Distributions.ana) | * [[Gaussian]] (Multivariate Distributions.ana) | ||
* [[GCD]] ([[media:GCD function library.ana|GCD function library.ana]]) | * [[GCD]] ([[media:GCD function library.ana|GCD function library.ana]]) | ||
| − | |||
* [[GoalSeek]] (Optimization Functions.ana) | * [[GoalSeek]] (Optimization Functions.ana) | ||
* [[Gradient]] (Optimization Functions.ana) | * [[Gradient]] (Optimization Functions.ana) | ||
| Line 365: | Line 341: | ||
* [[Implied_volatility_p]] (Financial library.ana) | * [[Implied_volatility_p]] (Financial library.ana) | ||
| − | * [[ | + | * [[InsertRecSql]] (ODBC Library.ana) |
| − | |||
| − | |||
| − | |||
* [[InverseGaussian]] (Distribution Variations.ana) | * [[InverseGaussian]] (Distribution Variations.ana) | ||
| − | |||
* [[InvertedWishart]] (Distribution Variations.ana) | * [[InvertedWishart]] (Distribution Variations.ana) | ||
* [[InvLogit]] (Generalized Regression.ana) | * [[InvLogit]] (Generalized Regression.ana) | ||
| − | |||
| − | |||
| − | |||
* [[LDens_InvertedWishart]] (Distribution Densities.ana) | * [[LDens_InvertedWishart]] (Distribution Densities.ana) | ||
* [[LDens_Wishart]] (Distribution Densities.ana) | * [[LDens_Wishart]] (Distribution Densities.ana) | ||
* [[LGamma]] | * [[LGamma]] | ||
| − | |||
* [[LL_First]] (Linked List Library.ana) | * [[LL_First]] (Linked List Library.ana) | ||
| Line 392: | Line 360: | ||
* [[Local Index Operator::A.I]] : Get an index (usually a local index) of an array | * [[Local Index Operator::A.I]] : Get an index (usually a local index) of an array | ||
| − | |||
* [[Logistic_Regression]] (Generalized Regression.ana) | * [[Logistic_Regression]] (Generalized Regression.ana) | ||
* [[Logit]] (Generalized Regression.ana) | * [[Logit]] (Generalized Regression.ana) | ||
| − | |||
* [[Lognormal_m_sd]] (Distribution variations.ana) - obsolete, use [[LogNormal]] (mean:m,stddev:sd) | * [[Lognormal_m_sd]] (Distribution variations.ana) - obsolete, use [[LogNormal]] (mean:m,stddev:sd) | ||
| Line 401: | Line 367: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[Multinomial]] (Multivariate Distributions.ana) | * [[Multinomial]] (Multivariate Distributions.ana) | ||
* [[MultiNormal]] (Multivariate Distributions.ana) | * [[MultiNormal]] (Multivariate Distributions.ana) | ||
| Line 423: | Line 376: | ||
* [[NegBinomial]] (Distribution Variations.ana) | * [[NegBinomial]] (Distribution Variations.ana) | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Optimizer functions == | == Optimizer functions == | ||
Revision as of 18:25, 19 August 2015
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 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, For..Do
- If0, Ifpos
Declarations of local variables
Mathematics
Basic math
=Trigonometry
Complex numbers
Probability distributions
Statistics
Return statistics from random samples:
- Median, Mean, SDeviation, Variance, Skewness, Kurtosis
- Statistics
- Probability
- GetFract, ProbBands
- Correlation, RankCorrel
- Cdf, Pdf
- Regression
Custom distribution functions
Discrete distribution functions
Continuous distribution functions
- Uniform, Normal, LogNormal, Beta, Triangular, Poisson
- Exponential, Gamma, StudentT, Weibull, Wilcoxon, Logistic
- BesselJ, BesselY, BesselI, BesselK, ChiSquared
Modifying distributions
Functions for distributions
SIP and SLURP
Text functions
- SelectText, FindInText, TextReplace
- SplitText, JoinText
- Text Concatenation Operator: A&B : Concatenate two text strings
- TextLength
- TextLowerCase, TextUpperCase, TextSentenceCase
- TextTrim
Array functions
Make an Index
= Array reducing
Subscript, selection, lookup
Array mapping
Tables and functions to make arrays
Interpolation
Matrix
- DotProduct, MatrixMultiply, Transpose, Invert, Determinant, Decompose, EigenDecomp, SingularValueDecomp
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
Obsolete optimizer
Comments
Enable comment auto-refresher