Correlation Analysis
Consolidated Edison, Inc. vs Eli Lilly & Co.
ED vs LLY
+0.674
Strong positive
When one moves up, the other tends to follow.
Consolidated Edison, Inc.
↗ED
Con Ed is a holding company for Consolidated Edison of New York, or CECONY, and Orange & Rockland, or O&R. These utilities provide steam, natural gas, and electricity to customers in southeastern New York—including New York City—and small parts of New Jersey. The two utilities generate nearly all of Con Ed's earnings following the sale of its clean energy business to RWE in early 2023.
Market cap 41.4B · 15,407 employees
Eli Lilly & Co.
↗LLY
Eli Lilly is a drug firm with a focus on neuroscience, cardiometabolic, cancer, and immunology. Lilly's key products include Verzenio for cancer; Mounjaro, Zepbound, Jardiance, Trulicity, Humalog, and Humulin for cardiometabolic; and Taltz and Olumiant for immunology.
Market cap 828.2B · 50,000 employees
Time Series
Relative Performance
Who Moves First
LLY leads ED by 6 days
LLY tends to move before ED.
After testing 13 timing shifts, the strongest relationship was +0.677 (they moved in the same direction).
Do They Crash Together?
Correlation by Market Regime
How these series behave when markets are rising, falling, or diverging. A correlation that holds in drawdowns is very different from one that only works in rallies.
Both Rising
+0.347
16 periods · Return correlation when both series rose
Both Falling
+0.830
7 periods · Return correlation when both series fell
Diverging
-0.506
12 periods · Return correlation when series moved apart
R-Squared
45.4%
Share of variance in one series explained by the other.
Trend Agreement
57.4%
How often both series moved in the same direction period-to-period.
Overlap Quality
1,254
Deep shared window — 1,254 usable pairs.
Significance
p < 0.001
95% CI: [0.643, 0.703]
Scatter
XY Regression
Pipeline
Data quality details
Pipeline
Data quality details
Pipeline Summary
1,254 paired data points survived the daily window.
Raw input
1,254
1,254
Normalized
1,254
1,254
Prepared
1,254
1,254
Aligned
1,254
1,254
Invalid removed
0
A: 0 / B: 0
Duplicates removed
0
A: 0 / B: 0
Alignment drops
0
A: 0 / B: 0
Series A
Consolidated Edison, Inc.
ED
Market cap 41.4B · 15,407 employees
Stock · 1,254 raw → 1,254 prepared
Series B
Eli Lilly & Co.
LLY
Market cap 828.2B · 50,000 employees
Stock · 1,254 raw → 1,254 prepared
Sign agreement
100.0%
How often both values share the same sign.
Zero crossings
7
Estimated crossover points between normalized spreads.
Slope
19.4152
Linear regression slope.
Intercept
-1238.4796
Linear regression intercept.
Related Extremes
Highest and Lowest Correlated
Saved 7 hours ago · ID: stock-ed-vs-stock-lly-daily