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.

Solution: Calculate correlations between columns of data

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

From the course: Learning Excel: Data Analysis

Start my 1-month free trial

Solution: Calculate correlations between columns of data

“

(upbeat music) - [Instructor] I hope you've had a chance to work with the problem presented in this workbook. I'd like to now show you how I would solve it. And again, my sample file is Chapter_5_Challenge and you can find it in the chapter 5 folder of the exercise files collection. The first task is to go to cell F 2 and calculate the co-variance between the values and the customers and sales columns. So in F 2 I'll type in equal sign and I will start typing covar and because you can never be sure that you have all of your data, I'm going to use COVARIANCE.S which assumes that we have a sample, so I'll highlight that, press tab, and now I need to identify the two arrays. The first one is customers and those values are in A 2 through A 12 then a comma and then sales, which are in column B. So B 2 to B 12 I've selected there, right parenthesis and enter, and we get a covariance of 4023.16. How you interpret that…

Contents