Spread Formula Reference
COVARIANCE.S
Formula Functions > Functions A to C > COVARIANCE.S

Summary

This function returns the sample covariance, which is the average of the products of deviations for each data point pair in two sets of numbers.

Syntax

COVARIANCE.S(array1,array2)

Arguments

The two arrays of data in the arguments of this function should meet these criteria:

Remarks

Use this covariance function to determine the relationship between two sets of data. For example, you can determine whether greater income accompanies greater levels of education.

Data Types

Accepts arrays of numeric data for both arguments. Returns numeric data.

Examples

COVARIANCE.S(J2:J5,L2:L5)

COVARIANCE.S(R2C12:R15C12,R2C14:R15C14)

COVARIANCE.S({7,5,6},{7,4,4}) gives the result 1.5

COVARIANCE.S({5,10,15,20,25},{4,8,16,32,64}) gives the result 180

Version Available

This function is available in Spread for Windows Forms 11.0 or later.

See Also