This does not have a particularly wonderful correlation.
On the other hand if I shift one graph 10 datapoints relative to the other:
Clearly the two graphs are virtually identical, but one ‘lags’ the other.
- the proper technical terms where I have said ‘lag’ and ‘phase shift’, to describe this situation?
- tools to identify this i.e. "what ‘shift’ will give the best correlation score’?
I’m currently just hacking this in Excel, is it the sort of thing I might find available without specialist tools or writing my own code?