Difference between revisions of "Functions by category"
m (→= Reading data) |
|||
| Line 244: | Line 244: | ||
* [[WriteTextFile]] | * [[WriteTextFile]] | ||
| − | == Spreadsheet | + | == Spreadsheet access == |
* [[SpreadsheetCell]] | * [[SpreadsheetCell]] | ||
* [[SpreadsheetInfo]] | * [[SpreadsheetInfo]] | ||
| Line 254: | Line 254: | ||
* [[SpreadsheetSetRange]] | * [[SpreadsheetSetRange]] | ||
| − | === Database | + | === Database and ODBC access === |
* [[SqlDriverInfo]] | * [[SqlDriverInfo]] | ||
| − | |||
| − | |||
* [[AttribGet]] | * [[AttribGet]] | ||
| Line 265: | Line 263: | ||
* [[Boolean]] | * [[Boolean]] | ||
| + | === Error handling === | ||
| + | |||
| + | * [[Error]] | ||
* [[ReThrow]] | * [[ReThrow]] | ||
* [[Try]] | * [[Try]] | ||
Revision as of 16:55, 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
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 access
- SpreadsheetCell
- SpreadsheetInfo
- SpreadsheetOpen
- SpreadsheetRange
- SpreadsheetSave
- SpreadsheetSetCell
- SpreadsheetSetInfo
- SpreadsheetSetRange
Database and ODBC access
Error handling
Complex number functions
COM functions
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