Difference between revisions of "Functions by category"

Line 71: Line 71:
 
* [[Aggregate]]
 
* [[Aggregate]]
 
'''Other array functions'''
 
'''Other array functions'''
−
* [[SortIndex]]
+
 
−
* [[Split]]
+
'''Functions that make indexes:''' [[SortIndex]], [[Split]], [[SubIndex]], [[Subset]], [[Unique]]
−
* [[SubIndex]]
 
−
* [[Subset]]
 
−
* [[Unique]]
 
  
 
== Financial ==
 
== Financial ==
  
−
* [[Pv]], [[Fv]], [[Npv]], [[XNpv]]
+
* [[Pv]], [[Fv]], [[Npv]], [[XNpv]], [[Rate]], [[NPer]], [[Pmt]], [[PPmt]], [[IPmt]], [[CumIPmt]], [[Irr]], [[XIrr]]
−
* [[Rate]], [[NPer]]
 
−
* [[Pmt]], [[PPmt]], [[IPmt]], [[CumIPmt]]
 
−
* [[Irr]], [[XIrr]]
 
  
 
== User interaction and dialog ==
 
== User interaction and dialog ==
 +
'''User input:''' [[Choice| Choice]], [[Checkbox]]
  
−
=== User input ===
+
D'''ialog boxes: '''[[MsgBox]], [[Error]], [[AskMsgText]], [[AskMsgChoice]], [[AskMsgNumber]], [[ShowProgressBar]]
−
 
 
−
* [[Choice| Choice]], [[Checkbox]]
 
−
 
 
−
=== User dialog boxes ===
 
−
 
 
−
* [[MsgBox]], [[Error]]
 
−
* [[AskMsgText]], [[AskMsgChoice]], [[AskMsgNumber]]
 
−
* [[ShowProgressBar]]
 
  
 
== Types and type conversion ==
 
== Types and type conversion ==
Line 101: Line 88:
 
* [[NumberToText]], [[Coerce_to_Numeric]]    (Flat file library.ana)
 
* [[NumberToText]], [[Coerce_to_Numeric]]    (Flat file library.ana)
 
* [[ParseDate]], [[ParseNumber]]
 
* [[ParseDate]], [[ParseNumber]]
−
* [[Data_Type_Functions#Function_TypeOf| TypeOf]]
+
*  
−
* [[IsDateTime]]
+
'''Get or test type:''' [[Data_Type_Functions#Function_TypeOf| TypeOf]], [[IsDateTime]], [[IsHandle]], [[Data_Type_Functions#Function_IsNaN| IsNaN]]
−
* [[IsHandle]]
 
−
* [[Data_Type_Functions#Function_IsNaN| IsNaN]]
 
 
* [[Data_Type_Functions#Function_IsNotSpecified| IsNotSpecified]]
 
* [[Data_Type_Functions#Function_IsNotSpecified| IsNotSpecified]]
 
* [[IsNull]]
 
* [[IsNull]]
Line 111: Line 96:
 
* [[Data_Type_Functions#Function_IsReference| IsReference]]
 
* [[Data_Type_Functions#Function_IsReference| IsReference]]
 
* [[IsResultComputed]]
 
* [[IsResultComputed]]
−
* [[Data_Type_Functions#Function_IsText| IsText]]
+
* [[Data_Type_Functions#Function_IsText| IsText]], [[Data_Type_Functions#Function_IsUndef| IsUndef]]
−
* [[Data_Type_Functions#Function_IsUndef| IsUndef]]
 
  
 
== Integration with other applications ==
 
== Integration with other applications ==

Revision as of 22:55, 30 October 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: + - * / ^ Comparison: = < > <> <= >= Logical: And, Or, Not; Text concatenation: &; Subscript and slice: x[I=x], x[@I=x] :Assignment: :=, Reference: \, Dereference: #,

Conditional constructs: If-Then-Else, Ifall-Then-Else, Ifonly-Then-Else, If0, Ifpos

Loops: While..Do, For..Do

Grouped expressions: (expr; expr), BEGIN expr; expr END

Comments: { commented text }

Declaring local variables: Using x DO; Var x; Index i; MetaVar v; MetaIndex i; Alias a

Mathematics

Basic math: Abs, Sign, Mod, Round, Ceil, Floor, Sqr, Sqrt, Exp, Ln, LogTen, Factorial, Degrees, Radians

Trigonometry: Sin, Cos, Tan; Sinh, Cosh, Tanh; ArcSin, ArcCos, ArcTan, ArcTan2; ArcSinH, ArcCosH, ArcTanH

Complex numbers: RealPart, ImPart, ComplexDegrees, ComplexRadians, Conj

Statistics and Probability distributions

Statistics: Median, Mean, SDeviation, Variance, Skewness, Kurtosis, Statistics, Probability, GetFract, ProbBands

Custom distributions: CumDist, Fractiles, ChanceDist, ProbDist, ProbTable, Random

Discrete distributions: Bernoulli, Binomial, NegativeBinomial, Combinations, Permutations, Geometric, HyperGeometric, Certain

Continuous distribution functions: Uniform, Normal, LogNormal, Beta, Triangular, Poisson, Exponential, Gamma, StudentT, Weibull, Wilcoxon, Logistic, BesselJ, BesselY, BesselI, BesselK, ChiSquared

Modifying distributions: Mid, Sample, Truncate, Shuffle

Functions for distributions: ProbWilcoxon, CumWilcoxon, CumWilcoxonInv, BetaI, BetaIInv, GammaI, GammaIInv, CumNormal, CumNormalInv

SIPs and SLURPs: SipDecode, SipEncode

Date and Time: Today, MakeDate, DateAdd, DatePart

Text functions: SelectText, FindInText, TextReplace, SplitText, JoinText, Text Concatenation: t1&t2 TextLength, TextLowerCase, TextUpperCase, TextSentenceCase, TextTrim

Array functions

Make an Index: Sequence, Sequence Operator: first..last, SortIndex, SplitText, SubIndex, Subset, Unique

Array reducing: Sum, Product, Average, Max Min, ArgMin_and_ArgMax, JoinText, Condmax, Condmin, Area

Subscript, selection, lookup: Slice, Subscript, StepInterp, Slice Operator: [@I=n]

Array mapping:

Tables and functions to make arrays: Array, Table, SubTable, MultiTable, DetermTable, ProbTable

Interpolation: StepInterp, LinearInterp, CubicInterp, MonoCubicInterp

Matrix

Information about arrays: Size, IndexesOf, IndexNames, MemoryInUseBy

Relational tables:

Other array functions

Functions that make indexes: SortIndex, Split, SubIndex, Subset, Unique

Financial

User interaction and dialog

User input: Choice, Checkbox

Dialog boxes: MsgBox, Error, AskMsgText, AskMsgChoice, AskMsgNumber, ShowProgressBar

Types and type conversion

Get or test type: TypeOf, IsDateTime, IsHandle, IsNaN

Integration with other applications

Reading data

Spreadsheet access


Database and ODBC access

COM API

Error handling

Set functions


Objects and meta-inference

User modifiable attributes

Other common attributes

Rare attributes

Sensitivity analysis

Special

Evaluation

Analytica environment information

Function parameter qualifiers

Functions still to be categorized




Optimizer functions

Obsolete optimizer

Comments


You are not allowed to post comments.