Microsoft Office Tutorials and References

In Depth Information

**Statistical Functions**

Counts the number of cells that are not empty and the values

within the list of arguments.

COUNTA

Returns covariance, the average of the products of deviations for

each data-point pair.

COVAR

Returns the smallest value for which the cumulative binomial

distribution is greater than or equal to a criterion value.

CRITBINOM

Returns the sum of squares of deviations of data points from their

sample mean.

DEVSQ

Returns the exponential distribution.

EXPONDIST

Returns the F probability distribution.

FDIST

Returns the inverse of the F probability distribution.

FINV

Returns the Fisher transformation at X.

FISHER

Returns the inverse of the Fisher transformation.

FISHERINV

Calculates or predicts a future value by using existing values.

FORECAST

Calculates how often values occur within a range of values, and

then returns a vertical array of numbers.

FREQUENCY

Returns the result of an Ftest.

FTEST

Returns the gamma distribution.

GAMMADIST

Returns the inverse of the gamma cumulative distribution.

GAMMAINV

Returns the natural logarithm of the gamma function.

GAMMALN

Returns the geometric mean of an array or range of positive data.

GEOMEAN

Calculates predicted exponential growth by using existing data.

GROWTH

Returns the harmonic mean of a data set.

HARMEAN

Returns the hypergeometric distribution.

HYPGEOMDIST

Calculates the point at which a line will intersect the y-axis by

using existing x-values and y-values.

INTERCEPT

Returns the Kurtosis of a data set.

KURT

Returns the k-th largest value in a data set.

LARGE

Calculates the statistics for a line by using the “least squares”

method to calculate a straight line that best fits your data, and

returns an array that describes the line.

LINEST

Calculates an exponential cur ve that fits your data and returns an

array of values that describes the cur ve in regression analysis.

LOGEST

Returns the inverse of the lognormal cumulative distribution

function of X, wherein (x) is normally distributed with parameters

MEAN
and
STANDARD_DEV
.

LOGINV

Returns the cumulative
LOGNORMAL
distribution of X, wherein (x)

is normally distributed with parameters
MEAN
and
STANDARD_DEV
.

LOGNORMDIST