Difference between revisions of "Manuals/calci/ALL"

From ZCubes Wiki
Jump to navigation Jump to search
 
(17 intermediate revisions by 4 users not shown)
Line 1: Line 1:
==LIST OF ALL FUNCTIONS==
+
 
 +
==Array Specific Member Functions==
 +
[[Z^3 Array Manipulation Member Functions|Array Member Functions]]
 +
 
 +
==LIST OF SELECTED FUNCTIONS==
 
===Statistical Functions===
 
===Statistical Functions===
 
*[[Manuals/calci/AVEDEV | AVEDEV  ]]
 
*[[Manuals/calci/AVEDEV | AVEDEV  ]]
 
*[[Manuals/calci/AVERAGE | AVERAGE  ]]
 
*[[Manuals/calci/AVERAGE | AVERAGE  ]]
 
*[[Manuals/calci/AVERAGEA | AVERAGEA  ]]
 
*[[Manuals/calci/AVERAGEA | AVERAGEA  ]]
 +
*[[Manuals/calci/Bartlett%27sTest | Bartlett's Test ]]
 
*[[Manuals/calci/BERNOULLI | BERNOULLI  ]]
 
*[[Manuals/calci/BERNOULLI | BERNOULLI  ]]
 
*[[Manuals/calci/BETADIST | BETADIST  ]]
 
*[[Manuals/calci/BETADIST | BETADIST  ]]
Line 107: Line 112:
 
*[[Manuals/calci/KRUSKALWALLISTEST | KRUSKALWALLISTEST ]]
 
*[[Manuals/calci/KRUSKALWALLISTEST | KRUSKALWALLISTEST ]]
 
*[[Manuals/calci/SIGNTEST | SIGNTEST ]]
 
*[[Manuals/calci/SIGNTEST | SIGNTEST ]]
*[[Manuals/calci/BINOMIALPROBABILTY | BINOMIALPROBABILTY ]]
+
*[[Manuals/calci/STATS | STATS ]]
*[[Manuals/calci/FRIEDMAN | FRIEDMAN ]]
+
*[[Manuals/calci/BINOMIALPROBABILITY | BINOMIALPROBABILITY ]]
 +
*[[Manuals/calci/FRIEDMANTEST | FRIEDMANTEST ]]
 
*[[Manuals/calci/MOODSMEDIANTEST | MOODSMEDIANTEST ]]
 
*[[Manuals/calci/MOODSMEDIANTEST | MOODSMEDIANTEST ]]
 
*[[Manuals/calci/KSTESTNORMAL | KSTESTNORMAL ]]
 
*[[Manuals/calci/KSTESTNORMAL | KSTESTNORMAL ]]
Line 130: Line 136:
 
===Date and Time===
 
===Date and Time===
 
*[[Manuals/calci/DATE | DATE  ]]
 
*[[Manuals/calci/DATE | DATE  ]]
*[[Manuals/calci/datevalue | datevalue ]]
+
*[[Manuals/calci/DATEVALUE | DATEVALUE ]]
 
*[[Manuals/calci/DAY | DAY  ]]
 
*[[Manuals/calci/DAY | DAY  ]]
 
*[[Manuals/calci/DAYS360 | DAYS360  ]]
 
*[[Manuals/calci/DAYS360 | DAYS360  ]]
Line 173: Line 179:
 
*[[Manuals/calci/IMARGUMENT | IMARGUMENT  ]]
 
*[[Manuals/calci/IMARGUMENT | IMARGUMENT  ]]
 
*[[Manuals/calci/IMCONJUGATE | IMCONJUGATE  ]]
 
*[[Manuals/calci/IMCONJUGATE | IMCONJUGATE  ]]
 +
*[[Manuals/calci/IMCOS | IMCOS  ]]
 
*[[Manuals/calci/IMDIV | IMDIV  ]]
 
*[[Manuals/calci/IMDIV | IMDIV  ]]
 
*[[Manuals/calci/IMEXP | IMEXP  ]]
 
*[[Manuals/calci/IMEXP | IMEXP  ]]
Line 181: Line 188:
 
*[[Manuals/calci/IMPRODUCT | IMPRODUCT  ]]
 
*[[Manuals/calci/IMPRODUCT | IMPRODUCT  ]]
 
*[[Manuals/calci/IMREAL | IMREAL  ]]
 
*[[Manuals/calci/IMREAL | IMREAL  ]]
 +
*[[Manuals/calci/IMSIN | IMSIN  ]]
 
*[[Manuals/calci/IMSQRT | IMSQRT  ]]
 
*[[Manuals/calci/IMSQRT | IMSQRT  ]]
 
*[[Manuals/calci/IMSUB | IMSUB  ]]
 
*[[Manuals/calci/IMSUB | IMSUB  ]]
Line 189: Line 197:
  
 
===Financial===
 
===Financial===
*[[Manuals/calci/ACCRINT | ACCRINT  ]]
+
*[[Manuals/calci/ACCRINT | ACCRINT ]]
*[[Manuals/calci/AMORDEGRC | AMORDEGRC  ]]
+
*[[Manuals/calci/accrintm  | accrintm ]]
*[[Manuals/calci/AMORLINC | AMORLINC  ]]
+
*[[Manuals/calci/AMORDEGRC   | AMORDEGRC  ]]
*[[Manuals/calci/COUPDAYBS | COUPDAYBS  ]]
+
*[[Manuals/calci/AMORLINC | AMORLINC  ]]
*[[Manuals/calci/COUPDAYS | COUPDAYS ]]
+
*[[Manuals/calci/COUPDAYBS   | COUPDAYBS  ]]
*[[Manuals/calci/COUPDAYSNC | COUPDAYSNC  ]]
+
*[[Manuals/calci/COUPDAYS   | COUPDAYS   ]]
*[[Manuals/calci/COUPNUM | COUPNUM  ]]
+
*[[Manuals/calci/COUPDAYSNC   | COUPDAYSNC ]]
*[[Manuals/calci/DDB | DDB  ]]
+
*[[Manuals/calci/coupncd  |coupncd ]]
*[[Manuals/calci/DISC | DISC  ]]
+
*[[Manuals/calci/COUPNUM | COUPNUM ]]
*[[Manuals/calci/DOLLARDE | DOLLARDE  ]]
+
*[[Manuals/calci/couppcd  | couppcd  ]]
*[[Manuals/calci/DOLLARFR | DOLLARFR  ]]
+
*[[Manuals/calci/cumipmt| cumipmt]]
*[[Manuals/calci/EFFECT | EFFECT  ]]
+
*[[Manuals/calci/cumprinc  | cumprinc  ]]
*[[Manuals/calci/INTRATE | INTRATE  ]]
+
*[[Manuals/calci/db  | db ]]
*[[Manuals/calci/IPMT | IPMT  ]]
+
*[[Manuals/calci/DDB   | DDB  ]]
*[[Manuals/calci/ISPMT | ISPMT ]]
+
*[[Manuals/calci/DISC | DISC ]]
*[[Manuals/calci/LOGEST | LOGEST ]]
+
*[[Manuals/calci/DOLLAR  | DOLLAR ]]
*[[Manuals/calci/MDURATION | MDURATION  ]]
+
*[[Manuals/calci/DOLLARDE   | DOLLARDE  ]]
*[[Manuals/calci/PRICE | PRICE ]]
+
*[[Manuals/calci/DOLLARFR   | DOLLARFR ]]
*[[Manuals/calci/PRICEDISC | PRICEDISC ]]
+
*[[Manuals/calci/DURATION  |DURATION ]]
*[[Manuals/calci/PRICEMAT | PRICEMAT ]]
+
*[[Manuals/calci/EFFECT | EFFECT ]]
*[[Manuals/calci/RATE | RATE ]]
+
*[[Manuals/calci/FV  | FV ]]
*[[Manuals/calci/RECEIVED | RECEIVED  ]]
+
*[[Manuals/calci/FVSCHEDULE | FVSCHEDULE]]
*[[Manuals/calci/ODDLPRICE | ODDLPRICE ]]
+
*[[Manuals/calci/INTRATE   | INTRATE  ]]
 +
*[[Manuals/calci/IPMT   | IPMT ]]
 +
*[[Manuals/calci/IRR  | IRR ]]
 +
*[[Manuals/calci/ISPMT |ISPMT]]
 +
*[[Manuals/calci/LOGEST   | LOGEST   ]]
 +
*[[Manuals/calci/MDURATION   | MDURATION ]]
 +
*[[Manuals/calci/MIRR  | MIRR ]]
 +
*[[Manuals/calci/NOMINAL  |NOMINAL ]]
 +
*[[Manuals/calci/NPER  | NPER ]]
 +
*[[Manuals/calci/NPV  | NPV ]]
 +
*[[Manuals/calci/ODDFPRICE  | ODDFPRICE ]]
 +
*[[Manuals/calci/ODDFYIELD  | ODDFYIELD ]]
 +
*[[Manuals/calci/ODDLPRICE | ODDLPRICE ]]
 +
*[[Manuals/calci/ODDLYIELD | ODDLYIELD]]
 +
*[[Manuals/calci/PMT | PMT ]]
 +
*[[Manuals/calci/PPMT  |PPMT ]]
 +
*[[Manuals/calci/PRICE    | PRICE  ]]
 +
*[[Manuals/calci/PRICEDISC  | PRICEDISC  ]]
 +
*[[Manuals/calci/PRICEMAT  | PRICEMAT  ]]
 
*[[Manuals/calci/PV | PV ]]
 
*[[Manuals/calci/PV | PV ]]
*[[Manuals/calci/IRR | IRR ]]
+
*[[Manuals/calci/RATE  | RATE  ]]
*[[Manuals/calci/ODDFPRICE | ODDFPRICE ]]
+
*[[Manuals/calci/RECEIVED  | RECEIVED  ]]
*[[Manuals/calci/ODDFYIELD | ODDFYIELD ]]
+
*[[Manuals/calci/SLN  | SLN ]]
*[[Manuals/calci/ODDLYIELD | ODDLYIELD ]]
+
*[[Manuals/calci/SYD  | SYD ]]
*[[Manuals/calci/SYD | SYD ]]
+
*[[Manuals/calci/TBILLEQ  | TBILLEQ ]]
*[[Manuals/calci/PMT | PMT ]]
+
*[[Manuals/calci/TBILLPRICE  | TBILLPRICE ]]
*[[Manuals/calci/PPMT | PPMT ]]
+
*[[Manuals/calci/TBILLYIELD  | TBILLYIELD ]]
*[[Manuals/calci/NPV | NPV ]]
+
*[[Manuals/calci/VDB  | VDB ]]
*[[Manuals/calci/NPER | NPER ]]
+
*[[Manuals/calci/XIRR  | XIRR ]]
*[[Manuals/calci/NOMINAL | NOMINAL ]]
+
*[[Manuals/calci/XNPV  | XNPV ]]
*[[Manuals/calci/MIRR | MIRR ]]
+
*[[Manuals/calci/YIELD  | YIELD ]]
 +
*[[Manuals/calci/YIELDDISC  | YIELDDISC ]]
 +
*[[Manuals/calci/YIELDMAT  | YIELDMAT ]]
  
 
===Geometry===
 
===Geometry===
Line 287: Line 315:
 
*[[Manuals/calci/COTAN | COTAN  ]]
 
*[[Manuals/calci/COTAN | COTAN  ]]
 
*[[Manuals/calci/COTH | COTH  ]]
 
*[[Manuals/calci/COTH | COTH  ]]
 +
*[[Manuals/calci/CSCH | CSCH  ]]
 
*[[Manuals/calci/DEGREES | DEGREES  ]]
 
*[[Manuals/calci/DEGREES | DEGREES  ]]
 
*[[Manuals/calci/EVEN | EVEN  ]]
 
*[[Manuals/calci/EVEN | EVEN  ]]
Line 322: Line 351:
 
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN  ]]
 
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN  ]]
 
*[[Manuals/calci/ROUNDUP | ROUNDUP  ]]
 
*[[Manuals/calci/ROUNDUP | ROUNDUP  ]]
 +
*[[Manuals/calci/SEC | SEC  ]]
 +
*[[Manuals/calci/SECH | SECH  ]]
 
*[[Manuals/calci/SERIESSUM | SERIESSUM  ]]
 
*[[Manuals/calci/SERIESSUM | SERIESSUM  ]]
 
*[[Manuals/calci/SIGN | SIGN  ]]
 
*[[Manuals/calci/SIGN | SIGN  ]]
 +
*[[Manuals/calci/SIN | SIN  ]]
 +
*[[Manuals/calci/SINH | SINH  ]]
 
*[[Manuals/calci/SQRT | SQRT  ]]
 
*[[Manuals/calci/SQRT | SQRT  ]]
 
*[[Manuals/calci/SQRTPI | SQRTPI  ]]
 
*[[Manuals/calci/SQRTPI | SQRTPI  ]]
Line 334: Line 367:
 
*[[Manuals/calci/SUMX2PY2 | SUMX2PY2  ]]
 
*[[Manuals/calci/SUMX2PY2 | SUMX2PY2  ]]
 
*[[Manuals/calci/SUMXMY2 | SUMXMY2  ]]
 
*[[Manuals/calci/SUMXMY2 | SUMXMY2  ]]
 +
*[[Manuals/calci/TAN| TAN ]]
 +
*[[Manuals/calci/TANH | TANH  ]]
 
*[[Manuals/calci/TRUNC | TRUNC  ]]
 
*[[Manuals/calci/TRUNC | TRUNC  ]]
 
*[[Manuals/calci/VECTOR | VECTOR  ]]
 
*[[Manuals/calci/VECTOR | VECTOR  ]]
Line 345: Line 380:
 
*[[Manuals/calci/EXACT | EXACT  ]]
 
*[[Manuals/calci/EXACT | EXACT  ]]
 
*[[Manuals/calci/FIND | FIND  ]]
 
*[[Manuals/calci/FIND | FIND  ]]
 +
*[[Manuals/calci/FINDB | FINDB  ]]
 
*[[Manuals/calci/FIXED | FIXED  ]]
 
*[[Manuals/calci/FIXED | FIXED  ]]
 
*[[Manuals/calci/LEFT | LEFT  ]]
 
*[[Manuals/calci/LEFT | LEFT  ]]
Line 366: Line 402:
 
*[[Manuals/calci/UPPER | UPPER  ]]
 
*[[Manuals/calci/UPPER | UPPER  ]]
 
*[[Manuals/calci/VALUE | VALUE  ]]
 
*[[Manuals/calci/VALUE | VALUE  ]]
 +
 +
===Matrix Functions===
 +
*[[Manuals/calci/ANTIDIAGONAL | ANTIDIAGONAL  ]]
 +
*[[Manuals/calci/ANTISYMMETRIC | ANTISYMMETRIC  ]]
 +
*[[Manuals/calci/ARROWHEAD | ARROWHEAD  ]]
 +
*[[Manuals/calci/BIDIAGONAL | BIDIAGONAL  ]]
 +
*[[Manuals/calci/BLOCKDIAGONAL | BLOCKDIAGONAL  ]]
 +
*[[Manuals/calci/CENTROSYMMETRIC | CENTROSYMMETRIC  ]]
 +
*[[Manuals/calci/CHOLESKY | CHOLESKY  ]]
 +
*[[Manuals/calci/CIRCULANT | CIRCULANT  ]]
 +
*[[Manuals/calci/CONFERENCE | CONFERENCE  ]]
 +
*[[Manuals/calci/EXCHANGE | EXCHANGE  ]]
 +
*[[Manuals/calci/FROBENIUS | FROBENIUS  ]]
 +
*[[Manuals/calci/HADAMARD | HADAMARD  ]]
 +
*[[Manuals/calci/HANKEL | HANKEL  ]]
 +
*[[Manuals/calci/HERMITIAN | HERMITIAN  ]]
 +
*[[Manuals/calci/HESSENBERG | HESSENBERG  ]]
 +
*[[Manuals/calci/HILBERT | HILBERT  ]]
 +
*[[Manuals/calci/HOLLOW | HOLLOW  ]]
 +
*[[Manuals/calci/IDEMPOTENT | IDEMPOTENT  ]]
 +
*[[Manuals/calci/IDENTITY | IDENTITY  ]]
 +
*[[Manuals/calci/INTEGER | INTEGER  ]]
 +
*[[Manuals/calci/LEHMER | LEHMER  ]]
 +
*[[Manuals/calci/MATRIXOPERATORS | MATRIXOPERATORS  ]]
 +
*[[Manuals/calci/METZLER | METZLER  ]]
 +
*[[Manuals/calci/MONOMIAL | MONOMIAL  ]]
 +
*[[Manuals/calci/MOORE | MOORE  ]]
 +
*[[Manuals/calci/NEGZEROPOS | NEGZEROPOS  ]]
 +
*[[Manuals/calci/PASCAL | PASCAL  ]]
 +
*[[Manuals/calci/PENTADIAGONAL | PENTADIAGONAL  ]]
 +
*[[Manuals/calci/PERMUTATION | PERMUTATION  ]]
 +
*[[Manuals/calci/PERSYMMETRIC | PERSYMMETRIC  ]]
 +
*[[Manuals/calci/REDHEFFER | REDHEFFER  ]]
 +
*[[Manuals/calci/SHIFT | SHIFT  ]]
 +
*[[Manuals/calci/SIGNATURE | SIGNATURE  ]]
 +
*[[Manuals/calci/SYMMETRIC | SYMMETRIC  ]]
 +
*[[Manuals/calci/TOEPLITZ | TOEPLITZ  ]]
 +
*[[Manuals/calci/TRIANGULAR | TRIANGULAR  ]]
 +
*[[Manuals/calci/TRIDIAGONAL | TRIDIAGONAL  ]]
 +
*[[Manuals/calci/VANDERMONDE | VANDERMONDE  ]]
  
 
===Other Functions===
 
===Other Functions===

Latest revision as of 09:19, 16 August 2024

Array Specific Member Functions

Array Member Functions

LIST OF SELECTED FUNCTIONS

Statistical Functions

Database and List Management

Date and Time

Engineering

Financial

Geometry

Information

Logical

Lookup and Reference

Math

Text and Data

Matrix Functions

Other Functions