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
Search JabSto ::

Custom Search