# covariance

1. ### Refer to a cell with text string as array in Covariance.P and Covariance.S function

Hi, I am working on a assignment where I have to calculate the population and sample covariance matrix for stocks. I know there are easier ways, but we have to use these functions. I have my data in column form in another sheet and have named the data range after the ticker of the stock. I...
2. ### Trouble with index/match in a matrix

Hi, I keep getting an #ref error when trying to populate the left matrix with data from the right table (located on another worksheet). I am using the following in b2:=index(j:j,match(b1,h:h,0),match(a2,i:i,0)) and that yields the #ref error. Any advice? Excel 2016 (Windows) 32 bit...
3. ### Automatic array determination upon criterea

Hi, I have been looking ages for this solution in order to complete my thesis. I have a dataset with daily stock prices of many firms. The firms however are listed under each other, and therefore I need to determine the array upon a critera. For my first BETA calculation, i have used the...
4. ### Generating Random Grades With Correlation

I want to generate random grades for 30 hypothetical students in 3 courses, Math, Chem, and English. I can supply a mean and standard deviation and use NORM.INV and RAND() to compute a random grade in each subject for each student. What I can’t figure out is how to make the grades for each...
5. ### calculating covariance matrix from array in vba

I am trying to calculate a covariance matrix in VBA. I have managed to get my data into an array "datarng" which has 10 columns and 100 rows. I want to calculate the covariance matrix of my dataset so that I will have a new array 10x10 by calculating the covariance between each column in the...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back