Therefore, the sign of the covariance shows the trend in the linear relationship between the variables. The magnitude of the covariance is not easy to interpret because it is not normalized and, therefore, depends on the magnitudes of the variables. The normalized version of the covariance, known as correlation coefficientDespite this, shows by its magnitude the strength of the linear linkage.
Therefore, a distinction must be made between:
- the covariance of two random variables, which is a population parameter that can be viewed as a property of the joint probability distribution; Y
- the sample covariance, which at the same time serves as a descriptor of the sample, it also serves as an estimated value of the population parameter.
The COVARIANCE.P function (population), the average of the products of the deviations for each pair of data points in two data sets. Used to establish the link between two data sets. As an example, can examine whether higher earnings accompany higher levels of education.
The The COVARIANCE.P function The function uses the following syntax to operate:
The COVARIANCE.P function (matrix1, matriz2)
The The COVARIANCE.P function The function has the following arguments:
- array1: this is required and represents the first whole number cell range
- array2: this is also necessary. This is the second whole number cell range.
It should be noted at the same time that:
- this function has replaced a previous function (COVAR) and should provide improved precision and a name that better reflects its use
- arguments must be numbers or names, arrays or references containing numbers
- if an array or reference argument contains text, logical values or empty cells, those values are ignored; despite this, cells with zero value are included
- And array1 Y array2 have a different number of data points, The COVARIANCE.P function return the #N / A error value
- if any array1 O array2 it is empty, The COVARIANCE.P function return the # DIV / 0! error value
- The COVARIANCE.P function:
- The COVARIANCE.P function AVERAGE (matrix1) Y AVERAGE (matriz2), Y North The COVARIANCE.P function.
Please, see my example below: