Microsoft Office Tutorials and References
In Depth Information
COVAR
COVAR
COVAR returns covariance, the average of the products of deviations for each data point pair.
=COVAR(array1,array2)
The COVAR function is used to determine if a relationship exists between two data sets. The
range of covariance is from –1 to +1. The data values must be integers. Figure 11.11 shows an
example of the COVAR function.
Is the first set of values; can be a cell range, range name, or array.
ARRAY1
Is the second set of values; can be a cell range, range name, or array.
ARRAY2
The equation for the covariance is
Figure 11.11
If the data set contains
text, logical values, or
blank cells, those cells
are ignored. Cells that
contain a zero (0) are
included in the COVAR
calculation.
CRITBINOM
CRITBINOM returns the smallest value for which the cumulative binomial distribution is greater
than or equal to a criterion value ( alpha ).
=CRITBINOM(trials,probability_s,alpha)
Search JabSto ::




Custom Search