Multi-Series Time Series Correlation Dashboard · Designed by Deepak Sharma · Built with AI
PEARSON r · PAIRWISE ANALYSIS
SERIES — | ROWS —
FILE —
Column 1 = Date
Columns 2–13 = Time Series Values
Min 3 Series
Max 12 Series
Format: CSV or Excel (.xlsx)
📂
Drop your file here or click to browse
Upload an Excel or CSV file with Date in column 1 and your time series in columns 2 onward.
✓ Min 3 series
✓ Max 12 series
✓ .xlsx or .csv
✓ Row 1 = headers
Required File Format
FormatColumn A — Date | Columns B to M — Product / Series Names
NoteMin 3 · Max 12 Products / Series
A
B
C
D
…M
1
Date
Product Name-1
Product Name-2
Product Name-3
…up to 12
2
Jan-21
8.48
621.01
8.00
…
3
Feb-21
9.49
648.39
9.06
…
4
Mar-21
10.10
721.23
9.60
…
5
Apr-21
9.96
686.44
9.42
…
6
May-21
10.60
715.07
10.13
…
7
Jun-21
11.36
731.61
11.05
…
…
…
…
…
…
…
⏳ Computing correlations…
01
Detected Series
—
🔧 Parsed Data Preview (click to expand) — verify dates align with your file
Columns: Row# · Raw date from file · Parsed Year-Month · First series value.
If the parsed Year-Month does NOT match the raw date, that's the bug. Use the download button to inspect every row.
Tool version: v5 — raw-excel-serial · 2026-04-29
02
Summary Statistics & Monthly Seasonality
MEAN · MEDIAN · MIN · MAX
Filter Year← select a year to see stats for that year only
Series
Month
Year
← Filter by series, month or year to explore seasonality
Monthly Seasonality — All Years
↑ Green = month increased vs prior month |
↓ Red = decreased |
– = first data point, no prior month |
Bottom row = avg change per month across all years
Year-over-Year Change — All Years
↑ Green = month higher than same month one year earlier |
↓ Red = lower |
– = no prior-year value to compare against |
Bottom row = avg YoY change per month across all years
03
Price Trends
—
All Series Over Time
Axis:⚠ Large value differences detected — some series auto-moved to right axis
04
Correlation Matrix
PEARSON r · ALL PAIRS
Reading guide:
■ Dark green ≥ 0.90 Very strong |
■ Green 0.70–0.89 Strong |
■ Yellow 0.50–0.69 Moderate |
■ Orange/Red < 0.50 Weak |
Diagonal = 1.00 (self-correlation)