The standard deviation may be calculated using one of the following options:
a) the standard deviation is actually the square root of the variance. In MS Excel, this can be written =SQRT(VAR(...))
. In our case, type =SQRT(VAR(A1:A100)).
b) use the formula =STDEV.S(...)
or =STDEV.P(...)
to get the standard deviation of the sample or
of a population, respectively.
In our case, type =STDEV.S(A1:A100)
or =STDEV.P(A1:A100).
Note that STDEV
(the function by default) and STDEV.S
are equal, meaning that STDEV
assumes that A1:A100 (or any argument placed between parentheses) are a sample of the population, NOT the entire population.
Fant du det du lette etter? Did you find this helpful?
[Average: 0]