Correlation Analysis
Microsoft Corp vs American Electric Power Company, Inc.
MSFT vs AEP
+0.471
Moderate positive
When one moves up, the other tends to follow.
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 Electric Power Company, Inc.
↗AEP
American Electric Power is one of the largest regulated utilities in the United States, providing electricity generation, transmission, and distribution to more than 5 million customers in 11 states. About 39% of AEP's capacity is coal, with the remainder from a mix of natural gas (28%), renewable energy and hydro (23%), nuclear (7%), and demand response (3%). Vertically integrated utilities, transmission and distribution, and generation and marketing support earnings.
Market cap 71.9B · 17,581 employees
Time Series
Relative Performance
Who Moves First
MSFT leads AEP by 6 days
MSFT tends to move before AEP.
After testing 13 timing shifts, the strongest relationship was +0.494 (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.056
13 periods · Return correlation when both series rose
Both Falling
+0.129
9 periods · Return correlation when both series fell
Diverging
-0.770
13 periods · Return correlation when series moved apart
R-Squared
22.2%
Share of variance in one series explained by the other.
Trend Agreement
53.1%
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.427, 0.513]
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 Electric Power Company, Inc.
AEP
Market cap 71.9B · 17,581 employees
Stock · 1,254 raw → 1,254 prepared
Sign agreement
100.0%
How often both values share the same sign.
Zero crossings
20
Estimated crossover points between normalized spreads.
Slope
0.0711
Linear regression slope.
Intercept
69.5860
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
AEP
American Electric Power Company, Inc.
Highest
+0.797
Walmart Inc. Common Stock
WMT · 1,254 data points
Lowest
+0.510
Exxon Mobil Corporation
XOM · 1,254 data points
Saved 7 hours ago · ID: stock-msft-vs-stock-aep-daily-20260408-s9f8lm