Difference between revisions of "Alphabetical Function List"

(Added functions from several libraries)
(More library functions)
Line 22: Line 22:
 
* Betai
 
* Betai
 
* Binomial
 
* Binomial
 +
* BiNormal    (Multivariate distributions.ana)
 
* Calloption  (Financial Library.ana)
 
* Calloption  (Financial Library.ana)
 
* Capm        (Financial Library.ana)
 
* Capm        (Financial Library.ana)
Line 28: Line 29:
 
* Certain
 
* Certain
 
* Chancedist
 
* Chancedist
 +
* Change_index        (Expand Index.ana)
 
* Chisquared
 
* Chisquared
 
* Choice
 
* Choice
Line 39: Line 41:
 
* Condmin
 
* Condmin
 
* Copyindex
 
* Copyindex
 +
* Correlate_Dists    (Multivariate Distributions.ana)
 +
* Correlate_With      (Multivariate Distributions.ana)
 
* Correlation
 
* Correlation
 
* Cos
 
* Cos
Line 60: Line 64:
 
* Determinant
 
* Determinant
 
* Determtable
 
* Determtable
 +
* Dirichlet      (Multivariate distributions.ana)
 
* Dotproduct
 
* Dotproduct
 
* Dydx
 
* Dydx
Line 86: Line 91:
 
* Gammai
 
* Gammai
 
* Gammaiinv
 
* Gammaiinv
 +
* Gaussian              (Multivariate Distributions.ana)
 
* Geometric
 
* Geometric
 
* Getfract
 
* Getfract
 
* Getregistryvalue
 
* Getregistryvalue
 
* Getvariablebyname
 
* Getvariablebyname
 +
* GoalSeek              (Optimization Functions.ana)
 +
* Gradient              (Optimization Functions.ana)
 
* Hypergeometric
 
* Hypergeometric
 
* Idensubscript
 
* Idensubscript
Line 101: Line 109:
 
* Indexlocal
 
* Indexlocal
 
* Indexnames
 
* Indexnames
 +
* InsertRecSql      (ODBC Library.ana)
 
* Integrate
 
* Integrate
 
* Inverse_Gaussian  (Distribution Variations.ana)
 
* Inverse_Gaussian  (Distribution Variations.ana)
Line 153: Line 162:
 
* Monocubicinterp
 
* Monocubicinterp
 
* Msgbox
 
* Msgbox
 +
* Multinomial              (Distribution variations.ana)
 +
* Multiuniform            (Distribution variations.ana)
 
* Nan
 
* Nan
 
* NegBinomial              (Distribution Variations.ana)
 
* NegBinomial              (Distribution Variations.ana)
Line 197: Line 208:
 
* Runconsoleprocess
 
* Runconsoleprocess
 
* Sample
 
* Sample
 +
* Sample_Correlation    (Distribution variations.ana)
 +
* Sample_Covariance    (Distribution variations.ana)
 
* Schedulepublish
 
* Schedulepublish
 
* Sdeviation
 
* Sdeviation
Line 211: Line 224:
 
* Slice
 
* Slice
 
* Smooth_Fractile    (Distribution variations.ana)
 
* Smooth_Fractile    (Distribution variations.ana)
 +
* Solve              (Optimization Functions.ana)
 
* Solverinfo
 
* Solverinfo
 
* Sortindex
 
* Sortindex
Line 250: Line 264:
 
* Uncumulate
 
* Uncumulate
 
* Uniform
 
* Uniform
 +
* Uniform_Spherical    (Multivariate distributions.ana)
 
* Unique
 
* Unique
 
* Usinglocal
 
* Usinglocal
Line 262: Line 277:
 
* While
 
* While
 
* WriteCsvFile      (Flat file library.ana)
 
* WriteCsvFile      (Flat file library.ana)
 +
* WriteTableSql      (ODBC Library.ana)
 
* Writetextfile
 
* Writetextfile
 
* Xirr
 
* Xirr
 
* Xnpv
 
* Xnpv

Revision as of 00:11, 23 January 2007

(Back to Ana:Analyica Reference)

  • Abs
  • Arccos
  • Arcsin
  • Arctan
  • Arctan2
  • Area
  • Argmax
  • Argmin
  • Array
  • Asc
  • Askmsgchoice
  • Askmsgnumber
  • Askmsgtext
  • Attribget
  • Average
  • Bernoulli
  • Beta
  • Beta_m_sd (Distribution variations.ana)
  • Betafn
  • Betai
  • Binomial
  • BiNormal (Multivariate distributions.ana)
  • Calloption (Financial Library.ana)
  • Capm (Financial Library.ana)
  • Cdf
  • Ceil
  • Certain
  • Chancedist
  • Change_index (Expand Index.ana)
  • Chisquared
  • Choice
  • Chr
  • Coerce_to_Numeric (Flat file library.ana)
  • Combinations
  • Concat
  • Concat<N> (Concatenation UDFs.ana)
  • ConcatRows (Concatenation UDFs.ana)
  • Condmax
  • Condmin
  • Copyindex
  • Correlate_Dists (Multivariate Distributions.ana)
  • Correlate_With (Multivariate Distributions.ana)
  • Correlation
  • Cos
  • Cosh
  • Costcapme (Financial Library.ana)
  • Costcapmm (Financial library.ana)
  • Cubicinterp
  • Cumdist
  • Cumipmt
  • Cumnormal
  • Cumnormalinv
  • Cumprinc
  • Cumproduct
  • Cumulate
  • Currentdatadirectory
  • Currentmodeldirector
  • Dateadd
  • Datepart
  • Decompose
  • Degrees
  • Determinant
  • Determtable
  • Dirichlet (Multivariate distributions.ana)
  • Dotproduct
  • Dydx
  • Dynamic
  • Eigendecomp
  • Elasticity
  • Erf
  • Erfinv
  • Erlang (Distribution variations.ana)
  • Error
  • Evaluate
  • Evaluatescript
  • Exp
  • Exponential
  • Factorial
  • Findintext
  • Floor
  • Forlocal
  • Fractiles
  • Frequency
  • Functionof
  • Fv
  • Gamma
  • Gamma_m_sd (Distribution Variations.ana)
  • Gammafn
  • Gammai
  • Gammaiinv
  • Gaussian (Multivariate Distributions.ana)
  • Geometric
  • Getfract
  • Getregistryvalue
  • Getvariablebyname
  • GoalSeek (Optimization Functions.ana)
  • Gradient (Optimization Functions.ana)
  • Hypergeometric
  • Idensubscript
  • Identpred
  • If0
  • Ifpos
  • Ignorewarnings
  • Implied_volatility_c (Financial library.ana)
  • Implied_volatility_p (Financial library.ana)
  • Indexesof
  • Indexlocal
  • Indexnames
  • InsertRecSql (ODBC Library.ana)
  • Integrate
  • Inverse_Gaussian (Distribution Variations.ana)
  • Invert
  • InvLogit (Generalized Regression.ana)
  • Ipmt
  • Irr
  • Isnan
  • Isnotspecified
  • Isnumber
  • Isreference
  • Istext
  • Isundef
  • Iterate
  • Join
  • Jointext
  • Kurtosis
  • Lgamma
  • Linearinterp
  • Ln
  • Logistic
  • Logistic_Regression (Generalized Regression.ana)
  • Logit (Generalized Regression.ana)
  • Lognormal
  • Lognormal_m_sd (Distribution variations.ana)
  • Logten
  • Lorenzian (Distribution variations.ana)
  • Lpdefine
  • Lpfindiis
  • Lpobjsa
  • Lpopt
  • Lpread
  • Lpreducedcost
  • Lprhssa
  • Lpshadow
  • Lpslack
  • Lpsolution
  • Lpstatusnum
  • Lpstatustext
  • Lpwrite
  • Lpwriteiis
  • Makedate
  • Matrixmultiply
  • Max
  • Mdarraytotable
  • Mdtable
  • Mean
  • Memoryinuseby
  • Mid
  • Min
  • Mod
  • Monocubicinterp
  • Msgbox
  • Multinomial (Distribution variations.ana)
  • Multiuniform (Distribution variations.ana)
  • Nan
  • NegBinomial (Distribution Variations.ana)
  • Nlpdefine
  • Normal
  • Normalize
  • Nper
  • Npv
  • Pareto (Distribution Variations.ana)
  • ParseDate (Flat file library.ana)
  • ParseNum (Flat file library.ana)
  • Pdf
  • Permutations
  • Pert (Distribution Variations.ana)
  • Pmt
  • Poisson
  • Positioninindex
  • Ppmt
  • Probability
  • Probbands
  • Probdist
  • Probit_Regression (Generalized Regression.ana)
  • Probtable
  • 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)
  • ReadCsvFile (Flat File Library.ana)
  • Readtextfile
  • Reform
  • Regression
  • Round
  • Runconsoleprocess
  • Sample
  • Sample_Correlation (Distribution variations.ana)
  • Sample_Covariance (Distribution variations.ana)
  • Schedulepublish
  • Sdeviation
  • Selecttext
  • Sequence
  • Showpdffile
  • Showprogressbar
  • Shuffle
  • Sin
  • Singularvaluedecomp
  • Sinh
  • Size
  • Skewness
  • Slice
  • Smooth_Fractile (Distribution variations.ana)
  • Solve (Optimization Functions.ana)
  • Solverinfo
  • Sortindex
  • Split
  • Splittext
  • Sqr
  • Sqrt
  • Statistics
  • Stepinterp
  • Stringlength
  • Stringlowercase
  • Stringmixedcase
  • Stringreplace
  • Stringuppercase
  • Studentt
  • Subfindstring
  • Subindex
  • Subscript
  • Subset
  • Substring
  • Subtable
  • Sum
  • Sys_coordindex
  • Sys_localindex
  • Table
  • Tan
  • Tanh
  • Testheapconsistency
  • Textlength
  • Textlowercase
  • Textreplace
  • Textsentencecase
  • Textuppercase
  • Today
  • Transpose
  • Triangular
  • Truncate
  • Typeof
  • Uncumulate
  • Uniform
  • Uniform_Spherical (Multivariate distributions.ana)
  • Unique
  • Usinglocal
  • Variance
  • Varterm
  • Wacc (Financial Library.ana)
  • Wald (Distribution Variations.ana)
  • Warp_Dist (Distribution variations.ana)
  • Weibull
  • Whatif
  • Whatifall
  • While
  • WriteCsvFile (Flat file library.ana)
  • WriteTableSql (ODBC Library.ana)
  • Writetextfile
  • Xirr
  • Xnpv
Comments


You are not allowed to post comments.