Loading...
 
Skip to main content

Spreadsheet History: Advanced Functions

"advanced" math/stats functions implemented in jquery.sheet.advancedfn.js
No Tabs

View

Revision: September 15th 2010 07:18:42
Revision: September 15th 2010 06:49:27
FunctionArgumentsExampleResultsAdditional InformationSample #Sample Text
FACTORIALnumber'=FACTORIAL(5)'#VALUE!: undefined
OMBINATIONnumber, number'=COMBINATION(7,5)#VALUE!: undefined
PERMUTATIONnumber, number'=PERMUTATION(7,5)#VALUE!: undefined
GAMMAnumber
PRECISIONnum, precision
MINIMUMarray
MODEarray
MAXIMUMarray
MEANarray
SUMarray
MEDIANarray
QUARTILESarray
VARIANCEarray
MEANDEVarray
STDEVarray
COVARIANCEarray, array
CORR_COEFFarray, array
UNIFORMCDFnumber, number, number
BINOMIALnumber, number, number
BIONOMIALCDFnum, num, num
NEGBINnum, num, num
NEGBINCDFN, m, n, x
HYPGEOMN, m, n, x
HYPGEOMCDFN, m, n, x
EXPONENTIALCDFl, x
POISSONl, x
POISSONCDF
NORMCFD
LINEAR_REQ_EQ
EXP_REG_EQ
SECANTMETHOD
FIVEPT
FCRIT
ASR
FunctionArgumentsExampleResultsAdditional InformationSample #Sample Text
FACTORIAL-number-'=FACTORIAL(5)'-#VALUE!: undefined
COMBINATION-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
View Clone
View Clone
Toggle Full Screen

Date Selection

Edit Date User Actions
November 16th 2013 05:12:53 xavi View | Clone | Roll back
September 15th 2010 07:29:09 campbe13 View | Clone | Roll back
September 15th 2010 07:18:42 campbe13 View | Clone | Roll back
September 15th 2010 06:49:27 campbe13 View | Clone | Roll back