Statistics
Calculate covariance
=COVARIANCE.S(A2:A4,B2:B4)How it works in Excel
- A2:A4 and B2:B4 are the two lists.
- Positive means they tend to move together.
- Use COVARIANCE.P for a full population.
- CORREL is easier to read, because it runs from -1 to 1.
The idea in general
It measures if two things tend to rise and fall at the same time.
What I assumed
- The two lists are in A2:A4 and B2:B4.
Check the result on your own data before relying on it.