AndersNOR9
New Member
- Joined
- Nov 13, 2017
- Messages
- 20
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 would like to refer to the headings in the covariance matrix as the name of the array, is this possible in some way?
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 would like to refer to the headings in the covariance matrix as the name of the array, is this possible in some way?
Last edited:
