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)' | #VALUE!: undefined | |||
| OMBINATION | number, number | '=COMBINATION(7,5) | #VALUE!: undefined | |||
| PERMUTATION | number, number | '=PERMUTATION(7,5) | #VALUE!: undefined | |||
| 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 | ||||||
| NORMCFD | ||||||
| LINEAR_REQ_EQ | ||||||
| EXP_REG_EQ | ||||||
| SECANTMETHOD | ||||||
| FIVEPT | ||||||
| FCRIT | ||||||
| ASR |
