From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

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 Buy for my team

Challenge: Calculate correlations between columns of data

“

(bright upbeat music) - [Presenter] In this chapter, we have looked at covariance and correlation as measures of how data varies within a dataset. 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 three-by-three 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 value should be 1 because the values are exactly identical. So that means that cells G8, H9, and I10 should all contain the values of 1. With that in mind, go ahead and try the problem, and I will be back in the next movie to show you how I would solve it.

Contents