Difference between revisions of "Z API Functions"

From ZCubes Wiki
Jump to navigation Jump to search
 
(20 intermediate revisions by 3 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/z3console| z3console]]
*[[Manuals/calci/Examples | Examples of Java and z^3 programs]]
+
*[[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 20: 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 170: 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 212: 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 219: 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 406: 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 523: 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 795: 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 801: 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 832: 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 1,080: 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,270: 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,344: 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]]

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