Correlation Analysis
Microsoft Corp vs American Water Works Company, Inc
MSFT vs AWK
-0.496
Moderate inverse
When one moves up, the other tends to move down.
Microsoft Corp
↗MSFT
Microsoft develops and licenses consumer and enterprise software. It is known for its Windows operating systems and Office productivity suite. The company is organized into three equally sized broad segments: productivity and business processes (legacy Microsoft Office, cloud-based Office 365, Exchange, SharePoint, Skype, LinkedIn, Dynamics), intelligence cloud (infrastructure- and platform-as-a-service offerings Azure, Windows Server OS, SQL Server), and more personal computing (Windows Client, Xbox, Bing search, display advertising, and Surface laptops, tablets, and desktops).
Market cap 2.8T
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
Time Series
Relative Performance
Who Moves First
MSFT leads AWK by 6 days
MSFT tends to move before AWK.
After testing 13 timing shifts, the strongest relationship was -0.501 (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.388
11 periods · Return correlation when both series rose
Both Falling
-0.065
8 periods · Return correlation when both series fell
Diverging
-0.732
16 periods · Return correlation when series moved apart
R-Squared
24.6%
Share of variance in one series explained by the other.
Trend Agreement
54.6%
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.537, -0.453]
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
Microsoft Corp
MSFT
Market cap 2.8T
Stock · 1,254 raw → 1,254 prepared
Series B
American Water Works Company, Inc
AWK
Market cap 26.9B · 7,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
-0.0911
Linear regression slope.
Intercept
176.7121
Linear regression intercept.
Related Extremes
Highest and Lowest Correlated
MSFT
Microsoft Corp
Highest
+0.938
Cadence Design Systems
CDNS · 1,254 data points
Lowest
-0.867
Bristol-Myers Squibb Co.
BMY · 1,254 data points
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 5 hours ago · ID: stock-msft-vs-stock-awk-daily-20260408-9vbi74