STDEV
Definition
Calculates the standard deviation based on a sample.
Sample Usage
STDEV(1,2,3,4,5,6,7,8,9,10)
STDEV(A2:A100)
Syntax
STDEV(value1, [value2, ...])
value1
 The first value or range of the sample.value2, ...
 Additional values or ranges to include in the sample.
Notes
Although
STDEV
is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.If the total number of values supplied as
value
arguments is not at least two,STDEV
will return the#NUM!
error.STDEV
will return an error if any of thevalue
arguments include text. To calculate standard deviation while interpreting text values as0
, useSTDEVA
.STDEV
calculates standard deviation for a sample. To calculate standard deviation across an entire population, useSTDEVP
.STDEV
is equivalent to the square root of the variance, orSQRT(VAR(...))
using the same dataset.
See Also
VARPA
: Calculates the variance based on an entire population, setting text to the value `0`.
VARP
: Calculates the variance based on an entire population.
VARA
: Calculates the variance based on a sample, setting text to the value `0`.
VAR
: Calculates the variance based on a sample.
STDEVPA
: Calculates the standard deviation based on an entire population, setting text to the value `0`.
STDEVP
: Calculates the standard deviation based on an entire population.
STDEVA
: Calculates the standard deviation based on a sample, setting text to the value `0`.
SKEW
: Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.
KURT
: Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.
DVARP
: Returns the variance of an entire population selected from a database tablelike array or range using a SQLlike query.
DVAR
: Returns the variance of a population sample selected from a database tablelike array or range using a SQLlike query.
DSTDEVP
: Returns the standard deviation of an entire population selected from a database tablelike array or range using a SQLlike query.
DSTDEV
: Returns the standard deviation of a population sample selected from a database tablelike array or range using a SQLlike query.
DEVSQ
: Calculates the sum of squares of deviations based on a sample.
AVEDEV
: Calculates the average of the magnitudes of deviations of data from a dataset's mean.
In order to use the STDEV formula, start with your edited Excellentable
Then type in the STDEV Formula in area you would like to display the outcome:
Type in the complete STDEV formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.
A

B

C



1


2


3


4


5


6


7


8


9


10


11


12


13
