Difference between revisions of "Z API Functions"

From ZCubes Wiki
Jump to navigation Jump to search
 
(50 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 608: Line 617:
 
*[[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 659: Line 668:
 
*[[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 681: Line 690:
 
*[[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 731: Line 740:
 
*[[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 745: Line 754:
 
*[[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 792: 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 798: 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 829: 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 907: Line 921:
 
*[[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 953: Line 967:
 
*[[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 972: Line 986:
 
*[[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 986: Line 1,000:
 
*[[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 995: Line 1,009:
 
*[[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,077: 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===
Line 1,267: Line 1,282:
 
*[[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,341: 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,365: 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]]
  
Line 1,472: 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]]

Latest revision as of 18: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