COVARIANCE.S function

The COVARIANCE.S function calculates the covariance of a dataset, where the dataset is a sample of the total population.

Parts of a COVARIANCE.S function 

COVARIANCE.S(data_y, data_x)

Part Description
data_y The range representing the array or matrix of dependent data.
data_x The range representing the array or matrix of independent data.

Sample formulas 

COVARIANCE.S(A1:A10)

COVARIANCE.S(1, 2, 3, 4)

COVARIANCE.S(B1:B5, 10)

Notes

  • Any text encountered in the value arguments will be ignored.
  • Positive covariance indicates that the independent data and dependent data tend to change together in the same direction.
  • Negative covariance indicates that they tend to change together in the opposite direction. An increase in one leads to a decrease in the other. The magnitude of covariance is difficult to interpret.

Examples

  A B
1 data_1 data_2
2 2 4
3 5 3
4 7 6
5 1 1
6 8 5
7    
8    
9 Covariance Formula
10 4.65 =COVARIANCE.S(A2:A6, B2:B6)
11 7 =COVARIANCE.S({1,3}, {-1,6})

Related functions

  • COVAR: Calculates the covariance of a dataset.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Main menu
4912444648833819211
true
Search Help Center
true
true
true
true
true
35
false
false