Difference between revisions of "Functions by category"
m |
|||
| Line 46: | Line 46: | ||
* [[Degrees]], [[Radians]] | * [[Degrees]], [[Radians]] | ||
| − | ===Trigonometry == | + | ===Trigonometry === |
* [[Trig Functions| Sin, Cos, Tan]] | * [[Trig Functions| Sin, Cos, Tan]] | ||
| Line 57: | Line 57: | ||
* [[RealPart]], [[ImPart]] | * [[RealPart]], [[ImPart]] | ||
* [[ComplexDegrees]], [[ComplexRadians]] | * [[ComplexDegrees]], [[ComplexRadians]] | ||
| + | * [[Conj]] | ||
==Probability distributions== | ==Probability distributions== | ||
| Line 97: | Line 98: | ||
=== Functions for distributions === | === Functions for distributions === | ||
| − | * [[ProbWilcoxon]] | + | * [[ProbWilcoxon]], [[CumWilcoxon]], [[CumWilcoxonInv]] |
| − | + | * [[BetaI]], [[BetaIInv]] | |
| − | * [[BetaI]] | + | * [[GammaI]], [[GammaIInv]] |
| − | * [[ | + | * [[CumNormal]], [[CumNormalInv]] |
| − | |||
| − | |||
| − | * [[CumNormal]] | ||
| − | |||
=== SIP and SLURP === | === SIP and SLURP === | ||
| Line 127: | Line 124: | ||
* [[Sequence]], [[Sequence Operator|Sequence Operator: first..last]] | * [[Sequence]], [[Sequence Operator|Sequence Operator: first..last]] | ||
| − | * [[SortIndex]], [[ | + | * [[SortIndex]], [[SplitText]], [[SubIndex]], [[Subset]], [[Unique]] |
| − | |||
| − | |||
| − | |||
| − | === Array reducing == | + | === Array reducing === |
* [[Sum]], [[Product]], [[Average]] | * [[Sum]], [[Product]], [[Average]] | ||
* [[Functions_Min_and_Max| Max]] [[Functions_Min_and_Max| Min]] | * [[Functions_Min_and_Max| Max]] [[Functions_Min_and_Max| Min]] | ||
* [[ArgMin_and_ArgMax]] | * [[ArgMin_and_ArgMax]] | ||
| + | * [[JoinText]] | ||
* [[Functions_Min_and_Max| Condmax]], [[Functions_Min_and_Max| Condmin]] | * [[Functions_Min_and_Max| Condmax]], [[Functions_Min_and_Max| Condmin]] | ||
| − | * | + | * [[Area]] |
=== Subscript, selection, lookup === | === Subscript, selection, lookup === | ||
| Line 147: | Line 142: | ||
=== Array mapping === | === Array mapping === | ||
| − | * [[Cumulate]], [[Uncumulate]], [[CumProduct]], [[Normalize]] | + | * [[Cumulate]], [[Uncumulate]], [[CumProduct]], [[Normalize]], [[Integrate]] |
| − | * [[Rank]] | + | * [[Rank]], [[Sort]] |
| + | * [[Aggregate]] | ||
=== Tables and functions to make arrays === | === Tables and functions to make arrays === | ||
| Line 155: | Line 151: | ||
* [[Table]], [[SubTable]], [[MultiTable]], [[DetermTable]], [[ProbTable]] | * [[Table]], [[SubTable]], [[MultiTable]], [[DetermTable]], [[ProbTable]] | ||
* [[AddIndex]] | * [[AddIndex]] | ||
| − | + | ||
=== Interpolation === | === Interpolation === | ||
| Line 163: | Line 159: | ||
=== Matrix === | === Matrix === | ||
| − | * | + | * [[MatrixMultiply]], [[Transpose]], [[Invert]], [[Determinant]], [[Decompose]], [[EigenDecomp]], [[SingularValueDecomp]] |
| + | |||
| + | === Information about arrays === | ||
| + | |||
| + | * [[Size]] | ||
| + | * [[IndexesOf]], [[IndexNames]] | ||
| + | * [[MemoryInUseBy]] | ||
| + | |||
| + | === Relational transformations === | ||
| + | |||
| + | * [[MdTable]], [[MdArrayToTable]] | ||
| + | * [[Aggregate]] | ||
=== Other array functions === | === Other array functions === | ||
| − | |||
| − | |||
* [[SortIndex]] | * [[SortIndex]] | ||
* [[Split]] | * [[Split]] | ||
Revision as of 19: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
Information about arrays
Relational transformations
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