Difference between revisions of "Functions by category"

(new page)
m
Line 5: Line 5:
  
 
See also: [[:Category:Functions|functions by category]].
 
See also: [[:Category:Functions|functions by category]].
 +
[[Functions to be organized]]
 +
[[Rare and deprecated functions]]
  
 
== Operators ==
 
== Operators ==
Line 138: Line 140:
 
* [[ParseDate]]
 
* [[ParseDate]]
 
* [[ParseNumber]]
 
* [[ParseNumber]]
 +
* [[ShowPdfFile]]
  
 +
== Spreadsheet functions ==
 +
* [[SpreadsheetCell]]
 +
* [[SpreadsheetInfo]]
 +
* [[SpreadsheetOpen]]
 +
* [[SpreadsheetRange]]
 +
* [[SpreadsheetSave]]
 +
* [[SpreadsheetSetCell]]
 +
* [[SpreadsheetSetInfo]]
 +
* [[SpreadsheetSetRange]]
  
 
== Obscure and deprecated functions ==
 
== Obscure and deprecated functions ==
Line 262: Line 274:
 
* [[Determinant]]
 
* [[Determinant]]
 
* [[Transpose]]
 
* [[Transpose]]
 +
 +
== Set functions ==
 +
* [[SetContains]]
 +
* [[SetDifference]]
 +
* [[SetEvaluationFlag]]
 +
* [[SetIntersection]]
 +
* [[SetUnion]]
 +
  
  
Line 469: Line 489:
 
* [[OptWrite]]
 
* [[OptWrite]]
 
* [[OptWriteIIS]]
 
* [[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 04:48, 31 July 2015

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

See also: functions by category. Functions to be organized Rare and deprecated functions

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

Spreadsheet functions

Obscure and deprecated functions


Complex number functions




COM functions

Database functions

Matrix functions

Set functions


Sensitivity analysis

Special functions


Optimizer functions

Comments


You are not allowed to post comments.