Microsoft Office Tutorials and References
In Depth Information
COUNTBLANK
Counts the number of blank cells in the argument range.
Counts the number of cells that meet the criteria you specify in the
argument.
COUNTIF
COUNTIFS*
Counts the number of cells that meet multiple criteria.
Returns covariance, the average of the products of paired devi-
ations.
COVARIANCE.P**
Returns the sample covariance, the average of the products' devi-
ations for each data point pair in two data sets.
COVARIANCE.S**
DEVSQ
Returns the sum of squares of deviations.
EXPON.DIST**
Returns the exponential distribution.
F.DIST**
Returns the F probability distribution.
F.DIST.RT**
Returns the F probability distribution.
F.INV**
Returns the inverse of the F probability distribution.
F.INV.RT**
Returns the inverse of the F probability distribution.
F.TEST**
Returns the result of an F-test.
FISHER
Returns the Fisher transformation.
FISHERINV
Returns the inverse of the Fisher transformation.
FORECAST
Returns a value along a linear trend.
FREQUENCY
Returns a frequency distribution as a vertical array.
GAMMA***
Returns the gamma function value.
GAMMA.DIST**
Returns the gamma distribution.
GAMMA.INV**
Returns the inverse of the gamma cumulative distribution.
GAMMALN
Returns the natural logarithm of the gamma function, G(x).
GAMMALN.PRECISE** Returns the natural logarithm of the gamma function, G(x).
GAUSS***
Returns 0.5 less than the standard normal cumulative distribution.
Search JabSto ::




Custom Search