Correlation Analysis
American Water Works Company, Inc vs Eli Lilly & Co.
AWK vs LLY
-0.682
Strong inverse
When one moves up, the other tends to move down.
American Water Works Company, Inc
↗AWK
American Water Works is the largest investor-owned US water and wastewater utility, serving nearly 4 million customers in 14 states. It provides water and wastewater services to residential, commercial, and industrial customers and operates predominantly in regulated markets. The company's nonregulated business is water services for military bases, which operates under long-term contracts with regulated-like returns. The proposed Essential Utilities acquisition would add regulated water and wastewater utilities in Ohio, North Carolina, and Texas while increasing its presence in Illinois, Indiana, Pennsylvania, New Jersey, and Virginia.
Market cap 26.9B · 7,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
AWK leads LLY by 6 days
AWK tends to move before LLY.
After testing 13 timing shifts, the strongest relationship was -0.694 (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.310
14 periods · Return correlation when both series rose
Both Falling
+0.120
8 periods · Return correlation when both series fell
Diverging
-0.698
13 periods · Return correlation when series moved apart
R-Squared
46.5%
Share of variance in one series explained by the other.
Trend Agreement
56.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.710, -0.651]
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
American Water Works Company, Inc
AWK
Market cap 26.9B · 7,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
3
Estimated crossover points between normalized spreads.
Slope
-11.9701
Linear regression slope.
Intercept
2293.8454
Linear regression intercept.
Related Extremes
Highest and Lowest Correlated
AWK
American Water Works Company, Inc
Highest
+0.053
Johnson & Johnson
JNJ · 1,254 data points
Lowest
-0.720
Exxon Mobil Corporation
XOM · 1,254 data points
Saved 7 hours ago · ID: stock-awk-vs-stock-lly-daily