Advanced Functions
"advanced" math/stats functions implemented in jquery.sheet.advancedfn.js
| Function | Arguments | Example | Results | Additional Information | Sample # | Sample Text |
| FACTORIAL | number | '=FACTORIAL(5)' | 120 | |||
| COMBINATION | number, number | '=COMBINATION(7,5) | 21 | |||
| PERMUTATION | number, number | '=PERMUTATION(7,5) | 2520 | |||
| GAMMA | number | |||||
| PRECISION | num, precision | |||||
| MINIMUM | array | |||||
| MODE | array | |||||
| MAXIMUM | array | |||||
| MEAN | array | |||||
| SUM | array | |||||
| MEDIAN | array | |||||
| QUARTILES | array | |||||
| VARIANCE | array | |||||
| MEANDEV | array | |||||
| STDEV | array | |||||
| COVARIANCE | array, array | |||||
| CORR_COEFF | array, array | |||||
| UNIFORMCDF | number, number, number | |||||
| BINOMIAL | number, number, number | |||||
| BIONOMIALCDF | num, num, num | |||||
| NEGBIN | num, num, num | |||||
| NEGBINCDF | N, m, n, x | |||||
| HYPGEOM | N, m, n, x | |||||
| HYPGEOMCDF | N, m, n, x | |||||
| EXPONENTIALCDF | l, x | |||||
| POISSON | l, x | |||||
| POISSONCDF | l, x | |||||
| NORMCDF | u, s, t | |||||
| LINEAR_REQ_EQ | array, array | |||||
| EXP_REG_EQ | array, array | |||||
| SECANTMETHOD | func, min, max, error, maxiter | |||||
| FIVEPT | func, x, h | |||||
| FCRIT | f, a b | |||||
| ASR | f, a b, precision |