Accessibility Menu
Arrow-Thin-Down
S&P 500
6,699.40
-0.5%
-35.95
Arrow-Thin-Down
DJI
46,590.41
-0.7%
-334.33
Arrow-Thin-Down
NASDAQ
22,740.40
-0.9%
-213.27
Arrow-Thin-Down
Bitcoin
$107,093
-2.7%
-$2,989.07
Arrow-Thin-Down
AAPL
$258.4
-1.7%
-$4.37
Arrow-Thin-Down
AMZN
$217.92
-1.9%
-$4.11
Arrow-Thin-Down
GOOG
$252.45
+0.4%
+$1.11
Arrow-Thin-Down
META
$733.41
+0.0%
+$0.14
Arrow-Thin-Down
MSFT
$520.63
+0.6%
+$2.97
Arrow-Thin-Down
NVDA
$180.28
-0.5%
-$0.88
Arrow-Thin-Down
TSLA
$438.97
-0.8%
-$3.63
Daily Stock GainersDaily Stock LosersMost Active Stocks

How to Calculate the Historical Variance of Stock Returns

By Motley Fool Staff – Updated Apr 29, 2025 at 11:44 PM

Key Points

  • Stock's historical variance measures its return stability over time.
  • Higher variance indicates greater return unpredictability and risk.
  • Calculate variance using Excel to simplify the process for investment analysis.
Loading paragraph...
Loading image...
Loading paragraph...
Loading image...
Loading pitch...
Loading paragraph...
Loading image...
Loading paragraph...
Loading image...
Loading paragraph...
Loading image...
Loading paragraph...
Loading image...
Loading paragraph...
Loading pitch...
Loading paragraph...
Loading image...
Loading paragraph...
Loading image...
Loading paragraph...
Loading paragraph...
Loading hub_pages...
Loading paragraph...
Loading pitch...
The Motley Fool has a disclosure policy.

Our Guides

Documents and a calculator
How to Calculate Net Change in Cash From a Cash Flow Statement
How to Calculate Accrued Interest
How to Calculate Accrued Interest
Two people sit at table with calculator and paperwork.
How to Calculate Semi-Annual Bond Yield
Man in front of blackboard with investing-related pictures and words drawn on it
How to Calculate a Monthly Return on Investment
stock certificates
How to Calculate the Number of Shares a Company Has
how-to-calculate-the-price-of-a-treasury-bill-infographic
How to Calculate the Price of a Treasury Bill
GettyImages-1309118129.jpg
Calculating the Percentage of an Over-Budgeted Amount
Yellow road sign warning Volatility Ahead against backdrop of beautiful blue sky
How to Calculate Annualized Volatility
Calculator and paperwork on desk
How to Calculate Tax on W-9 Income
how-to-calculate-taxable-amount-of-ira-withdrawal-infographic
How to Calculate the Taxable Amount of an IRA Withdrawal
A business person calculating profit from revenue.
How to Calculate Revenue Growth for 3 Years
red decline stocks down bear
How to Calculate the Percentage of Annual Decline
A small child hitting a baseball off of a tee
How to Calculate the Present Value of Free Cash Flow
A person making a financial calculation.
How to Calculate Average Shareholder Equity
Someone writing a complex mathematical equation on a chalk board.
How to Calculate Interest Rate Using Present and Future Value
Businessperson reviewing income statement
How to Calculate the Net Worth on Financial Statements
Hands pulling a paycheck out of an envelope
How to Calculate Take-Home Pay as a Percentage of Gross Pay
how-to-calculate-interest-rates-and-penalties-on-late-taxes-infographic
How to Calculate Interest Rate and Penalties on Late Taxes
Person sitting in front of blocks spelling GDP.
How to Calculate the Annual Growth Rate for Real GDP
Hands pulling a paycheck out of an envelope
How to Calculate Taxes Using a Paycheck Stub

Premium Investing Services

Invest better with The Motley Fool. Get stock recommendations, portfolio guidance, and more from The Motley Fool's premium services.

View Premium Services