answersLogoWhite

0

See related link. You can use Excel, if you dataset is not too big. Generally, if I have a table of data, with n columns corresponding to n variables with N observations, I can calculate the covariance of columns a and b, using excel covar function, covar(range of first data values, range of second data values) To keep things organized, you may want to name the ranges of your columns and use them as the arguments in the covar.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

How 2 calculate a variance covariance matrix?

look in a maths dictionary


How do you calculate a variance covariance matrix explain with an example?

variance - covariance - how to calculate and its uses


What will be the dimensions of the new matrix formed by multiplying a 2 by 4 matrix and a 4 by 5 matrix?

2 x 5 matrix


How can I calculate the portfolio standard deviation in Excel?

To calculate the portfolio standard deviation in Excel, you can use the formula SQRT(SUMPRODUCT(COVARIANCE MATRIX, WEIGHTS MATRIX, TRANSPOSE(WEIGHTS MATRIX))). This formula multiplies the covariance matrix of the assets, the weights of each asset in the portfolio, and the transpose of the weights matrix, then takes the square root of the sum of these products.


What is involuntary matrix?

a squar matrix A is called involutary matrix. if A^2=I


What is a involuntary matrix?

a squar matrix A is called involutary matrix. if A^2=I


What will be the dimensions of a new matrix formed by multiplying a 2 X 4 matrix and a 4 X 5 matrix?

It will be a 2 x 5 matrix.


How do you calculate landau's index of linearity?

In our simulations, we use this (in Matlab/Octave): function l=linearityindex(matrix) m=(matrix>matrix')+.5*(matrix==matrix'); rowsums=sum(m,2)-.5; n=length(rowsums); l=12/(n^3-n)*sum((rowsums-(n-1)/2).^2); You may want to check out Landau's 1951 paper, "On dominance relations and the structure of animal societies: I. Effect of inherent characteristics". From http://www.springerlink.com/content/366920782vwr0648/


Is it possible to multiply a 2 X 2 matrix and a 2 X 3 matrix?

Yes it is possible. The resulting matrix would be of the 2x3 order.


What is matrix programming in C programming?

C Examples on Matrix OperationsA matrix is a rectangular array of numbers or symbols arranged in rows and columns. The following section contains a list of C programs which perform the operations of Addition, Subtraction and Multiplication on the 2 matrices. The section also deals with evaluating the transpose of a given matrix. The transpose of a matrix is the interchange of rows and columns.The section also has programs on finding the trace of 2 matrices, calculating the sum and difference of two matrices. It also has a C program which is used to perform multiplication of a matrix using recursion.C Program to Calculate the Addition or Subtraction & Trace of 2 MatricesC Program to Find the Transpose of a given MatrixC Program to Compute the Product of Two MatricesC Program to Calculate the Sum & Difference of the MatricesC Program to Perform Matrix Multiplication using Recursion


What will be the dimensions of the new matrix formed by multiplying a 7 X 2 matrix and a 2 X 6 matrix?

7 x 6A+


Is it possible to multiply a 3 X 2 matrix and a 2 X 3 matrix?

The first matrix has 3 rows and 2 columns, the second matrix has 2 rows and 3 columns. Two matrices can only be multiplied together if the number of columns in the first matrix is equal to the number of rows in the second matrix. In the example shown there are 3 rows in the first matrix and 3 columns in the second matrix. And also 2 columns in the first and 2 rows in the second. Multiplication of the two matrices is therefore possible.