Microsoft Office Tutorials and References
In Depth Information
COVAR returns covariance, the average of the products of deviations for each data point pair.
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.
Is the second set of values; can be a cell range, range name, or array.
The equation for the covariance is
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
CRITBINOM returns the smallest value for which the cumulative binomial distribution is greater
than or equal to a criterion value ( alpha ).