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)