Difference between revisions of "Z API Functions"

From ZCubes Wiki
Jump to navigation Jump to search
 
(71 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
==LIST OF ALL FUNCTIONS==
 
==LIST OF ALL FUNCTIONS==
===STATISTICAL FUNCTIONS1===
+
===Statistical Functions1===
 +
*[[Manuals/calci/Average, AverageA, AverageX Example| Example]]
 +
*[[Manuals/calci/z3console| z3console]]
 +
*[[Manuals/calci/Examples | Examples of Java and z3 programs]]
 +
*[[Manuals/calci/Examples1 | Engineering Examples in z3]]
 +
*[[Manuals/calci/Exampleslp | Linear Programming in z3]]
 
*[[Manuals/calci/AVEDEV | AVEDEV]]
 
*[[Manuals/calci/AVEDEV | AVEDEV]]
 
*[[Manuals/calci/AVERAGE | AVERAGE]]
 
*[[Manuals/calci/AVERAGE | AVERAGE]]
Line 18: Line 23:
 
*[[Manuals/calci/COUNT | COUNT]]
 
*[[Manuals/calci/COUNT | COUNT]]
 
*[[Manuals/calci/COUNTA | COUNTA]]
 
*[[Manuals/calci/COUNTA | COUNTA]]
 +
*[[Manuals/calci/COUNTBLANK | COUNTBLANK]]
 +
*[[Manuals/calci/COUNTIF | COUNTIF]]
 +
*[[Manuals/calci/COVAR | COVAR]]
 +
*[[Manuals/calci/COVARIANCEDATAANALYSIS | COVARIANCEDATAANALYSIS]]
 
*[[Manuals/calci/DECREASING | DECREASING]]
 
*[[Manuals/calci/DECREASING | DECREASING]]
 
*[[Manuals/calci/DECREMENT | DECREMENT]]
 
*[[Manuals/calci/DECREMENT | DECREMENT]]
 
*[[Manuals/calci/DESCRIBENUMBER | DESCRIBENUMBER]]
 
*[[Manuals/calci/DESCRIBENUMBER | DESCRIBENUMBER]]
 
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS]]
 
*[[Manuals/calci/DESCRIPTIVESTATISTICS | DESCRIPTIVESTATISTICS]]
*[[Manuals/calci/COUNTBLANK | COUNTBLANK]]
+
*[[Manuals/calci/DET | DET]]
*[[Manuals/calci/COUNTIF | COUNTIF]]
 
*[[Manuals/calci/COVAR | COVAR]]
 
*[[Manuals/calci/COVARIANCEDATAANALYSIS | COVARIANCEDATAANALYSIS]]
 
*[[Manuals/Manuals/calci/DET | DET]]
 
 
*[[Manuals/calci/DEVSQ | DEVSQ]]
 
*[[Manuals/calci/DEVSQ | DEVSQ]]
 
*[[Manuals/calci/FEQ | FEQ]]
 
*[[Manuals/calci/FEQ | FEQ]]
Line 115: Line 120:
 
*[[Manuals/calci/XBETWEEN | XBETWEEN]]
 
*[[Manuals/calci/XBETWEEN | XBETWEEN]]
  
===STATISTICAL FUNCTIONS2===
+
===Statistical Functions2===
 
*[[Manuals/calci/BERNOULLIDISTRIBUTED | BERNOULLIDISTRIBUTED]]
 
*[[Manuals/calci/BERNOULLIDISTRIBUTED | BERNOULLIDISTRIBUTED]]
 
*[[Manuals/calci/BETADIST | BETADIST]]
 
*[[Manuals/calci/BETADIST | BETADIST]]
Line 168: Line 173:
 
*[[Manuals/calci/SIGNTEST | SIGNTEST]]
 
*[[Manuals/calci/SIGNTEST | SIGNTEST]]
 
*[[Manuals/calci/SKEW | SKEW]]
 
*[[Manuals/calci/SKEW | SKEW]]
*[[Manuals/calci/SKEWSYMMETRIC | SKEWSYMMETRIC]]
 
 
*[[Manuals/calci/STATIC | STATIC]]
 
*[[Manuals/calci/STATIC | STATIC]]
 
*[[Manuals/calci/STATS | STATS]]
 
*[[Manuals/calci/STATS | STATS]]
Line 183: Line 187:
 
*[[Manuals/calci/ZTESTTWOSAMPLEFORMEANS | ZTESTTWOSAMPLEFORMEANS]]
 
*[[Manuals/calci/ZTESTTWOSAMPLEFORMEANS | ZTESTTWOSAMPLEFORMEANS]]
  
===MATH1===
+
===Math1===
 
*[[Manuals/calci/ABS | ABS]]
 
*[[Manuals/calci/ABS | ABS]]
 
*[[Manuals/calci/ACOS | ACOS]]
 
*[[Manuals/calci/ACOS | ACOS]]
 
*[[Manuals/calci/ACOSH | ACOSH]]
 
*[[Manuals/calci/ACOSH | ACOSH]]
*[[Manuals/calci/SUM | ADD]]
+
*[[Manuals/calci/ADD | ADD]]
 
*[[Manuals/calci/ADDBY | ADDBY]]
 
*[[Manuals/calci/ADDBY | ADDBY]]
 
*[[Manuals/calci/ADDCLAUSE | ADDCLAUSE]]
 
*[[Manuals/calci/ADDCLAUSE | ADDCLAUSE]]
Line 210: Line 214:
 
*[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]]
 
*[[Manuals/calci/CARTESIANPRODUCT | CARTESIANPRODUCT]]
 
*[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]]
 
*[[Manuals/calci/CARTESIANPRODUCTWITHOUTFLATTEN | CARTESIANPRODUCTWITHOUTFLATTEN]]
 +
*[[Manuals/calci/CAR | CDR]]
 
*[[Manuals/calci/CEILING | CEILING]]
 
*[[Manuals/calci/CEILING | CEILING]]
 
*[[Manuals/calci/CEILINGAT | CEILINGAT]]
 
*[[Manuals/calci/CEILINGAT | CEILINGAT]]
Line 217: Line 222:
 
*[[Manuals/calci/COMPLEMENT | COMPLEMENT]]
 
*[[Manuals/calci/COMPLEMENT | COMPLEMENT]]
 
*[[Manuals/calci/COS | COS]]
 
*[[Manuals/calci/COS | COS]]
 +
*[[Manuals/calci/COS#Examples | COSExamples]]
 
*[[Manuals/calci/COSEC | COSEC]]
 
*[[Manuals/calci/COSEC | COSEC]]
 
*[[Manuals/calci/COSH | COSH]]
 
*[[Manuals/calci/COSH | COSH]]
Line 404: Line 410:
 
*[[Manuals/calci/SIGN | SIGN]]
 
*[[Manuals/calci/SIGN | SIGN]]
 
*[[Manuals/calci/SIN | SIN]]
 
*[[Manuals/calci/SIN | SIN]]
 +
*[[Manuals/calci/SIN#Examples |SINExamples]]
 
*[[Manuals/calci/SINC | SINC]]
 
*[[Manuals/calci/SINC | SINC]]
 
*[[Manuals/calci/SINCP | SINCP]]
 
*[[Manuals/calci/SINCP | SINCP]]
Line 461: Line 468:
 
*[[Manuals/calci/VECTORPRODUCT | VECTORPRODUCT]]
 
*[[Manuals/calci/VECTORPRODUCT | VECTORPRODUCT]]
  
===MATH2===
+
===Math2===
 
*[[Manuals/calci/ACKERMANN | ACKERMANN]]
 
*[[Manuals/calci/ACKERMANN | ACKERMANN]]
 
*[[Manuals/calci/ADDINS | ADDINS]]
 
*[[Manuals/calci/ADDINS | ADDINS]]
Line 493: Line 500:
 
*[[Manuals/calci/TETRATE | TETRATE]]
 
*[[Manuals/calci/TETRATE | TETRATE]]
  
===DATE AND TIME1===
+
===Date and Time1===
 
*[[Manuals/calci/ADDDATE | ADDDATE]]
 
*[[Manuals/calci/ADDDATE | ADDDATE]]
 +
*[[Manuals/calci/AGINGINDAYS | AGINGINDAYS]]
 
*[[Manuals/calci/CLOCK | CLOCK]]
 
*[[Manuals/calci/CLOCK | CLOCK]]
 
*[[Manuals/calci/CALENDER | CALENDER]]
 
*[[Manuals/calci/CALENDER | CALENDER]]
Line 520: Line 528:
 
*[[Manuals/calci/MINUTE | MINUTE]]
 
*[[Manuals/calci/MINUTE | MINUTE]]
 
*[[Manuals/calci/MONTH | MONTH]]
 
*[[Manuals/calci/MONTH | MONTH]]
 +
*[[Manuals/calci/MOMENT| MOMENT]]
 
*[[Manuals/calci/MONTHEND | MONTHEND]]
 
*[[Manuals/calci/MONTHEND | MONTHEND]]
 
*[[Manuals/calci/MONTHENDLEAP | MONTHENDLEAP]]
 
*[[Manuals/calci/MONTHENDLEAP | MONTHENDLEAP]]
Line 538: Line 547:
 
*[[Manuals/calci/YEARFRAC | YEARFRAC]]
 
*[[Manuals/calci/YEARFRAC | YEARFRAC]]
  
===DATE AND TIME2===
+
===Date and Time2===
 
*[[Manuals/calci/DAYSOFFSETWITHDST | DAYSOFFSETWITHDST]]
 
*[[Manuals/calci/DAYSOFFSETWITHDST | DAYSOFFSETWITHDST]]
 
*[[Manuals/calci/DAYSONMONTHLYBASIS | DAYSONMONTHLYBASIS]]
 
*[[Manuals/calci/DAYSONMONTHLYBASIS | DAYSONMONTHLYBASIS]]
 
*[[Manuals/calci/TIMEVALUE | TIMEVALUE]]
 
*[[Manuals/calci/TIMEVALUE | TIMEVALUE]]
  
===ENGINEERING1===
+
===Engineering1===
 
*[[Manuals/calci/ARGS | ARGS]]
 
*[[Manuals/calci/ARGS | ARGS]]
 
*[[Manuals/calci/ARGSONE | ARGSONE]]
 
*[[Manuals/calci/ARGSONE | ARGSONE]]
Line 601: Line 610:
 
*[[Manuals/calci/UNITSOF | UNITSOF]]
 
*[[Manuals/calci/UNITSOF | UNITSOF]]
  
==ENGINEERING2==
+
===Engineering2===
 
*[[Manuals/calci/BESSELI | BESSELI]]
 
*[[Manuals/calci/BESSELI | BESSELI]]
 
*[[Manuals/calci/BESSELJ | BESSELJ]]
 
*[[Manuals/calci/BESSELJ | BESSELJ]]
Line 607: Line 616:
 
*[[Manuals/calci/BESSELY | BESSELY]]
 
*[[Manuals/calci/BESSELY | BESSELY]]
 
*[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]]
 
*[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]]
==FINANCIAL1==
+
 
 +
===Financial1===
 
*[[Manuals/calci/ACCRINT | ACCRINT]]
 
*[[Manuals/calci/ACCRINT | ACCRINT]]
 
*[[Manuals/calci/AMORLINC | AMORLINC]]
 
*[[Manuals/calci/AMORLINC | AMORLINC]]
Line 657: Line 667:
 
*[[Manuals/calci/USDOLLAR | USDOLLAR]]
 
*[[Manuals/calci/USDOLLAR | USDOLLAR]]
 
*[[Manuals/calci/XNPV | XNPV]]
 
*[[Manuals/calci/XNPV | XNPV]]
==FINANCIAL2==
+
 
 +
===Financial2===
 
*[[Manuals/calci/ACCRINTM | ACCRINTM]]
 
*[[Manuals/calci/ACCRINTM | ACCRINTM]]
 
*[[Manuals/calci/AMORDEGRC | AMORDEGRC]]
 
*[[Manuals/calci/AMORDEGRC | AMORDEGRC]]
Line 678: Line 689:
 
*[[Manuals/calci/YIELDMAT | YIELDMAT]]
 
*[[Manuals/calci/YIELDMAT | YIELDMAT]]
 
*[[Manuals/calci/YMXC | YMXC]]
 
*[[Manuals/calci/YMXC | YMXC]]
==GEOMETRY AND GRAPH1==
+
 
 +
===Geometry and Graph1===
 
*[[Manuals/calci/BARCHART | BARCHART]]
 
*[[Manuals/calci/BARCHART | BARCHART]]
 
*[[Manuals/calci/BARHIERARCHY | BARHIERARCHY]]
 
*[[Manuals/calci/BARHIERARCHY | BARHIERARCHY]]
Line 727: Line 739:
 
*[[Manuals/calci/TRIANGLE | TRIANGLE]]
 
*[[Manuals/calci/TRIANGLE | TRIANGLE]]
 
*[[Manuals/calci/XYPOINT | XYPOINT]]
 
*[[Manuals/calci/XYPOINT | XYPOINT]]
==GEOMETRY AND GRAPH2==
+
 
 +
===Geometry and Graph2===
 
*[[Manuals/calci/BUBBLECHART | BUBBLECHART]]
 
*[[Manuals/calci/BUBBLECHART | BUBBLECHART]]
 
*[[Manuals/calci/CLOSEDCURVE | CLOSEDCURVE]]
 
*[[Manuals/calci/CLOSEDCURVE | CLOSEDCURVE]]
Line 740: Line 753:
 
*[[Manuals/calci/SURFACEGRAPHCORE | SURFACEGRAPHCORE]]
 
*[[Manuals/calci/SURFACEGRAPHCORE | SURFACEGRAPHCORE]]
 
*[[Manuals/calci/TORUS | TORUS]]
 
*[[Manuals/calci/TORUS | TORUS]]
==INFORMATION1==
+
 
 +
===Information1===
 
*[[Manuals/calci/APPLY | APPLY]]
 
*[[Manuals/calci/APPLY | APPLY]]
 
*[[Manuals/calci/APPLYFUNCTIONTOALLELEMENTS | APPLYFUNCTIONTOALLELEMENTS]]
 
*[[Manuals/calci/APPLYFUNCTIONTOALLELEMENTS | APPLYFUNCTIONTOALLELEMENTS]]
Line 787: Line 801:
 
*[[Manuals/calci/ISBOOLEAN | ISBOOLEAN]]
 
*[[Manuals/calci/ISBOOLEAN | ISBOOLEAN]]
 
*[[Manuals/calci/ISCOMPLEX | ISCOMPLEX]]
 
*[[Manuals/calci/ISCOMPLEX | ISCOMPLEX]]
 +
*[[Manuals/calci/ISCOMPOSITE | ISCOMPOSITE]]
 
*[[Manuals/calci/ISELEMENTLIKECOMPLEX | ISELEMENTLIKECOMPLEX]]
 
*[[Manuals/calci/ISELEMENTLIKECOMPLEX | ISELEMENTLIKECOMPLEX]]
 
*[[Manuals/calci/ISEMPTY | ISEMPTY]]
 
*[[Manuals/calci/ISEMPTY | ISEMPTY]]
Line 793: Line 808:
 
*[[Manuals/calci/ISERROR | ISERROR]]
 
*[[Manuals/calci/ISERROR | ISERROR]]
 
*[[Manuals/calci/ISEVEN | ISEVEN]]
 
*[[Manuals/calci/ISEVEN | ISEVEN]]
 +
*[[Manuals/calci/ISFALSE | ISFALSE]]
 
*[[Manuals/calci/ISFUNCTION | ISFUNCTION]]
 
*[[Manuals/calci/ISFUNCTION | ISFUNCTION]]
 
*[[Manuals/calci/ISFUNCTIONSYMBOL | ISFUNCTIONSYMBOL]]
 
*[[Manuals/calci/ISFUNCTIONSYMBOL | ISFUNCTIONSYMBOL]]
 
*[[Manuals/calci/ISIGNOREINDEX | ISIGNOREINDEX]]
 
*[[Manuals/calci/ISIGNOREINDEX | ISIGNOREINDEX]]
 
*[[Manuals/calci/ISINARRAY | ISINARRAY]]
 
*[[Manuals/calci/ISINARRAY | ISINARRAY]]
 +
*[[Manuals/calci/ISINTEGER | ISINTEGER]]
 +
*[[Manuals/calci/ISINTEGER#Safe_Integer | Safe Integer]]
 
*[[Manuals/calci/ISLAMBDAEQUATION | ISLAMBDAEQUATION]]
 
*[[Manuals/calci/ISLAMBDAEQUATION | ISLAMBDAEQUATION]]
 
*[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR]]
 
*[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR]]
Line 824: Line 842:
 
*[[Manuals/calci/ISSUPERSET | ISSUPERSET]]
 
*[[Manuals/calci/ISSUPERSET | ISSUPERSET]]
 
*[[Manuals/calci/ISTEXT | ISTEXT]]
 
*[[Manuals/calci/ISTEXT | ISTEXT]]
 +
*[[Manuals/calci/ISTRUE | ISTRUE]]
 
*[[Manuals/calci/ISVECTOR | ISVECTOR]]
 
*[[Manuals/calci/ISVECTOR | ISVECTOR]]
 
*[[Manuals/calci/ISVECTORSIZE | ISVECTORSIZE]]
 
*[[Manuals/calci/ISVECTORSIZE | ISVECTORSIZE]]
Line 901: Line 920:
 
*[[Manuals/calci/YES | YES]]
 
*[[Manuals/calci/YES | YES]]
 
*[[Manuals/calci/YUP | YUP]]
 
*[[Manuals/calci/YUP | YUP]]
==INFORMATION2==
+
 
 +
===Information2===
 
*[[Manuals/calci/ACRONYM | ACRONYM]]
 
*[[Manuals/calci/ACRONYM | ACRONYM]]
 
*[[Manuals/calci/APOLOGIZE | APOLOGIZE]]
 
*[[Manuals/calci/APOLOGIZE | APOLOGIZE]]
Line 946: Line 966:
 
*[[Manuals/calci/XMLVALUES | XMLVALUES]]
 
*[[Manuals/calci/XMLVALUES | XMLVALUES]]
 
*[[Manuals/calci/XMY | XMY]]
 
*[[Manuals/calci/XMY | XMY]]
==LOGICAL1==
+
 
 +
===Logical===
 
*[[Manuals/calci/BITAND | BITAND]]
 
*[[Manuals/calci/BITAND | BITAND]]
 
*[[Manuals/calci/BITLSHIFT | BITLSHIFT]]
 
*[[Manuals/calci/BITLSHIFT | BITLSHIFT]]
Line 964: Line 985:
 
*[[Manuals/calci/TRUE | TRUE]]
 
*[[Manuals/calci/TRUE | TRUE]]
 
*[[Manuals/calci/TRUEVALUE | TRUEVALUE]]
 
*[[Manuals/calci/TRUEVALUE | TRUEVALUE]]
==DATABASE AND LIST MANAGEMENT1==
+
 
 +
===Database and List Management1===
 
*[[Manuals/calci/DAVERAGE | DAVERAGE]]
 
*[[Manuals/calci/DAVERAGE | DAVERAGE]]
 
*[[Manuals/calci/DCOUNT | DCOUNT]]
 
*[[Manuals/calci/DCOUNT | DCOUNT]]
Line 977: Line 999:
 
*[[Manuals/calci/DVAR | DVAR]]
 
*[[Manuals/calci/DVAR | DVAR]]
 
*[[Manuals/calci/DVARP | DVARP]]
 
*[[Manuals/calci/DVARP | DVARP]]
==DATABASE AND LIST MANAGEMENT2==
+
 
 +
===Database and List Management2===
 
*[[Manuals/calci/DBPEDIA | DBPEDIA]]
 
*[[Manuals/calci/DBPEDIA | DBPEDIA]]
 
*[[Manuals/calci/DIAG | DIAG]]
 
*[[Manuals/calci/DIAG | DIAG]]
Line 985: Line 1,008:
 
*[[Manuals/calci/DOEFFECT | DOEFFECT]]
 
*[[Manuals/calci/DOEFFECT | DOEFFECT]]
 
*[[Manuals/calci/DOFUNCTIONIF | DOFUNCTIONIF]]
 
*[[Manuals/calci/DOFUNCTIONIF | DOFUNCTIONIF]]
==LOOKUP AND REFERENCE1==
+
 
 +
===Lookup and Reference1===
 
*[[Manuals/calci/ADDRESS | ADDRESS]]
 
*[[Manuals/calci/ADDRESS | ADDRESS]]
 
*[[Manuals/calci/AGE | AGE]]
 
*[[Manuals/calci/AGE | AGE]]
Line 1,067: Line 1,091:
 
*[[Manuals/calci/UPTO | UPTO]]
 
*[[Manuals/calci/UPTO | UPTO]]
 
*[[Manuals/calci/VLOOKUP | VLOOKUP]]
 
*[[Manuals/calci/VLOOKUP | VLOOKUP]]
 +
*[[Manuals/calci/VLOOKUP#Examples | VLOOKUPExamples]]
  
==Lookup and Reference2==
+
===Lookup and Reference2===
 
*[[Manuals/calci/ANALYZE | ANALYZE]]
 
*[[Manuals/calci/ANALYZE | ANALYZE]]
 
*[[Manuals/calci/ASSIGN | ASSIGN]]
 
*[[Manuals/calci/ASSIGN | ASSIGN]]
Line 1,103: Line 1,128:
 
*[[Manuals/calci/XRBETWEEN | XRBETWEEN]]
 
*[[Manuals/calci/XRBETWEEN | XRBETWEEN]]
 
*[[Manuals/calci/XSY | XSY]]
 
*[[Manuals/calci/XSY | XSY]]
==Text and Data1==
+
 
 +
===Text and Data1===
 
*[[Manuals/calci/BADWORDS | BADWORDS]]
 
*[[Manuals/calci/BADWORDS | BADWORDS]]
 
*[[Manuals/calci/CHAR | CHAR]]
 
*[[Manuals/calci/CHAR | CHAR]]
Line 1,225: Line 1,251:
 
*[[Manuals/calci/WRITELN | WRITELN]]
 
*[[Manuals/calci/WRITELN | WRITELN]]
 
*[[Manuals/calci/WS | WS]]
 
*[[Manuals/calci/WS | WS]]
==Text and Data2==
+
 
 +
===Text and Data2===
 
*[[Manuals/calci/CHECKFACT | CHECKFACT]]
 
*[[Manuals/calci/CHECKFACT | CHECKFACT]]
 
*[[Manuals/calci/COLLECTION | COLLECTION]]
 
*[[Manuals/calci/COLLECTION | COLLECTION]]
Line 1,251: Line 1,278:
 
*[[Manuals/calci/STYLECELL | STYLECELL]]
 
*[[Manuals/calci/STYLECELL | STYLECELL]]
  
==Matrix Functions1==
+
===Matrix Functions1===
 
*[[Manuals/calci/ADJ | ADJ]]
 
*[[Manuals/calci/ADJ | ADJ]]
 
*[[Manuals/calci/ANTIDIAGONAL | ANTIDIAGONAL]]
 
*[[Manuals/calci/ANTIDIAGONAL | ANTIDIAGONAL]]
 
*[[Manuals/calci/ANTIDIAGONALWITH | ANTIDIAGONALWITH]]
 
*[[Manuals/calci/ANTIDIAGONALWITH | ANTIDIAGONALWITH]]
 +
*[[Manuals/calci/BLOCKDIAGONAL| BLOCKDIAGONAL]]
 
*[[Manuals/calci/CONTOURS | CONTOURS]]
 
*[[Manuals/calci/CONTOURS | CONTOURS]]
 
*[[Manuals/calci/DIAGONALFILL | DIAGONALFILL]]
 
*[[Manuals/calci/DIAGONALFILL | DIAGONALFILL]]
Line 1,329: Line 1,357:
 
*[[Manuals/calci/MMULT | MMULT]]
 
*[[Manuals/calci/MMULT | MMULT]]
 
*[[Manuals/calci/SIZE | SIZE]]
 
*[[Manuals/calci/SIZE | SIZE]]
 +
*[[Manuals/calci/SKEWSYMMETRIC | SKEWSYMMETRIC]]
 
*[[Manuals/calci/SPREAD | SPREAD]]
 
*[[Manuals/calci/SPREAD | SPREAD]]
 
*[[Manuals/calci/SPREADSHEETS | SPREADSHEETS]]
 
*[[Manuals/calci/SPREADSHEETS | SPREADSHEETS]]
Line 1,338: Line 1,367:
 
*[[Manuals/calci/TRACE | TRACE]]
 
*[[Manuals/calci/TRACE | TRACE]]
 
*[[Manuals/calci/TRANSPOSE | TRANSPOSE]]
 
*[[Manuals/calci/TRANSPOSE | TRANSPOSE]]
==Matrix Functions2==
+
 
 +
===Matrix Functions2===
 
*[[Manuals/calci/CHOLESKY | CHOLESKY]]
 
*[[Manuals/calci/CHOLESKY | CHOLESKY]]
 
*[[Manuals/calci/CHOLESKYFACTORIZATION | CHOLESKYFACTORIZATION]]
 
*[[Manuals/calci/CHOLESKYFACTORIZATION | CHOLESKYFACTORIZATION]]
Line 1,352: Line 1,382:
 
*[[Manuals/calci/QRDEV | QRDEV]]
 
*[[Manuals/calci/QRDEV | QRDEV]]
 
*[[Manuals/calci/REDUCEDROWECHELONFORM | REDUCEDROWECHELONFORM]]
 
*[[Manuals/calci/REDUCEDROWECHELONFORM | REDUCEDROWECHELONFORM]]
 +
*[[Manuals/calci/SVD| SVD]]
 
*[[Manuals/calci/TENSORPRODUCT | TENSORPRODUCT]]
 
*[[Manuals/calci/TENSORPRODUCT | TENSORPRODUCT]]
  
==Other Functions1==
+
===Other Functions1===
 
*[[Manuals/calci/ARRAY | ARRAY]]
 
*[[Manuals/calci/ARRAY | ARRAY]]
 
*[[Manuals/calci/ARRAYFY | ARRAYFY]]
 
*[[Manuals/calci/ARRAYFY | ARRAYFY]]
Line 1,434: Line 1,465:
 
*[[Manuals/calci/WITHIN | WITHIN]]
 
*[[Manuals/calci/WITHIN | WITHIN]]
 
*[[Manuals/calci/WORDPROBLEM | WORDPROBLEM]]
 
*[[Manuals/calci/WORDPROBLEM | WORDPROBLEM]]
+
 
==Other Functions2==
+
===Other Functions2===
 
*[[Manuals/calci/ANOVASINGLEFACTOR | ANOVASINGLEFACTOR]]
 
*[[Manuals/calci/ANOVASINGLEFACTOR | ANOVASINGLEFACTOR]]
 
*[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION]]
 
*[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION]]
Line 1,459: Line 1,490:
 
*[[Manuals/calci/TREEMAPBYSIZE | TREEMAPBYSIZE]]
 
*[[Manuals/calci/TREEMAPBYSIZE | TREEMAPBYSIZE]]
  
==Physics & other related functions1==
+
===Physics & other related functions===
 
*[[Manuals/calci/ACCELERATIONDUETOGRAVITY | ACCELERATIONDUETOGRAVITY]]
 
*[[Manuals/calci/ACCELERATIONDUETOGRAVITY | ACCELERATIONDUETOGRAVITY]]
 
*[[Manuals/calci/DISTANCE | DISTANCE]]
 
*[[Manuals/calci/DISTANCE | DISTANCE]]
Line 1,485: Line 1,516:
 
*[[Manuals/calci/VENUS | VENUS]]
 
*[[Manuals/calci/VENUS | VENUS]]
  
==Special Z3 Functions==
+
===Special Z3 Functions===
 
*[[Manuals/calci/Z3 | Z3]]
 
*[[Manuals/calci/Z3 | Z3]]
 
*[[Manuals/calci/Z3A | Z3A]]
 
*[[Manuals/calci/Z3A | Z3A]]

Latest revision as of 19:32, 19 September 2021

LIST OF ALL FUNCTIONS

Statistical Functions1

Statistical Functions2

Math1

Math2

Date and Time1

Date and Time2

Engineering1

Engineering2

Financial1

Financial2

Geometry and Graph1

Geometry and Graph2

Information1

Information2

Logical

Database and List Management1

Database and List Management2

Lookup and Reference1

Lookup and Reference2

Text and Data1

Text and Data2

Matrix Functions1

Matrix Functions2

Other Functions1

Other Functions2

Physics & other related functions

Special Z3 Functions