All language subtitles for 07 - 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 how I would solve it.