The STDEVA function returns an estimate standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average, or mean, value.
=STDEVA(num_1,[num_2], … )
Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.
|num_1||The first number, cell references or range argument corresponding to a population|
|[num_2], …||Optional. Additional numbers, cell references or ranges for which you want the skew, up to a maximum of 255|
Note: The STDEVA function is used when calculating the standard deviation for a sample of a population, e.g. if your data set records the individual heights of a sample of males. If you are calculating the standard deviation of an entire population, you should use the STDEVP or the STDEVPA function.
|11||=STDEVA(A2:A8)||3,114.317||Standard deviation of values provided in cells A2:A8|
Common Function Error(s)
|Problem||What went wrong|
|a||Occurs if any values that are supplied directly to the function are text values that cannot be interpreted as numeric values|
|#DIV/0!||Occurs if fewer than two numeric values are supplied to the function|
Standard deviation is a statistical measure, that is closely linked to the variance. Both measures are commonly used across a set of values, to identify the amount the values differ, or deviate, from the average value.
Standard deviation is give by the square root of the variance, i.e.:
- x is the sample mean
- n is the sample size
See Wikipedia for more information on standard deviation.