Variance and standard deviation functions deal with negative deviations by squaring deviations before they are averaged.
DEVSQ calculates the sum of the squared deviations from the mean, without dividing by N or by N-1.
The DEVSQ function takes multiple arguments in the formnumber1,number2,number3, etc.
up to 255 total.
Arguments can be a hardcoded constant, a cell reference, or a range.
A single range or array can be provided instead of multiple arguments.
STDEV Function
The Excel STDEV function returns the standard deviation for data that represents a sample.
To calculate the standard deviation for an entire population, use STDEVP or STDEV.P.
VAR Function
The Excel VAR function estimates the variance of a sample of data.
If data represents the entire population, use the VARP function or the newer VAR.P function.
VAR ignores text values and logicals in references.
Average deviation is a measure of variability.
