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]