Rolling Correlation — Did the Relationship Between Two Channels Change?
ProOne correlation over a whole record is an average over everything that happened, and it is the wrong answer whenever something happened. Pick two channels and get the coefficient window by window: the shipped example is a tunnel crack that tracked temperature at −0.9 until it was grouted and has not since — a record whose whole-record coefficient is 0.01, which reads as no relationship at all. Windows without enough overlapping readings are left blank rather than plotted.
Your data
This tool is showing its sample dataset.
Everything in the figure is real output computed in your browser. Loading a file of your own is part of Pro.
Synthetic 36-day hourly record from a tunnel lining: air temperature and the width of a monitored crack. For the first 18 days the crack breathes with the temperature — it opens as the lining cools, so the two are strongly inverse at about r = −0.9. The crack is then grouted and the relationship stops — over the whole record r is 0.01, which is the finding this tool recovers and a single coefficient destroys. The gauge also drops out for 26 hours on day 28, so several windows are left blank rather than plotted. Not measured data.
Saved projects
0 of 1Projects are stored in this browser only — never uploaded, and gone if you clear site data. Download one as a file to keep it, move it to another machine, or send it to a colleague.
SVG is vector — scale it to any size in Illustrator, Inkscape or LaTeX without losing quality, and edit the type. Use it unless a journal insists on raster.
Options
Series
Both channels are averaged onto one grid first, then correlated inside each window.
A window is a number of grid steps, so the two channels are put on one regular grid before anything is windowed.
The same two coefficients as the correlation matrix, computed the same way — Spearman is Pearson on the ranks, with tied readings sharing their average rank.
Correlate the first channel at t+lag against the second at t — the cross-correlation tool’s convention, so a lag it reported can be typed straight in here. A positive lag means the second channel leads.
Window
Short windows find changes sooner and invent more of them; long windows are steadier and smear a real change across their own length. Automatic takes about a twelfth of the record.
Consecutive windows overlap, so their coefficients are not independent of each other — a smaller step draws a smoother line, not a more informative one.
Middle is what a report figure wants: a change shows up under where it happened. The right-hand edge is what a monitoring dashboard wants, where only readings up to now may be used.
A window with fewer than this share of its steps holding both readings is left blank rather than plotted. A coefficient from the surviving quarter of a window is not comparable with one from a full window.
Figure
All of that was worked out in this browser tab. Your file was not uploaded, and no request goes out while you work — open the network panel and watch, if you like.
The figure above is this tool's sample dataset, and everything in it is real output — every option works and every number is computed here in your browser. Running Rolling correlation on a file of your own is part of Pro.