COVARIANCE.S functionThe 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
The range representing the array or matrix of dependent data.
The range representing the array or matrix of independent data.
COVARIANCE.S(1, 2, 3, 4)
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.
COVAR: Calculates the covariance of a dataset.