If you have already learned how to use Excel formulas, you can easily analyze data sets. For this reason, read this article where you will learn how to use the COVARIANZA.M and COVARIANCE.P function in Excel .
In turn, to learn more about Excel, it is convenient to know what logical functions are and how to do them . Without further ado let’s continue with the tutorial.
Index( )
- What is the COVARIANZA.M function?
- How to use the COVARIANZA.M and COVARIANCE.P function in Excel
What is the COVARIANZA.M function?
COVARIANZA.M is an Excel statistical function which allows obtaining the covariance of a sample or the mean of the products of the deviations for each pair in two data sets.
Therefore, the COVARIANZA.M function requires two matrices or references of numeric type with a range of values to be able to perform the statistical calculation.
What is the COVARIANCE.P function?
The function COVARIANCE.P or “COVARIANZA.P” is an Excel statistical formula that allows obtaining the covariance of the total population or the mean of the products of the deviations for each pair of points in two data sets.
In this way, the relationships between the data sets can be determined for statistical analysis. For example, it could be analyzed whether the jobs most in demand correspond to the highest salaries. Note: data sets must be of type numeric.
How to use the COVARIANZA.M and COVARIANCE.P function in Excel
You can use various tools to solve financial transactions in Excel . However, if you want to use COVARIANZA.M and COVARIANCE.P in Excel, you need to know the syntax of each formula , as well as the arguments required to apply said syntax from the Excel application.
The syntax of the COVARIANZA.M function
The COVARIANZA.M function has a syntax that involves the use of two arrays or sets of numeric data. In this sense, we must express the formula as follows: = COVARIANZA.M (matrix1; matrix2) Both arguments must be separated with a “;”.
The arguments of the COVARIANZA.M function in Excel
The two arguments “matrix 1” and “matrix2” are required for the COVARIANZA.M function. The “matrix1” corresponds to the first cell range of integers while the “matrix2” is the second cell range of integer numbers.
The syntax of the COVARIANCE.P function in Excel
Like the COVARIANCE.M function, the COVARIANCE.P function in Excel requires two required arguments. Therefore, the expression of the formula is as follows: = COVARIANZA.P (matrix1; matrix2).
If the Microsoft Office Excel package is in the English language, you must use the syntax: = COVARIANCE.P (array1; array2). In both cases, the formula performs the same procedure to provide the population covariance.
The arguments of the COVARIANCE.P function in Excel
The COVARIANCE.P function in Excel requires two integer arguments: “array1” and “array2”. The argument “matrix1” contains the sample means or averages for the first data set, while “matrix2” refers to the sample means for the second data set.
How to use the COVARIANZAM function
To use the COVARIANZA.M function in Excel you must access the formula bar at the top of the spreadsheet. Click on “fx” and in the new window select the “Statistics” category.
Locate the function “COVARIANZA.M” and click on it. Then, enter the required arguments to the formula. To do this, press the red arrow to the left of the text box and drag the cursor across the first range of cells. Perform the same procedure for the second range of cells (array2).
How to use the COVARIANCE.P function
To make use of the COVARIANCE.P function you also need to resort to the formula bar. Subsequently, you select the set of numeric data that corresponds to matrix1 and perform the same procedure for matrix2.
Can I insert the data manually for each formula?
Indeed, it is possible to insert the data manually without having to select cells from the spreadsheet. To do this, you must insert the pairs of points separately as follows: = COVARIANZA.M ({2,7, 3, 9}, {3, 6, 1, 7}). Remember that you can calculate the general average previously from Excel to obtain the data sets that you will use in the formula.
