4. Calculate the standard deviation


The standard deviation may be calculated using one of the following options:

standard deviationa) 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)).

 

standard deviation Sb) use the formula =STDEV.S(...) or =STDEV.P(...) to get the standard deviation of the sample or
of a population, respectively.

 

standard deviation PIn 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]