covariance

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...

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...

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...

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...

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...