Therefore, el signo de la covarianza muestra la tendencia en la relación lineal entre las variables. La magnitud de la covarianza no es fácil de interpretar porque no está normalizada y, therefore, depends on the magnitudes of the variables. The normalized version of the covariance, known as correlation coefficientBut nevertheless, muestra por su magnitud la fuerza de la relación lineal.
Esta función devuelve la covarianza, the average of the products of the deviations for each pair of data points in two data sets. Se utiliza para determinar la relación entre dos conjuntos de datos. For instance, can examine whether higher earnings accompany higher levels of education.
The COVAR The function uses the following syntax to operate:
The COVAR 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 also be noted that:
- esta función ha sido reemplazada por dos funciones más nuevas (The COVARIANCE.P function Y COVARIANCIA. S) that can provide greater precision and whose names better reflect their use. Although this feature is still available for backwards compatibility, you should consider using the new features in the future, as this feature may not be available in future versions of Excel.
- 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; but nevertheless, cells with zero value are included
- And array1 Y array2 tener un número diferente de puntos de datos, COVAR return the #N / A error value
- if any array1 O array2 it is empty, COVAR return the # DIV / 0! error value
- la covarianza viene dada por la fórmula:
- where
- The COVARIANCE.P function AVERAGE (matrix1) Y AVERAGE (matriz2), Y North is the sample size.
Please, see my example below:
