Difference between revisions of "Functions by category"

m
Line 8: Line 8:
 
[[Rare and deprecated functions]]
 
[[Rare and deprecated functions]]
  
== Operators ==
+
== Language, control, and syntax ==
 +
 
 +
=== Operators ===
  
 
* [[Arithmetic Operators|+ - * / ^]] : Arithmetic operators
 
* [[Arithmetic Operators|+ - * / ^]] : Arithmetic operators
Line 23: Line 25:
 
* [[PositionInIndex]]
 
* [[PositionInIndex]]
  
== Constructs and loops ==
+
=== Constructs and loops ===
  
 
* [[expr1 ; expr2]] : Expression Sequence Operator
 
* [[expr1 ; expr2]] : Expression Sequence Operator
* [[If-Then-Else]]
+
* [[If-Then-Else]], [[Ifall-Then-Else]], [[Ifonly-Then-Else]]
* [[Ifall-Then-Else]]
+
* [[While..Do]], [[For..Do]]
* [[Ifonly-Then-Else]]
+
* [[If0]], [[Ifpos]]
* [[While..Do]]
+
 
 +
=== Declarations of local variables ===
 +
 
 
* [[Using..Do]]
 
* [[Using..Do]]
 
* [[Var..Do]]
 
* [[Var..Do]]
* [[If0]]
+
 
* [[Ifpos]]
 
  
 
==Mathematics==
 
==Mathematics==
  
 
=== Basic math ===
 
=== Basic math ===
[[Sqr]], [[Sqrt]], [[Exp]], [[Ln]]
+
* [[Abs]], [[Sign]], [[Round]], [[Ceil]], [[Floor]]
 +
 
 +
* [[Sqr]], [[Sqrt]], [[Exp]], [[Ln]], [[LogTen]]
  
[[Abs]], [[Sign]], [[Round]], [[Ceil]], [[Floor]]
+
* [[Factorial]]
  
[[Degrees]], [[Radians]]
+
* [[Degrees]], [[Radians]]
  
===Trig functions==
+
===Trigonometry ==
  
 
* [[Trig Functions| Sin, Cos, Tan]]
 
* [[Trig Functions| Sin, Cos, Tan]]
Line 55: Line 60:
 
* [[ArcTan2]]
 
* [[ArcTan2]]
 
* [[ArcTanH]]
 
* [[ArcTanH]]
 
=== Input functions ===
 
 
* [[Choice| Choice]]
 
  
 
==Probability distributions==
 
==Probability distributions==
  
=== Statistical functions ===
+
=== Statistics ===
  
 
Return statistics from random samples:
 
Return statistics from random samples:
  
 +
* [[Mean]],  [[SDeviation]], [[Variance]], [[Skewness]], [[Kurtosis]]
 +
* [[Statistics]]
 
* [[Probability]]
 
* [[Probability]]
* [[ProbBands]]
+
* [[GetFract]],  [[ProbBands]]
 
* [[RankCorrel]]
 
* [[RankCorrel]]
* [[SDeviation]]
 
* [[Variance]]
 
* [[Skewness]]
 
* [[Statistics]]
 
 
* [[Regression]]
 
* [[Regression]]
  
Line 79: Line 78:
 
* [[ChanceDist]]
 
* [[ChanceDist]]
 
* [[CumDist]]
 
* [[CumDist]]
 +
* [[Fractiles]]
 
* [[ProbDist]]
 
* [[ProbDist]]
 
* [[ProbTable]]
 
* [[ProbTable]]
Line 85: Line 85:
 
===Discrete distribution functions===
 
===Discrete distribution functions===
  
* [[Bernoulli]]
+
* [[Bernoulli]], [[Binomial]], [[NegativeBinomial]]
* [[Binomial]]
 
* [[Certain]]
 
 
* [[Combinations]]
 
* [[Combinations]]
 
* [[Geometric]]
 
* [[Geometric]]
 
* [[HyperGeometric]]
 
* [[HyperGeometric]]
 
* [[Permutations]]
 
* [[Permutations]]
 
+
* [[Certain]]
  
 
===Continuous distribution functions===
 
===Continuous distribution functions===
  
* [[Uniform]]
+
* [[Uniform]], [[Normal]], [[Beta]], [[Triangular]], [[Poisson]]
* [[Beta]]
+
* [[Exponential]], [[Gamma]], [[StudentT]], [[Weibull]], [[Wilcoxon]]
* [[Triangular]]
 
* [[Poisson]]
 
* [[Exponential]]
 
* [[Gamma]]
 
* [[StudentT]]
 
* [[Weibull]]
 
* [[Wilcoxon]]
 
 
* [[BesselJ]], [[BesselY]], [[BesselI]], [[BesselK]]
 
* [[BesselJ]], [[BesselY]], [[BesselI]], [[BesselK]]
  
Line 130: Line 121:
  
  
=== Date and Time ===
+
; Date and Time: [[Today]], [[Date_Functions#MakeDate.28year.2C_month.2C_day.29| MakeDate]], [[DateAdd]], [[DatePart]]
 
 
* [[Today]]
 
* [[DateAdd]]
 
* [[DatePart]]
 
 
 
== Functions that return an Index==
 
 
 
* [[Sequence]]
 
* [[Sequence Operator|Sequence Operator: first..last]]
 
  
 
== Text functions ==
 
== Text functions ==
  
* [[JoinText]]
+
* [[SelectText]][[FindInText]], [[TextReplace]]
* [[FindInText]]
+
* [[SplitText]], [[JoinText]]
* [[SelectText]]
 
* [[TextReplace]]
 
* [[SplitText]]
 
 
* [[Text Concatenation Operator: &|Text Concatenation Operator: A&B]] : Concatenate two text strings
 
* [[Text Concatenation Operator: &|Text Concatenation Operator: A&B]] : Concatenate two text strings
 
* [[TextLength]]
 
* [[TextLength]]
* [[TextLowerCase]]
+
* [[TextLowerCase]], [[TextUpperCase]], [[TextSentenceCase]]
* [[TextUpperCase]]
 
* [[TextSentenceCase]]
 
 
* [[TextTrim]]
 
* [[TextTrim]]
  
 
== Array functions ==
 
== Array functions ==
 +
 +
== Make an Index==
 +
 +
* [[Sequence]]
 +
* [[Sequence Operator|Sequence Operator: first..last]]
 +
* [[SortIndex]]
 +
* [[Split]]
 +
* [[SubIndex]]
 +
* [[Subset]]
 +
* [[Unique]]
  
 
* [[Size]]
 
* [[Size]]
 
* [[Reform]]
 
* [[Reform]]
  
=== Array-reducing functions ==
+
=== Array reducing ==
  
 
* [[Sum]]
 
* [[Sum]]
Line 171: Line 158:
 
* [[Functions_Min_and_Max| Condmin]]
 
* [[Functions_Min_and_Max| Condmin]]
  
=== Array mapping functions ===
+
=== Subscript, selection, lookup ===
 +
 
 +
* [[Slice]], [[Subscript]], [[StepInterp]]
 +
 
 +
=== Array mapping ===
  
* [[CumProduct]]
+
* [[Cumulate]], [[Uncumulate]], [[CumProduct]]
 
* [[Rank]]
 
* [[Rank]]
* [[Uncumulate]]
 
  
  
Line 181: Line 171:
  
 
* [[Array]]
 
* [[Array]]
* [[Table]]
+
* [[Table]], [[SubTable]], [[MultiTable]]
* [[DetermTable]]
+
* [[DetermTable]], [[ProbTable]]
* [[SubTable]]
 
 
 
 
* [[AddIndex]]
 
* [[AddIndex]]
 
* [[Aggregate]]
 
* [[Aggregate]]
* [[AnalyticaLicenseInfo]]
 
  
=== Interpolation functions ===
+
=== Interpolation ===
  
* [[StepInterp]]
+
* [[StepInterp]], [[LinearInterp]], [[CubicInterp]]
* [[CubicInterp]]
+
 
 +
=== Matrix ===
 +
 
 +
* [[DotProduct]], [[MatrixMultiply]], [[Transpose]]
 +
* [[EigenDecomp]], [[Decompose]], [[Determinant]], [[SingularValueDecomp]]
  
 
=== Other array functions ===
 
=== Other array functions ===
Line 204: Line 195:
 
* [[Unique]]
 
* [[Unique]]
  
 +
== Financial ==
 +
 +
* [[Pv]], [[Fv]], [[Npv]], [[XNpv]]
 +
* [[Rate]], [[NPer]]
 +
* [[Pmt]], [[PPmt]], [[IPmt]], [[CumIPmt]]
 +
* [[Irr]], [[XIrr]]
 +
 +
== User interaction and dialog ==
  
== Financial functions ==
+
=== User input ===
  
* [[Rate]]
+
* [[Choice| Choice]], [[Checkbox]]
* [[Pmt]]
 
* [[Pv]]
 
* [[CumIPmt]]
 
* [[PPmt]]
 
* [[XIrr]]
 
* [[XNpv]]
 
  
== User interaction and dialog functions ==
+
=== User dialog boxes ===
  
* [[AskMsgChoice]]
+
* [[AskMsgChoice]], [[AskMsgNumber]], [[AskMsgText]], [[Error]]
* [[AskMsgNumber]]
 
* [[AskMsgText]]
 
* [[Error]]
 
 
* [[ShowProgressBar]]
 
* [[ShowProgressBar]]
  
== Types and type conversion functions ==
+
== Types and type conversion ==
  
* [[Chr]]
+
* [[Chr]], [[Asc]]
* [[Coerce_to_Numeric]]    (Flat file library.ana)
+
* [[NumberToText]], [[Coerce_to_Numeric]]    (Flat file library.ana)
* [[ParseDate]]
+
* [[ParseDate]], [[ParseNumber]]
* [[ParseNumber]]
 
* [[Asc]]
 
 
* [[Data_Type_Functions#Function_TypeOf| TypeOf]]
 
* [[Data_Type_Functions#Function_TypeOf| TypeOf]]
 +
* [[IsDateTime]]
 +
* [[IsHandle]]
 +
* [[Data_Type_Functions#Function_IsNaN| IsNaN]]
 +
* [[Data_Type_Functions#Function_IsNotSpecified| IsNotSpecified]]
 +
* [[IsNull]]
 +
* [[Data_Type_Functions#Function_IsNumber| IsNumber]]
 +
* [[IsRealNumber]]
 +
* [[Data_Type_Functions#Function_IsReference| IsReference]]
 +
* [[IsResultComputed]]
 +
* [[Data_Type_Functions#Function_IsText| IsText]]
 +
* [[Data_Type_Functions#Function_IsUndef| IsUndef]]
  
 
== Integration with other applications ==
 
== Integration with other applications ==
 
[[RunConsoleProcess]]
 
  
 
=== Reading data ===
 
=== Reading data ===
Line 244: Line 241:
 
* [[WriteTextFile]]
 
* [[WriteTextFile]]
  
== Spreadsheet access ==
+
=== Spreadsheet access ===
 
* [[SpreadsheetCell]]
 
* [[SpreadsheetCell]]
 
* [[SpreadsheetInfo]]
 
* [[SpreadsheetInfo]]
Line 253: Line 250:
 
* [[SpreadsheetSetInfo]]
 
* [[SpreadsheetSetInfo]]
 
* [[SpreadsheetSetRange]]
 
* [[SpreadsheetSetRange]]
 +
 +
* [[OpenExcelFile]]  -- depreciated: use [[SpreadsheetOpen]]
  
 
=== Database and ODBC access ===
 
=== Database and ODBC access ===
  
 
* [[SqlDriverInfo]]
 
* [[SqlDriverInfo]]
 +
* [[DbLabels]]
 +
* [[DbQuery]]
 +
* [[DbTable]]
 +
* [[DbTablenames]]
 +
* [[DbWrite]]
  
 
* [[AttribGet]]
 
* [[AttribGet]]
  
  
* [[Boolean]]
+
[[RunConsoleProcess]]
 
 
=== Error handling ===
 
 
 
* [[Error]]
 
* [[ReThrow]]
 
* [[Try]]
 
  
== Complex number functions ==
+
=== COM API  ===
* [[RealPart]]
 
* [[ComplexDegrees]]
 
* [[ComplexRadians]]
 
  
== COM functions ==
 
 
* [[COMArray]]
 
* [[COMArray]]
 
* [[COMCallMethod]]
 
* [[COMCallMethod]]
Line 280: Line 274:
 
* [[COMGetProperty]]
 
* [[COMGetProperty]]
  
== Database functions ==
+
=== Error handling ===
  
* [[DbLabels]]
+
* [[Error]]
* [[DbQuery]]
+
* [[IgnoreWarnings]]
* [[DbTable]]
+
* [[Try]], [[ReThrow]]
* [[DbTablenames]]
 
* [[DbWrite]]
 
  
== Matrix functions ==
+
== Complex numbers ==
  
* [[DotProduct]]
+
* [[RealPart]], [[ImPart]]
* [[EigenDecomp]]
+
* [[ComplexDegrees]], [[ComplexRadians]]
* [[Decompose]]
 
* [[Determinant]]
 
* [[Transpose]]
 
* [[SingularValueDecomp]]
 
  
 
== Set functions ==
 
== Set functions ==
Line 307: Line 295:
 
* [[Discrete]]
 
* [[Discrete]]
 
* [[Dispatch]]
 
* [[Dispatch]]
 +
 +
== Objects and meta-inference ==
 +
 +
* [[ListOfHandles]]
 
* [[Dereference Operator::#|Dereference Operator: #R]] : Return the value pointed to by a reference R.
 
* [[Dereference Operator::#|Dereference Operator: #R]] : Return the value pointed to by a reference R.
 +
* [[VarTerm Functions#Function_IndexesOf| IndexesOf]], [[IndexNames]]
 +
* [[VarTerm Functions#Function_GetVariableByName| GetVariableByName]]
 +
* [[IndexValue]]
  
 +
=== User modifiable attributes ===
  
 +
=== Other common attributes ===
  
 +
=== Rare attributes ===
  
 
=== Sensitivity analysis ===
 
=== Sensitivity analysis ===
Line 319: Line 317:
 
* [[WhatIfAll]]
 
* [[WhatIfAll]]
  
=== Special functions ===
+
=== Special ===
  
 
* [[Dynamic]]
 
* [[Dynamic]]
 +
 +
=== Evaluation ===
 +
 
* [[Evaluate]]
 
* [[Evaluate]]
 
* [[EvaluateScript]]
 
* [[EvaluateScript]]
 +
* [[GetEvaluationContext]]
  
 +
=== Analytica information ===
 +
 +
* [[AnalyticaLicenseInfo]], [[GetProcessInfo]]
 +
 +
* [[GetRegistryValue]]
 +
 +
 +
== Function parameter qualifiers ==
 +
 +
* [[Boolean]]
 +
 +
== Functions still to be categorized ==
 
* [[Erf]]
 
* [[Erf]]
 
* [[ErfInv]]
 
* [[ErfInv]]
 
 
* [[Factorial]]
 
 
* [[FFT]]
 
* [[FFT]]
 
* [[FFTInv]]
 
* [[FFTInv]]
  
 
* [[FindPolynomialZeroes]]
 
* [[FindPolynomialZeroes]]
* [[Floor]]
+
 
* [[For..Do]]
+
 
* [[Fractiles]]
 
 
* [[Frequency]]
 
* [[Frequency]]
 
* [[FunctionOf]]
 
* [[FunctionOf]]
* [[Fv]]
 
  
 
* [[Gamma_m_sd|Gamma_m_sd]]                (Distribution Variations.ana)
 
* [[Gamma_m_sd|Gamma_m_sd]]                (Distribution Variations.ana)
Line 348: Line 357:
 
* [[GCD]]                  ([[media:GCD function library.ana|GCD function library.ana]])
 
* [[GCD]]                  ([[media:GCD function library.ana|GCD function library.ana]])
  
* [[GetEvaluationContext]]
 
* [[GetFract]]
 
* [[GetProcessInfo]]
 
* [[GetRegistryValue]]
 
* [[VarTerm Functions#Function_GetVariableByName| GetVariableByName]]
 
 
* [[GoalSeek]]              (Optimization Functions.ana)
 
* [[GoalSeek]]              (Optimization Functions.ana)
 
* [[Gradient]]              (Optimization Functions.ana)
 
* [[Gradient]]              (Optimization Functions.ana)
* [[GroupedInteger]]
 
  
* [[IgnoreWarnings]]
+
 
 
* [[Im]]                    (Complex Library.ana)
 
* [[Im]]                    (Complex Library.ana)
* [[ImPart]]
 
 
* [[Implied_volatility_c]]  (Financial library.ana)
 
* [[Implied_volatility_c]]  (Financial library.ana)
 
* [[Implied_volatility_p]]  (Financial library.ana)
 
* [[Implied_volatility_p]]  (Financial library.ana)
  
* [[VarTerm Functions#Function_IndexesOf| IndexesOf]]
 
 
* [[Index..Do]]
 
* [[Index..Do]]
* [[IndexNames]]
+
 
* [[IndexValue]]
 
 
* [[InsertRecSql]]      (ODBC Library.ana)
 
* [[InsertRecSql]]      (ODBC Library.ana)
 
* [[Integer]]
 
* [[Integer]]
Line 374: Line 374:
 
* [[InvertedWishart]]  (Distribution Variations.ana)
 
* [[InvertedWishart]]  (Distribution Variations.ana)
 
* [[InvLogit]]          (Generalized Regression.ana)
 
* [[InvLogit]]          (Generalized Regression.ana)
* [[IPmt]]
+
 
* [[Irr]]
 
* [[IsDateTime]]
 
* [[IsHandle]]
 
* [[Data_Type_Functions#Function_IsNaN| IsNaN]]
 
* [[Data_Type_Functions#Function_IsNotSpecified| IsNotSpecified]]
 
* [[IsNull]]
 
* [[Data_Type_Functions#Function_IsNumber| IsNumber]]
 
* [[IsRealNumber]]
 
* [[Data_Type_Functions#Function_IsReference| IsReference]]
 
* [[IsResultComputed]]
 
* [[Data_Type_Functions#Function_IsText| IsText]]
 
* [[Data_Type_Functions#Function_IsUndef| IsUndef]]
 
 
* [[Iterate]]
 
* [[Iterate]]
 
* [[Join]]
 
* [[Join]]
  
* [[Kurtosis]]
 
 
* [[LDens_InvertedWishart]] (Distribution Densities.ana)
 
* [[LDens_InvertedWishart]] (Distribution Densities.ana)
 
* [[LDens_Wishart]]      (Distribution Densities.ana)
 
* [[LDens_Wishart]]      (Distribution Densities.ana)
 
* [[LGamma]]
 
* [[LGamma]]
 
* [[LinearInterp]]
 
* [[LinearInterp]]
* [[ListOfHandles]]
+
 
 
* [[LL_First]]            (Linked List Library.ana)
 
* [[LL_First]]            (Linked List Library.ana)
 
* [[LL_Length]]          (Linked List Library.ana)
 
* [[LL_Length]]          (Linked List Library.ana)
Line 403: Line 390:
 
* [[LL_To_Array]]        (Linked List Library.ana)
 
* [[LL_To_Array]]        (Linked List Library.ana)
 
* [[LL_to_RArray]]        (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
 
* [[Local Index Operator::A.I]] : Get an index (usually a local index) of an array
 
* [[Logistic]]
 
* [[Logistic]]
Line 410: Line 397:
 
* [[LogNormal]]
 
* [[LogNormal]]
 
* [[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)
* [[LogTen]]
+
 
 
* [[Lorenzian]]            (Distribution variations.ana)
 
* [[Lorenzian]]            (Distribution variations.ana)
* [[LpDefine]]
+
 
* [[LpFindIIS]]
+
 
* [[LpObjSa]]
+
 
* [[LpOpt]]
 
* [[LpRead]]
 
* [[LpReducedCost]]
 
* [[LpRhsSa]]
 
* [[LpShadow]]
 
* [[LpSlack]]
 
* [[LpSolution]]
 
* [[LpStatusNum]]
 
* [[LpStatusText]]
 
* [[LpWrite]]
 
* [[LpWriteIIS]]
 
* [[Date_Functions#MakeDate.28year.2C_month.2C_day.29| MakeDate]]
 
* [[MatrixMultiply]]
 
 
* [[Functions_Min_and_Max| Max]]
 
* [[Functions_Min_and_Max| Max]]
 
* [[MdArrayToTable]]
 
* [[MdArrayToTable]]
Line 442: Line 416:
 
* [[Multinomial]]              (Multivariate Distributions.ana)
 
* [[Multinomial]]              (Multivariate Distributions.ana)
 
* [[MultiNormal]]              (Multivariate Distributions.ana)
 
* [[MultiNormal]]              (Multivariate Distributions.ana)
* [[MultiTable]]
 
 
* [[MultiUniform]]            (Multivariate Distributions.ana)
 
* [[MultiUniform]]            (Multivariate Distributions.ana)
* [[NegBinomial]]              (Distribution Variations.ana)
 
* [[NegativeBinomial]]
 
* [[NlpDefine]]
 
* [[Normal]]
 
 
* [[Normal_additive_gro]]      (Multivariate Distributions.ana)
 
* [[Normal_additive_gro]]      (Multivariate Distributions.ana)
 
* [[Normal_compound_gro]]      (Multivariate Distributions.ana)
 
* [[Normal_compound_gro]]      (Multivariate Distributions.ana)
 
* [[Normal_correl]]            (Multivariate Distributions.ana)
 
* [[Normal_correl]]            (Multivariate Distributions.ana)
 
* [[Normal_serial_correl]]    (Multivariate Distributions.ana)
 
* [[Normal_serial_correl]]    (Multivariate Distributions.ana)
 +
* [[NegBinomial]]              (Distribution Variations.ana)
 +
 +
 
* [[Normalize]]
 
* [[Normalize]]
  
* [[NPer]]
+
 
* [[Npv]]
 
* [[NumberToText]]
 
* [[OpenExcelFile]]  -- depreciated: use [[SpreadsheetOpen]]
 
 
* [[OpenURL]]
 
* [[OpenURL]]
  
Line 480: Line 449:
 
* [[OptWrite]]
 
* [[OptWrite]]
 
* [[OptWriteIIS]]
 
* [[OptWriteIIS]]
 +
 +
* [[GroupedInteger]]
 +
 +
=== Obsolete optimizer ===
 +
 +
* [[LpDefine]]
 +
* [[LpFindIIS]]
 +
* [[LpObjSa]]
 +
* [[LpOpt]]
 +
* [[LpRead]]
 +
* [[LpReducedCost]]
 +
* [[LpRhsSa]]
 +
* [[LpShadow]]
 +
* [[LpSlack]]
 +
* [[LpSolution]]
 +
* [[LpStatusNum]]
 +
* [[LpStatusText]]
 +
* [[LpWrite]]
 +
* [[LpWriteIIS]]
 +
* [[NlpDefine]]

Revision as of 17:50, 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

Constructs and loops

Declarations of local variables


Mathematics

Basic math

=Trigonometry

Probability distributions

Statistics

Return statistics from random samples:

Custom distribution functions

Discrete distribution functions

Continuous distribution functions

Modifying distributions

Functions for distributions


Date and Time
Today, MakeDate, DateAdd, DatePart

Text functions

Array functions

Make an Index

= Array reducing

Subscript, selection, lookup

Array mapping


Tables and functions to make arrays

Interpolation

Matrix

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


RunConsoleProcess

COM API

Error handling

Complex numbers

Set functions


Objects and meta-inference

User modifiable attributes

Other common attributes

Rare attributes

Sensitivity analysis

Special

Evaluation

Analytica information


Function parameter qualifiers

Functions still to be categorized






Optimizer functions

Obsolete optimizer

Comments


You are not allowed to post comments.