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 06:49:27
Revision: September 15th 2010 07:29:09
FunctionArgumentsExampleResultsAdditional InformationSample #Sample Text
FACTORIAL
COMBINATION
PERMUTATION
GAMMA
PRECISION
MINIMUM
MODE
MAXIMUM
MEAN
SUM
MEDIAN
QUARTILES
VARIANCE
MEANDEV
STDEV
COVARIANCE
CORR_COEFF
UNIFORMCDF
BINOMIAL
BIONOMIALCDF
NEGBIN
NEGBINCDF
HYPGEOM
HYPGEOMCDF
EXPONENTIALCDF
POISSON
POISSONCDF
NORMCFD
LINEAR_REQ_EQ
EXP_REG_EQ
SECANTMETHOD
FIVEPT
FCRIT
ASR
FunctionArgumentsExampleResultsAdditional InformationSample #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+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
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