# How to Calculate Standard Deviation if Variance Is Negative

## Negative Variance Means You Have Made an Error

As a result of its calculation and mathematical meaning, variance can never be negative, because it is the average squared deviation from the mean and:

• Anything squared is never negative.
• Average of non-negative numbers can’t be negative either.

Therefore, if you have negative variance and you are wondering how to calculate standard deviation from it, first look at how you have got the negative variance in the first place. You (or the person who has calculated the variance) have made a mistake somewhere.

For example, a common mistake is that you forget to square the deviations from the mean (and that would result in a possibly negative variance).

There is simply no chance that variance can be negative if calculated correctly.

## Related pages

macd calculation excelhow to calculate 95 percentile in excelwhat is the meaning of rsiblack scholes formula explainedexcel formula explanationsdelta otcdow close yesterdaygeometric mean advantages and disadvantagesvega calculators&p 500 vixput option premium calculatorform 13f hroptions futures and other derivatives john c hull solution manualcalculating standard deviation on calculatorannualized volatility formulakurtosis definenatural logarithm in excelhistorical stock return calculatorstraddle strategy in optionsderivatives book by john hullkurtosis examplesubs etnsoptions futures and other derivatives solutionscredit suisse etnssoros fund management websiteusing macd to tradesum of squares formula statisticswhat is the formula for standard deviation in excelcan sharpe ratio be negativehedge fund overviewformula for sample variance in statisticscompute implied volatilitycboe vix settlementberkshire hathaway hedge fundexcel formula explainedmerton scholestheta in options tradingannual rate of return formula excelvariance formula financehow to calculate mean in excel 2007measure of skewnesssharpe ratio exampleln x excelexcel probability formulasdelta hedgingpayoff of a call optionhow to use normdist function in excelsample skewness formulavix options expirationadvantages and disadvantages of median in statisticskurtosis in exceldelta formulascalculate exponential moving averagechart of vixpositive kurtosisvixy prosharesvariance and standard deviation calculatorgreeks financesquaring numbers in excelformula for variance for ungrouped datas&p etf shortpayoff diagrams for call and put optionswhat is the black scholes modelformula for standard deviation on excelvix futures term structurewhat does implied volatility meanfutures expirystatistical skewnessstraddle payoffshort put option payoffmean variance and standard deviation calculatorquote tvixyahoo finance stock optionswhat is an option straddlersi stock indicatorcalculating volatility of stockwhat does oversold mean in stocksquote vxxstd dev calculatormedian calculation excelweighted average method accounting formulavix and morecboe option calculatorhow to use stdev in excelsell strangle