The basics

Check if two columns move together

How it works in Excel

• The result runs from -1 to 1.
• 1 means they rise together, -1 means opposite directions, and 0 means no clear link.
• Both ranges must be the same size.
• Correlation does not prove one thing causes the other.

The idea in general

Ice cream sales and sunburns rise together, because both follow the sunny weather.

What I assumed

• The two lists are in A2:A4 and B2:B4.

Check the result on your own data before relying on it.