Correlation Analysis
Microsoft Corp vs PG&E Corporation
MSFT vs PCG
+0.528
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
PG&E Corporation
↗PCG
PG&E is a holding company whose main subsidiary is Pacific Gas and Electric, a regulated utility operating in Central and Northern California that serves 5.3 million electricity customers and 4.6 million gas customers in 47 of the state's 58 counties. PG&E operated under bankruptcy court supervision in 2001-04 during California's energy crisis and in 2019-20 due to wildfire losses. In 2004, PG&E sold its unregulated assets as part of its first postbankruptcy reorganization.
Market cap 38.8B · 29,000 employees
Time Series
Rebased to 100
Who Moves First
PCG leads MSFT by 6 days
PCG tends to move before MSFT.
Best correlation after shifting: +0.530 (13 shifts scanned)
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.360
14 periods · Return correlation when both series rose
Both Falling
-0.149
8 periods · Return correlation when both series fell
Diverging
-0.795
13 periods · Return correlation when series moved apart
R-Squared
27.8%
Share of variance in one series explained by the other.
Trend Agreement
53.7%
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.486, 0.566]
Scatter
XY Regression
Pipeline
Data quality details
Pipeline
Data quality details
Pipeline Summary
1,254 paired observations 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
PG&E Corporation
PCG
Market cap 38.8B · 29,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
0.0187
Linear regression slope.
Intercept
8.4519
Linear regression intercept.
Related Extremes
Highest and Lowest Correlated
Saved 3 hours ago · ID: stock-msft-vs-stock-pcg-daily-20260408-nxdmup