Loading...

Skip to main content

Spreadsheet History: Advanced Functions

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

View
Date Selection

View

«
»

«
»

Revision: September 15th 2010 07:29:09

Revision: November 16th 2013 05:12:53

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	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

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

View Clone

View Clone

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