🔢Correlation
Also known as Correlation Coefficient, Pearson Correlation
How closely two things rise and fall together. It runs from -1 to 1.
Think of it like
It is like two kids on swings who go up and down at the same time.
Example
For 30 days, Lucy's café notes the heat and her cold drink sales. The correlation is 0.82, so hot days and high sales go together.
Why it matters
Correlation is often the first clue that two things are linked. It shows where to look next.
Definition
Example code
excel
=CORREL(B2:B31, C2:C31)
0.82Common mistake
Key takeaways
- 1From -1 to 1. The sign shows the direction.
- 2Strength, not cause. It never proves one causes the other.
- 3Straight lines only. A curved link can score near 0.