Microsoft Office Tutorials and References

In Depth Information

**Using COVARIANCE.P to Determine Whether Two Variables Vary Together**

Figure 14.22.

Figure 14.22.
Standard error is another measure of the quality of a regres-

Standard error is another measure of the quality of a regres-

sion line.

sion line.

Using

Using
COVARIANCE.P

to Determine Whether Two Variables Vary Together

Covarianceis a measure of how greatly two variables vary together. If the

value is 0, the variables do not appear to be related. For positive values,

covariance indicates that as xincreases, yalso increases. For negative

values, covariance indicates that as xincreases, ydecreases.

COVARIANCE.P
to Determine Whether Two Variables Vary Together

Syntax

=COVARIANCE.P(array1,array2)

=COVARIANCE.S(array1,array2)

The COVARIANCE.P function returns covariance, the average of the

products of deviations for each data point pair. You use covariance to de-

termine the relationship between two data sets. For example, you can ex-

amine whether greater income accompanies greater levels of education.

COVARIANCE.P assumes that the arrays represent an entire population. If

the arrays are a sample of the population, use the COVARIANCE.S function.

The COVARIANCE.P and COVARIANCE.S functions take the following argu-

ments:

•
array1

array1
—
This is the first cell range of integers.

•
array2

array2
—
This is the second cell range of integers.