From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Challenge: Calculate correlations between columns of data

Challenge: Calculate correlations between columns of data - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial

Challenge: Calculate correlations between columns of data

“

(upbeat synth music) - [Instructor] In this chapter, we have looked at covariance and correlation as measures of how data varies within a data set. I'd like to challenge you to work with the problem set forward in the Chapter 5 Challenge Workbook, which you can find in the Chapter 5 folder of the exercise files collection. I would like you to find the covariance between the values in the customers and sales columns, those are in A and B. Also the correlation of those same two columns, and then create a 3x3 grid that will determine the correlation of each column as paired with other columns. Remember, as a hint, that anytime you get the correlation of a column with itself, the values should be one because the values are exactly identical. So that means that cells G8, H9, and I10 should all contain the values of one. With that in mind, go ahead and try the problem. And I will be back in the next movie to show you…

Contents