When I create a Covariance Matrix using Excel’s Data Analysis facility, only half of the covariances are returned. Is it possible to use the Data Analysis tool to present both covariances (I know that they’re the same) for each pair of data series? I am using Excel 2007.

Thank You