Statistics
Find how well a trend fits (R-squared)
=RSQ(B2:B6,A2:A6)How it works in Excel
- B2:B6 is what you are explaining.
- A2:A6 is what you are explaining it with.
- The result runs from 0 to 1.
- 1 means a perfect straight-line fit.
- A high value does not prove one causes the other.
The idea in general
It shows how much of the movement in one thing lines up with another.
What I assumed
- The two lists are in A2:A6 and B2:B6.
Check the result on your own data before relying on it.