Loading...
 
Skip to main content

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)'
  1. VALUE!: undefined
OMBINATION number, number '=COMBINATION(7,5)
  1. VALUE!: undefined
PERMUTATION number, number '=PERMUTATION(7,5)
  1. 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 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
Edit No parse Export Graph