Microsoft Office Tutorials and References
In Depth Information
Counts the number of cells that are not empty and the values
within the list of arguments.
Returns covariance, the average of the products of deviations for
each data-point pair.
Returns the smallest value for which the cumulative binomial
distribution is greater than or equal to a criterion value.
Returns the sum of squares of deviations of data points from their
Returns the exponential distribution.
Returns the F probability distribution.
Returns the inverse of the F probability distribution.
Returns the Fisher transformation at X.
Returns the inverse of the Fisher transformation.
Calculates or predicts a future value by using existing values.
Calculates how often values occur within a range of values, and
then returns a vertical array of numbers.
Returns the result of an Ftest.
Returns the gamma distribution.
Returns the inverse of the gamma cumulative distribution.
Returns the natural logarithm of the gamma function.
Returns the geometric mean of an array or range of positive data.
Calculates predicted exponential growth by using existing data.
Returns the harmonic mean of a data set.
Returns the hypergeometric distribution.
Calculates the point at which a line will intersect the y-axis by
using existing x-values and y-values.
Returns the Kurtosis of a data set.
Returns the k-th largest value in a data set.
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.
Calculates an exponential cur ve that fits your data and returns an
array of values that describes the cur ve in regression analysis.
Returns the inverse of the lognormal cumulative distribution
function of X, wherein (x) is normally distributed with parameters
MEAN and STANDARD_DEV .
Returns the cumulative LOGNORMAL distribution of X, wherein (x)
is normally distributed with parameters MEAN and STANDARD_DEV .