Skip to content

Correlation Matrix for Sensor Channels — Pearson and Spearman

Load a multi-channel export and see how every channel relates to every other. Each cell carries its coefficient and the number of readings the two channels actually share, so a −0.4 from nine hundred readings never looks like a −0.4 from nine — and switching between Pearson and Spearman tells you whether a weak-looking relationship is weak or just curved.

Your data

Drop a logger CSV here

HOBOware and Postlad exports are recognised automatically. It is read on this machine — nothing is uploaded.

Synthetic seven-day record from a seven-channel weather station at fifteen-minute intervals, written as a Postlad stream export. It contains a wet spell on the fourth afternoon, a six-hour humidity-sensor dropout on the third day, and a leaf-wetness sensor installed on the fourth morning — so roughly half of that channel’s cells are marked as low-overlap. Not measured data.

Loading the figure…

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

Statistic

Pearson measures straight-line association. Spearman ranks the readings first, so it catches any monotone relationship and is unmoved by outliers.

Averaging both series before correlating them removes independent noise from each and raises the coefficient. Legitimate — but the figure will say it was done.

A pair with fewer readings in common than this is left blank rather than given a coefficient.

Two channels that only overlap for part of the record are correlated over that part. The mark says so. Set to 0 to switch it off.

Figure

Purely a reading aid. A coefficient does not become meaningful by crossing a round number.

The matrix is symmetric, so the lower triangle holds every distinct pair exactly once.

Grouping puts strongly-related channels next to each other, so blocks of related sensors become visible.

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.