Returns the sample covariance, which is the average of the products of deviations for each data point pair in two data sets.
Syntaxis
COVARIANCE.S(array1, array2)Argumenten
array1vereist
The first range of integer cells.
array2vereist
The second range of integer cells.
Use COVARIANCE.S to determine the relationship between two data sets. This function uses the n-1 sample size, making it appropriate for calculating the covariance of a sample rather than an entire population.
=COVARIANCE.S({1,2,3}, {4,5,6})→1Calculates the sample covariance for two sets of three numbers.
Prepare your data
Ensure you have two equal-sized ranges of numeric data in your spreadsheet.
Enter the formula
Type =COVARIANCE.S( and select your two ranges, separated by a comma.
COVARIANCE.S calculates sample covariance (using n-1), while COVARIANCE.P calculates population covariance (using n).