Can Variance Be Negative? No (See Why)

In one word: No.

Why Variance Can’t Be Negative

The reason is that the way variance is calculated makes a negative result mathematically impossible.

Variance is the average squared deviation from the mean. Notice the word “squared”.

Why Variance Calculation Can’t Give Negative Result

To calculate variance, you:

  1. Take each observation (number) in the data set.
  2. Calculate the differences between the individual numbers and the mean of the data set. Some of these differences can be and – unless all the numbers are exactly the same – will be negative.
  3. Then you square each of the differences (multiply it by itself). This is precisely the moment which eliminates the possibility of variance (and therefore also standard deviation) being negative. Something (negative or positive number) squared is always a positive number, except zero squared which is still zero. You can’t get a negative number when squaring something./can-standard-deviation-be-negative-no/
  4. Then you find the average (mean) of all the squared numbers from the previous step. Because the squared deviations are all positive numbers or zeroes, their smallest possible mean is zero. It can’t be negative. This average of the squared deviations is in fact variance. Therefore variance can’t be negative.

Smallest Possible Variance Value

The smallest value variance can reach is exactly zero. This is when all the numbers in the data set are the same, therefore all the deviations from the mean are zero, all squared deviations are zero and their average (variance) is also zero.

If there are at least two numbers in a data set which are not equal, variance must be greater than zero.

Finances News

mean deviation calculation how to calculate coefficient of variation in excel average deviation calculation population variance formula example how to calculate sample variance in excel mean and variance calculator calculating variance excel standard deviation formula calculator formula standard deviation excel working out standard deviation in excel formula for calculating standard deviation in excel how to calculate standard deviation excel percentile standard deviation calculator st dev calc how to calculate stdev in excel how to find square root of large numbers without calculator variance standard deviation calculator sample standard deviation for grouped data standard deviation for grouped data formula whats the square root of 200 standard deviation definitions covariance formula in excel excel stdev if calculate population standard deviation from sample standard deviation sample mean and population mean formula average deviation definition sampling calculator excel estimated standard deviation calculator significance of standard deviation and variance cost variance calculator finding covariance in excel what's standard deviation formula to calculate variance in excel how to calculate covariance in excel