#StackBounty: #visualization #correlation #data-analysis #excel Calculating optimal 'phase shift' when comparing two linear dat…

Bounty: 50

Let’s say I have two columns of data, when graphed they look like this:
enter image description here

This does not have a particularly wonderful correlation.

On the other hand if I shift one graph 10 datapoints relative to the other:

enter image description here

Clearly the two graphs are virtually identical, but one ‘lags’ the other.

What are:

  1. the proper technical terms where I have said ‘lag’ and ‘phase shift’, to describe this situation?
  2. 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?

Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.