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

Custom Search