Formulas and Functions
Modifying this control will update this page automatically

COVAR

The COVAR function returns the covariance of two sets of number values.

COVAR(dataset-1, dataset-2)

dataset-1: The collection containing the first set of sample values.

dataset-2: The collection containing the second set of sample values.

Notes

  • The two collections must have the same number of data points.

  • If string values or Boolean values are included within the collections, they are ignored.

Example

Suppose that you kept a record of the periodic changes in the price you paid for gas and also the average temperature setting of your thermostat during the period covered by the specified price.

Given the following table:

A

B

1

Price

Setting

2

4.50

64

3

4.20

65

4

3.91

65

5

3.22

66

6

3.09

66

7

3.15

66

8

2.98

68

9

2.56

70

10

2.60

70

11

2.20

72

=COVAR(A2:A11,B2:B11) returns approximately -1.6202, indicating a correlation (as prices rose, the thermostat was lowered). Covariance is a measure of how much two variables (in this case, the price of heating oil and the setting of the thermostat) change together.

Example — Survey results

To see an example of this and several other statistical functions applied to the results of a survey, see the COUNTIF function.

See alsoCORRELCOUNTIFFORECASTINTERCEPTSLOPE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.