Difference between revisions of "Functions by category"

(Created page with "Function list (to be categorized)")
 
(new page)
Line 1: Line 1:
 
Function list (to be categorized)
 
Function list (to be categorized)
 +
 +
[[Category:Functions]]
 +
(Back to [[Analytica Reference]])
 +
 +
See also: [[:Category:Functions|functions by category]].
 +
 +
== Operators ==
 +
 +
* [[Arithmetic Operators|+ - * / ^]] : Arithmetic operators
 +
* [[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
 +
 +
== 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==
 +
* [[Abs]]
 +
* [[Ceil]]
 +
 +
===Trig functions==
 +
 +
* [[ArcCos]]
 +
* [[ArcCosH]]
 +
* [[ArcSin]]
 +
* [[ArcSinH]]
 +
* [[ArcTan]]
 +
* [[ArcTan2]]
 +
* [[ArcTanH]]
 +
 +
==Probability distributions==
 +
 +
===Custom distribution functions===
 +
 +
* [[ChanceDist]]
 +
 +
===Discrete distribution functions===
 +
 +
* [[Bernoulli]]
 +
* [[Binomial]]
 +
* [[Certain]]
 +
* [[Combinations]]
 +
* [[Geometric]]
 +
* [[HyperGeometric]]
 +
 +
 +
===Continuous distribution functions===
 +
 +
* [[BesselJ]], [[BesselY]], [[BesselI]], [[BesselK]]
 +
* [[Beta]]
 +
* [[Triangular]]
 +
* [[Truncate]]
 +
 +
* [[Beta_m_sd|Beta_m_sd]]    (Distribution variations.ana)
 +
* [[Betafn]]
 +
* [[BetaI]]
 +
* [[BetaIaInv]]
 +
* [[BetaIInv]]
 +
 +
* [[BiNormal]]    (Multivariate distributions.ana)
 +
 +
* [[Cdf]]
 +
* [[Gamma]]
 +
 +
== Functions that return an Index==
 +
 +
* [[Sequence]]
 +
* [[Sequence Operator|Sequence Operator: first..last]]
 +
 +
== Text functions ==
 +
 +
* [[JoinText]]
 +
* [[FindInText]]
 +
* [[SelectText]]
 +
* [[TextReplace]]
 +
* [[SplitText]]
 +
* [[Text Concatenation Operator: &|Text Concatenation Operator: A&B]] : Concatenate two text strings
 +
* [[TextLength]]
 +
* [[TextLowerCase]]
 +
* [[TextUpperCase]]
 +
* [[TextSentenceCase]]
 +
* [[TextTrim]]
 +
 +
== Array functions ==
 +
 +
=== Array-reducing functions ==
 +
 +
* [[Sum]]
 +
* [[Average]]
 +
* [[ArgMin_and_ArgMax]]
 +
 +
=== Tables and functions to make arrays ===
 +
 +
* [[Array]]
 +
* [[DetermTable]]
 +
 +
* [[AddIndex]]
 +
* [[Aggregate]]
 +
* [[AnalyticaLicenseInfo]]
 +
 +
 +
* [[Area]]
 +
 +
 +
* [[Asc]]
 +
 +
== User interaction and dialog functions ==
 +
 +
* [[AskMsgChoice]]
 +
* [[AskMsgNumber]]
 +
* [[AskMsgText]]
 +
* [[Error]]
 +
* [[ShowProgressBar]]
 +
 +
== Type conversion functions ==
 +
 +
* [[Chr]]
 +
* [[Coerce_to_Numeric]]    (Flat file library.ana)
 +
* [[ParseDate]]
 +
* [[ParseNumber]]
 +
 +
 +
== Obscure and deprecated functions ==
 +
 +
* [[AttribGet]]
 +
 +
 +
* [[Boolean]]
 +
 +
== Complex number functions ==
 +
* [[CAbs]]        (Complex Library.ana)
 +
* [[CAdjoint]]    (Complex Library.ana)
 +
* [[Calloption]]  (Financial Library.ana)
 +
* [[Capm]]        (Financial Library.ana)
 +
* [[CArcCos]]      (Complex Library.ana)
 +
* [[CArcSin]]      (Complex Library.ana)
 +
* [[CArcTan]]      (Complex Library.ana)
 +
* [[CCos]]        (Complex Library.ana)
 +
* [[CDeterminant]] (Complex Library.ana)
 +
* [[CDiv]]        (Complex Library.ana)
 +
* [[CExp]]        (Complex Library.ana)
 +
* [[CInverse]]    (Complex Library.ana)
 +
* [[CLn]]          (Complex Library.ana)
 +
* [[CMatMult]]    (Complex Library.ana)
 +
* [[CMult]]        (Complex Library.ana)
 +
* [[Complex]]      (Complex Library.ana)
 +
* [[CRoots]]              (Complex Library.ana)
 +
* [[CSin]]                (Complex Library.ana)
 +
* [[CSqrt]]              (Complex Library.ana)
 +
* [[CTan]]                (Complex Library.ana)
 +
* [[CTheta]]              (Complex Library.ana)
 +
* [[CToPolar]]            (Complex Library.ana)
 +
 +
 +
* [[Change_index]]        (Expand Index.ana)
 +
* [[ChiSquared]]
 +
* [[Choice| Choice]]
 +
 +
 +
 +
 +
 +
== COM functions ==
 +
* [[COMArray]]
 +
* [[COMCallMethod]]
 +
* [[COMCreateObject]]
 +
* [[COMGetProperty]]
 +
* [[Comparison Operators]]: =, <, >, <>, <=, >=
 +
 +
* [[ComplexDegrees]]
 +
* [[ComplexRadians]]
 +
* [[CompressMemoryUsedBy]]
 +
* [[ComputedBy]]
 +
* [[COMPutProperty]]
 +
* [[Concat]]
 +
* [[ConcatN|Concat<N>]]    (Concatenation UDFs.ana
 +
* [[ConcatRows]]            (Concatenation UDFs.ana)
 +
* [[Functions_Min_and_Max| Condmax]]
 +
* [[Functions_Min_and_Max| Condmin]]
 +
* [[Continuous]]
 +
* [[CopyIndex]]
 +
* [[Correlate_Dists]]    (Multivariate Distributions.ana)
 +
* [[Correlate_With]]      (Multivariate Distributions.ana)
 +
* [[Correlation]]
 +
* [[Trig Functions| Cos]]
 +
* [[Trig Functions| Cosh]]
 +
* [[CostCapme]]    (Financial Library.ana)
 +
* [[CostCapmm]]    (Financial library.ana)
 +
 +
* [[CubicInterp]]
 +
* [[CumBinomial]]        ([[Distribution Densities Library]])
 +
* [[CumBinomialInv]]      ([[Distribution Densities Library]])
 +
* [[CumChiSquared]]      ([[Distribution Densities Library]])
 +
* [[CumChiSquaredInv]]    ([[Distribution Densities Library]])
 +
* [[CumDist]]
 +
* [[CumExponential]]      ([[Distribution Densities Library]])
 +
* [[CumExponentialInv]]  ([[Distribution Densities Library]])
 +
* [[CumFDist]]            ([[Distribution Densities Library]])
 +
* [[CumFDistInv]]        ([[Distribution Densities Library]])
 +
* [[CumGeometric]]        ([[Distribution Densities Library]])
 +
* [[CumGeometricInv]]    ([[Distribution Densities Library]])
 +
* [[CumIPmt]]
 +
* [[CumLogistic]]        ([[Distribution Densities Library]])
 +
* [[CumLogisticInv]]      ([[Distribution Densities Library]])
 +
* [[CumLogNormal]]        ([[Distribution Densities Library]])
 +
* [[CumLogNormalInv]]    ([[Distribution Densities Library]])
 +
* [[CumNegativeBinomial]] ([[Distribution Densities Library]])
 +
* [[CumNegativeBinomInv]] ([[Distribution Densities Library]])
 +
* [[CumNormal]]
 +
* [[CumNormalInv]]
 +
* [[CumPoisson]]          ([[Distribution Densities Library]])
 +
* [[CumPrinc]]
 +
* [[CumProduct]]
 +
* [[CumStudentT]]        ([[Distribution Densities Library]])
 +
* [[CumStudentTInv]]      ([[Distribution Densities Library]])
 +
* [[CumTriangular]]      ([[Distribution Densities Library]])
 +
* [[CumTriangularInv]]    ([[Distribution Densities Library]])
 +
* [[CumWilcoxon]]
 +
* [[CumWilcoxonInv]]
 +
* [[Cumulate]]
 +
* [[CumUniform]]          ([[Distribution Densities Library]])
 +
* [[CumUniformInv]]      ([[Distribution Densities Library]])
 +
* [[CumWeibull]]          ([[Distribution Densities Library]])
 +
* [[CumWeibullInv]]      ([[Distribution Densities Library]])
 +
* [[CurrentDataDirectory]]        (''Replaced with [[CurrentDataFolder]] as of [[Analytica 4.6]]'')
 +
 +
* [[CurrentModelDirector]]        (''Replaced with [[CurrentDataFolder]] as of [[Analytica 4.6]]'')
 +
* [[CurrentDataFolder]]
 +
* [[CurrentModelFolder]]
 +
* [[DateAdd]]
 +
* [[DatePart]]
 +
== Database functions ==
 +
 +
* [[DbLabels]]
 +
* [[DbQuery]]
 +
* [[DbTable]]
 +
* [[DbTablenames]]
 +
* [[DbWrite]]
 +
 +
== Matrix functions ==
 +
* [[Decompose]]
 +
* [[Degrees]]
 +
* [[Determinant]]
 +
* [[Transpose]]
 +
 +
 +
* [[Dens_Beta]]        ([[Distribution Densities Library]])
 +
* [[Dens_ChiSquared]]        ([[Distribution Densities Library]])
 +
* [[Dens_CumDist]]        ([[Distribution Densities Library]])
 +
* [[Dens_Exponential]]        ([[Distribution Densities Library]])
 +
* [[Dens_FDist]]        ([[Distribution Densities Library]])
 +
* [[Dens_Gamma]]        ([[Distribution Densities Library]])
 +
* [[Dens_Gaussian]]        ([[Distribution Densities Library]])
 +
* [[Dens_Logistic]]        ([[Distribution Densities Library]])
 +
* [[Dens_LogNormal]]        ([[Distribution Densities Library]])
 +
* [[Dens_Normal]]        ([[Distribution Densities Library]])
 +
* [[Dens_ProbDist]]        ([[Distribution Densities Library]])
 +
* [[Dens_StudentT]]        ([[Distribution Densities Library]])
 +
* [[Dens_Triangular]]        ([[Distribution Densities Library]])
 +
* [[Dens_Uniform]]        ([[Distribution Densities Library]])
 +
* [[Dens_Weibull]]        ([[Distribution Densities Library]])
 +
* [[Dereference Operator::#|Dereference Operator: #R]] : Return the value pointed to by a reference R.
 +
 +
* [[Dirichlet]]            (Multivariate distributions.ana)
 +
* [[Discrete]]
 +
* [[Dispatch]]
 +
* [[Dist_additive_growth]]  (Multivariate distributions.ana)
 +
* [[Dist_compound_growth]]  (Multivariate distributions.ana)
 +
* [[Dist_reshape]]          (Multivariate distributions.ana)
 +
* [[Dist_serial_correl]]    (Multivariate distributions.ana)
 +
* [[DomainAllowed]]
 +
* [[DomainIntegerGroup]]
 +
* [[DomainLowerBound]]
 +
* [[DomainNullOk]]
 +
* [[DomainType]]
 +
* [[DomainUpperBound]]
 +
* [[DotProduct]]
 +
 +
* [[Dynamic]]
 +
* [[EigenDecomp]]
 +
=== Sensitivity analysis ===
 +
 +
* [[Dydx]]
 +
* [[Elasticity]]
 +
* [[WhatIf]]
 +
* [[WhatIfAll]]
 +
 +
=== Special functions ===
 +
 +
* [[Evaluate]]
 +
* [[EvaluateScript]]
 +
 +
* [[Erf]]
 +
* [[ErfInv]]
 +
* [[Erlang]]          (Distribution variations.ana)
 +
 +
 +
* [[Exp]]
 +
* [[Exponential]]
 +
 +
* [[Factorial]]
 +
* [[FFT]]
 +
* [[FFTInv]]
 +
 +
* [[FindPolynomialZeroes]]
 +
* [[Floor]]
 +
* [[For..Do]]
 +
* [[Fractiles]]
 +
* [[Frequency]]
 +
* [[FunctionOf]]
 +
* [[Fv]]
 +
 +
* [[Gamma_m_sd|Gamma_m_sd]]                (Distribution Variations.ana)
 +
* [[GammaFn]]
 +
* [[GammaI]]
 +
* [[GammaIInv]]
 +
* [[Gaussian]]              (Multivariate Distributions.ana)
 +
* [[GCD]]                  ([[media:GCD function library.ana|GCD function library.ana]])
 +
 +
* [[GetEvaluationContext]]
 +
* [[GetFract]]
 +
* [[GetProcessInfo]]
 +
* [[GetRegistryValue]]
 +
* [[VarTerm Functions#Function_GetVariableByName| 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)
 +
 +
* [[VarTerm Functions#Function_IndexesOf| 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]]
 +
* [[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]]
 +
* [[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]]
 +
* [[Date_Functions#MakeDate.28year.2C_month.2C_day.29| MakeDate]]
 +
* [[MatrixMultiply]]
 +
* [[Functions_Min_and_Max| Max]]
 +
* [[MdArrayToTable]]
 +
* [[MdTable]]
 +
* [[MdxQuery]]
 +
* [[Mean]]
 +
* [[Median]]
 +
* [[MemoryInUseBy]]
 +
* [[Mid]]
 +
* [[Functions_Min_and_Max| 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 ==
 +
 +
* [[OptEngineInfo]]
 +
* [[OptFindIIS]]
 +
* [[OptGuess]]
 +
* [[OptInfo]]
 +
* [[OptObjective]]
 +
* [[OptObjectiveSa]]
 +
* [[OptRead]]
 +
* [[OptReducedCost]]
 +
* [[OptRhsSa]]
 +
* [[OptScalarToConstraint]]
 +
* [[OptScalarToDecision]]
 +
* [[OptShadow]]
 +
* [[OptSlack]]
 +
* [[OptSolution]]
 +
* [[OptStatusNum]]
 +
* [[OptStatusText]]
 +
* [[OptWrite]]
 +
* [[OptWriteIIS]]
 +
 +
* [[Pareto]]                    (Distribution Variations.ana)
 +
 +
* [[ParsedExprFunction]]
 +
* [[ParsedExprParameters]]
 +
* [[ParseNum]]                  (Flat file library.ana - for Analytica 4.1)
 +
 +
* [[Pdf]]
 +
* [[Permutations]]
 +
* [[Pert]]                      (Distribution Variations.ana)
 +
* [[Pmt]]
 +
* [[Poisson]]
 +
* [[PolarToC]]                  (Complex Library.ana)
 +
* [[Index Position Operator::@|Position Operator: @I, @[I=x] ]] : Get the numeric position of index elements
 +
* [[PositionInIndex]]
 +
* [[PPmt]]
 +
* [[Probability]]
 +
* [[ProbBands]]
 +
* [[ProbDist]]
 +
* [[Probit_Regression]] (Generalized Regression.ana)
 +
* [[ProbTable]]
 +
* [[Prob_Bernoulli]]        ([[Distribution Densities Library]])
 +
* [[Prob_Binomial]]        ([[Distribution Densities Library]])
 +
* [[Prob_ChanceDist]]      ([[Distribution Densities Library]])
 +
* [[Prob_Geometric]]        ([[Distribution Densities Library]])
 +
* [[Prob_HyperGeometric]]  ([[Distribution Densities Library]])
 +
* [[Prob_NegativeBinomia]]  ([[Distribution Densities Library]])
 +
* [[Prob_Poisson]]          ([[Distribution Densities Library]])
 +
* [[ProbWilcoxon]]
 +
* [[Product]]
 +
* [[Putoption]]        (Financial Library.ana)
 +
* [[Pv]]
 +
* [[Pvgperp]]          (Financial Library.ana)
 +
* [[Pvperp]]          (Financial Library.ana)
 +
* [[QpDefine]]
 +
* [[Q_infromrec]]
 +
* [[Q_makerect]]
 +
* [[Q_squareinterp]]
 +
* [[Radians]]
 +
* [[Random]]
 +
* [[Rank]]
 +
* [[RankCorrel]]
 +
* [[Rate]]
 +
* [[Rayleigh]]        (Distribution variations.ana)
 +
* [[Re]]              (Complex Library.ana)
 +
* [[ReadCsvFile]]      (Flat File Library.ana)
 +
* [[ReadFromUrl]]
 +
* [[ReadImageFile]]
 +
* [[ReadTextFile]]
 +
* [[RealPart]]
 +
* [[Reference Operator::\|Reference Operator: \X]] : Return a reference to X
 +
* [[Reform]]
 +
* [[Regression]]
 +
* [[RegressionDist]]      (Multivariate Distributions.ana)
 +
* [[RegressionFitProb]]    (Multivariate Distributions.ana)
 +
* [[RegressionNoise]]      (Multivariate Distributions.ana)
 +
* [[ReThrow]]
 +
* [[Round]]
 +
* [[RunConsoleProcess]]
 +
* [[Sample]]
 +
* [[SampleCorrelation]]    (Multivariate Distributions.ana)
 +
* [[SampleCovariance]]    (Multivariate Distributions.ana)
 +
* [[SaveExcelWorkbook]]  -- deprecated: use [[SpreadsheetSave]]
 +
* [[ScanAttFromModelFile]]
 +
* [[SchedulePublish]]
 +
* [[SDeviation]]
 +
 +
== Set functions ==
 +
* [[SetContains]]
 +
* [[SetDifference]]
 +
* [[SetEvaluationFlag]]
 +
* [[SetIntersection]]
 +
* [[SetUnion]]
 +
 +
 +
* [[ShowPdfFile]]
 +
 +
* [[Shuffle]]
 +
* [[Sign]]
 +
* [[Trig Functions| Sin]]
 +
* [[SingularValueDecomp]]
 +
* [[Trig Functions| Sinh]]
 +
* [[SipDecode]]
 +
* [[SipEncode]]
 +
* [[Size]]
 +
* [[Skewness]]
 +
* [[Slice]]
 +
* [[Subscript/Slice Operator| Slice Operator: [@I=n] ]]
 +
* [[Smooth_Fractile]]    (Distribution variations.ana)
 +
* [[SobolSequence]]
 +
* [[Solve]]              (Optimization Functions.ana)
 +
* [[SolverInfo]]
 +
* [[Sort]]
 +
* [[SortIndex]]
 +
* [[Split]]
 +
== Spreadsheet functions ==
 +
* [[SpreadsheetCell]]
 +
* [[SpreadsheetInfo]]
 +
* [[SpreadsheetOpen]]
 +
* [[SpreadsheetRange]]
 +
* [[SpreadsheetSave]]
 +
* [[SpreadsheetSetCell]]
 +
* [[SpreadsheetSetInfo]]
 +
* [[SpreadsheetSetRange]]
 +
* [[SqlDriverInfo]]
 +
* [[Sqr]]
 +
* [[Sqrt]]
 +
* [[Statistics]]
 +
* [[StepInterp]]
 +
* [[StringLength]]
 +
* [[StringLowercase]]
 +
* [[StringMixedCase]]
 +
* [[StringReplace]]
 +
* [[StringUpperCase]]
 +
* [[StudentT]]
 +
* [[SubFindString]]
 +
* [[SubIndex]]
 +
* [[Subset]]
 +
* [[SubString]]
 +
* [[SubTable]]
 +
* [[Sum]]
 +
* [[Sys_coordindex]]
 +
* [[Sys_localindex]]
 +
* [[Table]]
 +
* [[Trig Functions| Tan]]
 +
* [[Trig Functions| Tanh]]
 +
* [[TestHeapConsistency]]
 +
 +
 +
 +
* [[Today]]
 +
 +
 +
* [[Triangular_10_50_90]]  (Distribution Variations.ana)
 +
* [[Triangular_10_mode_90]] (Distribution Variations.ana)
 +
 +
* [[Try]]
 +
* [[Data_Type_Functions#Function_TypeOf| TypeOf]]
 +
* [[Uncumulate]]
 +
* [[Uniform]]
 +
* [[UniformSpherical]]    (Multivariate distributions.ana)
 +
* [[Unique]]
 +
 +
* [[Variance]]
 +
* [[VarTerm]]
 +
* [[Wacc]]              (Financial Library.ana)
 +
* [[Wald]]              (Distribution Variations.ana)
 +
* [[Warp_Dist]]          (Distribution variations.ana)
 +
* [[Weibull]]
 +
 +
 +
* [[Wilcoxon]]
 +
* [[Wishart]]            (Distribution variations.ana)
 +
* [[WorksheetCell]]  -- deprecated: use [[SpreadsheetCell]]
 +
* [[WorksheetRange]] -- deprecated: use [[SpreadsheetRange]]
 +
* [[WriteCsvFile]]      (Flat file library.ana)
 +
* [[WriteTableSql]]      (ODBC Library.ana)
 +
* [[WriteTextFile]]
 +
* [[WriteWorksheetCell]] -- deprecated: use [[SpreadsheetSetCell]]
 +
* [[WriteWorksheetRange]] -- deprecated: use [[SpreadsheetSetRange]]
 +
* [[XIrr]]
 +
* [[XNpv]]
 +
* [[YearFrac]]

Revision as of 03:04, 31 July 2015

Function list (to be categorized) (Back to Analytica Reference)

See also: functions by category.

Operators

Constructs and loops

Mathematics

=Basic math

=Trig functions

Probability distributions

Custom distribution functions

Discrete distribution functions


Continuous distribution functions

  • BiNormal (Multivariate distributions.ana)

Functions that return an Index

Text functions

Array functions

= Array-reducing functions

Tables and functions to make arrays



User interaction and dialog functions

Type conversion functions


Obscure and deprecated functions


Complex number functions




COM functions

Database functions

Matrix functions


Sensitivity analysis

Special functions


Optimizer functions

  • Pareto (Distribution Variations.ana)

Set functions


Spreadsheet functions




Comments


You are not allowed to post comments.