Difference between revisions of "Functions by category"

m
Line 9: Line 9:
  
 
== Language, control, and syntax ==
 
== Language, control, and syntax ==
 +
'''[[Operators]]: '''Arithmetic: + - * / ^  Comparison: =  <  >  <>  <=  >=  Logical:  [[And]], [[Or]], [[Not]]; Text concatenation: &; Subscript and slice: [[Subscript/Slice Operator| x[I=x], x[@I=x] ]] :Assignment: :=, Reference: \, Dereference: #,
  
−
=== Operators ===
+
'''Conditional constructs:''' [[If-Then-Else]], [[Ifall-Then-Else]], [[Ifonly-Then-Else]], [[If0]], [[Ifpos]]
  
−
* [[Arithmetic Operators|+ - * / ^]] : Arithmetic operators
+
'''Loops:''' [[While..Do]], [[For..Do]]
−
* [[Exponentiation of negative numbers|x^y]] : Exponentiation
 
−
* [[Comparison Operators|=  <  >  <>  <=  >=]] : Comparison operators
 
−
* [[Logical operators]]: [[And]], [[Or]], [[Not]]
 
−
* [[Subscript/Slice Operator| x[I=x], x[@I=x] ]] : Subscript and slice operators
 
−
* [[Using References|\]], [[Dereference Operator|#]]: Reference and dereference operators
 
−
* [[Assignment Operator:: ::=|:=]] : Assignment operator
 
−
* [[Text Concatenation Operator: &|&]] : Text concatenation operator
 
−
* [[Dot operator::A.I|A.I]]: Dot operator, to access a local index of an array
 
−
* [[Repeated Parameter Forwarding|...]] : Repeated parameter forwarding
 
−
* [[Index Position Operator::@|Index Position Operator: @I, @[I=x] ]] : Get the numeric position of index elements
 
−
* [[PositionInIndex]]
 
  
−
=== Constructs and loops ===
+
'''Grouped expressions:'''  (expr; expr),  BEGIN expr; expr END
  
−
* [[expr1 ; expr2]] : Expression Sequence Operator
+
'''Comments:''' { commented text }
−
* [[If-Then-Else]], [[Ifall-Then-Else]], [[Ifonly-Then-Else]]
 
−
* [[While..Do]], [[For..Do]]
 
−
* [[If0]], [[Ifpos]]
 
  
−
=== Declarations of local variables ===
+
'''Declaring local variables:''' Using x DO; Var x; Index i;  MetaVar v; MetaIndex i; Alias a
−
 
 
−
* [[Using..Do]]
 
−
* [[Var..Do]]
 
−
* [[Index..Do]]
 
  
 
==Mathematics==
 
==Mathematics==
 +
'''Basic math:''' [[Abs]], [[Sign]], [[Mod]], [[Round]], [[Ceil]], [[Floor]], [[Sqr]], [[Sqrt]], [[Exp]], [[Ln]], [[LogTen]], [[Factorial]], [[Degrees]], [[Radians]]
  
−
=== Basic math ===
+
'''Trigonometry: '''[[Trig Functions| Sin, Cos, Tan]];[[Trig Functions| Sinh, Cosh, Tanh]]; [[ArcSin]], [[ArcCos]], [[ArcTan]], [[ArcTan2]]; [[ArcSinH]],  [[ArcCosH]], [[ArcTanH]]
−
* [[Abs]], [[Sign]], [[Mod]], [[Round]], [[Ceil]], [[Floor]]
 
−
* [[Sqr]], [[Sqrt]], [[Exp]], [[Ln]], [[LogTen]]
 
−
* [[Factorial]]
 
−
* [[Degrees]], [[Radians]]
 
  
−
===Trigonometry ===
+
'''Complex numbers:''' [[RealPart]], [[ImPart]], [[ComplexDegrees]], [[ComplexRadians]], [[Conj]]
  
−
* [[Trig Functions| Sin, Cos, Tan]]
+
==Statistics and Probability distributions==
−
* [[Trig Functions| Sinh, Cosh, Tanh]]
+
'''Statistics: '''[[Median]], [[Mean]],  [[SDeviation]], [[Variance]], [[Skewness]], [[Kurtosis]], [[Statistics]], [[Probability]], [[GetFract]],  [[ProbBands]]
−
* [[ArcSin]], [[ArcCos]], [[ArcTan]], [[ArcTan2]]
+
* [[Correlation]], [[RankCorrel]], [[Regression]]
−
* [[ArcSinH]],  [[ArcCosH]], [[ArcTanH]]
 
−
 
 
−
=== Complex numbers ===
 
−
 
 
−
* [[RealPart]], [[ImPart]]
 
−
* [[ComplexDegrees]], [[ComplexRadians]]
 
−
* [[Conj]]
 
−
 
 
−
==Probability distributions==
 
−
 
 
−
=== Statistics ===
 
−
 
 
−
Return statistics from random samples:
 
−
 
 
−
* [[Median]], [[Mean]],  [[SDeviation]], [[Variance]], [[Skewness]], [[Kurtosis]]
 
−
* [[Statistics]]
 
−
* [[Probability]]
 
−
* [[GetFract]],  [[ProbBands]]
 
−
* [[Correlation]], [[RankCorrel]]
 
 
* [[Cdf]],  [[Pdf]]
 
* [[Cdf]],  [[Pdf]]
−
* [[Regression]]
+
'''Custom distributions: '''[[CumDist]], [[Fractiles]], [[ChanceDist]], [[ProbDist]], [[ProbTable]], [[Random]]
−
 
 
−
===Custom distribution functions===
 
  
−
* [[CumDist]], [[Fractiles]]
+
'''Discrete distributions: '''[[Bernoulli]], [[Binomial]], [[NegativeBinomial]], [[Combinations]],  [[Permutations]], [[Geometric]], [[HyperGeometric]], [[Certain]]
−
* [[ChanceDist]], [[ProbDist]], [[ProbTable]]
 
−
* [[Random]]
 
  
−
===Discrete distribution functions===
+
'''Continuous distribution functions: '''[[Uniform]], [[Normal]], [[LogNormal]], [[Beta]], [[Triangular]], [[Poisson]], [[Exponential]], [[Gamma]], [[StudentT]], [[Weibull]], [[Wilcoxon]], [[Logistic]], [[BesselJ]], [[BesselY]], [[BesselI]], [[BesselK]], [[ChiSquared]]
  
−
* [[Bernoulli]], [[Binomial]], [[NegativeBinomial]]
+
'''Modifying distributions: ''' [[Mid]], [[Sample]],  [[Truncate]], [[Shuffle]]
−
* [[Combinations]],  [[Permutations]]
 
−
* [[Geometric]], [[HyperGeometric]]
 
−
* [[Certain]]
 
  
−
===Continuous distribution functions===
+
'''Functions for distributions: '''[[ProbWilcoxon]], [[CumWilcoxon]], [[CumWilcoxonInv]], [[BetaI]], [[BetaIInv]], [[GammaI]], [[GammaIInv]], [[CumNormal]], [[CumNormalInv]]
  
−
* [[Uniform]], [[Normal]], [[LogNormal]], [[Beta]], [[Triangular]], [[Poisson]]
+
'''SIPs and SLURPs: '''[[SipDecode]], [[SipEncode]]
−
* [[Exponential]], [[Gamma]], [[StudentT]], [[Weibull]], [[Wilcoxon]], [[Logistic]]
+
;<nowiki> Date and Time: </nowiki>[[Today]], [[Date_Functions#MakeDate.28year.2C_month.2C_day.29| MakeDate]], [[DateAdd]], [[DatePart]]
−
* [[BesselJ]], [[BesselY]], [[BesselI]], [[BesselK]], [[ChiSquared]]
+
'''Text functions: '''[[SelectText]],  [[FindInText]], [[TextReplace]], [[SplitText]], [[JoinText]], [[Text Concatenation Operator: &|Text Concatenation: t1&]]<nowiki/>t2 [[TextLength]], [[TextLowerCase]], [[TextUpperCase]], [[TextSentenceCase]], [[TextTrim]]
−
 
 
−
=== Modifying distributions ===
 
−
 
 
−
* [[Mid]], [[Sample]],  [[Truncate]], [[Shuffle]]
 
−
 
 
−
=== Functions for distributions ===
 
−
 
 
−
* [[ProbWilcoxon]], [[CumWilcoxon]], [[CumWilcoxonInv]]
 
−
* [[BetaI]], [[BetaIInv]]
 
−
* [[GammaI]], [[GammaIInv]]
 
−
* [[CumNormal]], [[CumNormalInv]]
 
−
 
 
−
=== SIP and SLURP ===
 
−
 
 
−
* [[SipDecode]], [[SipEncode]]
 
−
 
 
−
 
 
−
; Date and Time: [[Today]], [[Date_Functions#MakeDate.28year.2C_month.2C_day.29| MakeDate]], [[DateAdd]], [[DatePart]]
 
−
 
 
−
== Text functions ==
 
−
 
 
−
* [[SelectText]],  [[FindInText]], [[TextReplace]]
 
−
* [[SplitText]], [[JoinText]]
 
−
* [[Text Concatenation Operator: &|Text Concatenation Operator: A&B]] : Concatenate two text strings
 
−
* [[TextLength]]
 
−
* [[TextLowerCase]], [[TextUpperCase]], [[TextSentenceCase]]
 
−
* [[TextTrim]]
 
  
 
== Array functions ==
 
== Array functions ==
 +
'''Make an Index: '''[[Sequence]],  [[Sequence Operator|Sequence Operator: first..last]], [[SortIndex]], [[SplitText]], [[SubIndex]], [[Subset]], [[Unique]]
  
−
=== Make an Index===
+
'''Array reducing: '''[[Sum]], [[Product]], [[Average]],[[Functions_Min_and_Max| Max]] [[Functions_Min_and_Max| Min]], [[ArgMin_and_ArgMax]], [[JoinText]], [[Functions_Min_and_Max| Condmax]], [[Functions_Min_and_Max| Condmin]], [[Area]]
−
 
 
−
* [[Sequence]],  [[Sequence Operator|Sequence Operator: first..last]]
 
−
* [[SortIndex]], [[SplitText]], [[SubIndex]], [[Subset]], [[Unique]]
 
−
 
 
−
=== Array reducing ===
 
−
 
 
−
* [[Sum]], [[Product]], [[Average]]
 
−
* [[Functions_Min_and_Max| Max]] [[Functions_Min_and_Max| Min]]
 
−
* [[ArgMin_and_ArgMax]]
 
−
* [[JoinText]]
 
−
* [[Functions_Min_and_Max| Condmax]], [[Functions_Min_and_Max| Condmin]]
 
−
* [[Area]]
 
−
 
 
−
=== Subscript, selection, lookup ===
 
−
 
 
−
* [[Slice]], [[Subscript]], [[StepInterp]]
 
−
* [[Subscript/Slice Operator| Slice Operator: [@I=n] ]]
 
  
−
=== Array mapping ===
+
'''Subscript, selection, lookup: '''[[Slice]], [[Subscript]], [[StepInterp]], [[Subscript/Slice Operator|Slice Operator: [@I=n] ]]
  
 +
'''Array mapping: '''
 
* [[Cumulate]], [[Uncumulate]], [[CumProduct]], [[Normalize]], [[Integrate]]
 
* [[Cumulate]], [[Uncumulate]], [[CumProduct]], [[Normalize]], [[Integrate]]
 
* [[Rank]], [[Sort]]
 
* [[Rank]], [[Sort]]
 
* [[Aggregate]]
 
* [[Aggregate]]
−
 
+
'''Tables and functions to make arrays: '''[[Array]], [[Table]], [[SubTable]], [[MultiTable]], [[DetermTable]], [[ProbTable]]
−
=== Tables and functions to make arrays ===
 
−
 
 
−
* [[Array]]
 
−
* [[Table]], [[SubTable]], [[MultiTable]], [[DetermTable]], [[ProbTable]]
 
 
* [[AddIndex]]
 
* [[AddIndex]]
  
−
 
+
'''Interpolation: '''[[StepInterp]], [[LinearInterp]], [[CubicInterp]], [[MonoCubicInterp]]
−
=== Interpolation ===
 
−
 
 
−
* [[StepInterp]], [[LinearInterp]], [[CubicInterp]], [[MonoCubicInterp]]
 
  
 
=== Matrix ===
 
=== Matrix ===
  
 
* [[MatrixMultiply]], [[Transpose]], [[Invert]], [[Determinant]], [[Decompose]],  [[EigenDecomp]], [[SingularValueDecomp]]
 
* [[MatrixMultiply]], [[Transpose]], [[Invert]], [[Determinant]], [[Decompose]],  [[EigenDecomp]], [[SingularValueDecomp]]
 +
'''Information about arrays: '''[[Size]], [[IndexesOf]], [[IndexNames]], [[MemoryInUseBy]]
  
−
=== Information about arrays ===
+
'''Relational tables:'''
−
 
 
−
* [[Size]]
 
−
* [[IndexesOf]], [[IndexNames]]
 
−
* [[MemoryInUseBy]]
 
−
 
 
−
=== Relational transformations ===
 
−
 
 
 
* [[MdTable]], [[MdArrayToTable]]
 
* [[MdTable]], [[MdArrayToTable]]
 
* [[Aggregate]]
 
* [[Aggregate]]
−
 
+
'''Other array functions'''
−
=== Other array functions ===
 
−
 
 
 
* [[SortIndex]]
 
* [[SortIndex]]
 
* [[Split]]
 
* [[Split]]
Line 179: Line 76:
 
* [[Subset]]
 
* [[Subset]]
 
* [[Unique]]
 
* [[Unique]]
−
 
−
* [[MdArrayToTable]]
 
−
* [[MdTable]]
 
  
 
== Financial ==
 
== Financial ==

Revision as of 03:53, 10 September 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

Financial

User interaction and dialog

User input

User dialog boxes

Types and type conversion

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.