From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Calculate covariance among multiple pairs of columns

Calculate covariance among multiple pairs of columns - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Calculate covariance among multiple pairs of columns

“

In the previous movie, I showed you how to calculate covariance for two columns of data. In this movie, I will show you how to do it for multiple columns of data by creating a grid. My sample file is 0503 Multiple Covariance, and you can find it in the Chapter 5 folder of the Exercise Files Collection. I have four columns of data in this workbook, and you can see them over here in columns A through D. and then I also have the covariance formula over here on the right as a reminder, but we're actually not going to implement it directly. Instead, we're going to use a built-in function. It'll save us a lot of time. To start, I will click in cell G2, and I want to calculate the covariance of column one with itself. And no, this calculation doesn't make any sense in any real way, but what it will let us do is create formulas that we can copy to the rest of the cells in the worksheet. So in cell G2, I will type an equal sign and I will use covariance.s. And this assumes that we have a…

Contents