Hi,
I am using Excel's Covariance option from the Data Analysis tools to produce a covariance matrix for a number of variables. I've noticed that the resulting matrix shows only one covariance per pair of variables, and leaves blank the cell at the other intersection of the variables. However, I would like the covariance to appear in both cells for each pair.
Is it possible to amend this?
Thanks!
Bookmarks