Correlation Analysis
Comcast Corp vs Eli Lilly & Co.
CMCSA vs LLY
-0.646
Moderate inverse
When one moves up, the other tends to move down.
Comcast Corp
↗CMCSA
Comcast is made up of three parts. The core cable business owns networks capable of providing television, internet access, and phone services to 65 million US homes and businesses, or nearly half of the country. The firm provides services to about 47% of the locations in this territory. Comcast acquired NBCUniversal from General Electric in 2011. Following the spinoff of several cable networks, including CNBC, MSNBC, and USA, NBCU now consists of the NBC network, several local NBC affiliates, Bravo, the Peacock streaming platform, Universal Studios, and several theme parks. Finally, Sky, acquired in 2018, is a large television provider in the UK and Italy.
Market cap 99.5B · 179,000 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
CMCSA leads LLY by 5 days
CMCSA tends to move before LLY.
After testing 13 timing shifts, the strongest relationship was -0.646 (they moved in opposite directions).
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.176
12 periods · Return correlation when both series rose
Both Falling
-0.047
7 periods · Return correlation when both series fell
Diverging
-0.412
16 periods · Return correlation when series moved apart
R-Squared
41.7%
Share of variance in one series explained by the other.
Trend Agreement
54.8%
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.677, -0.612]
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
Comcast Corp
CMCSA
Market cap 99.5B · 179,000 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
13
Estimated crossover points between normalized spreads.
Slope
-21.9150
Linear regression slope.
Intercept
1465.0731
Linear regression intercept.
Related Extremes
Highest and Lowest Correlated
Saved 6 hours ago · ID: stock-cmcsa-vs-stock-lly-daily