Manuals/calci/STDEV
STDEV(V1,V2,...)
Where V1,V2,......are arguments.
It calculates the Standard deviation for a set of values.
- S D is calculated by the "n-1" method.
- The Arguments can be numbers or names, arrays, or references.
- Empty cells, logical values, text, or error values are ignored.
- S D formula is:
Where x is the sample mean average (V1,V2........) and n is the sample size.
STDEV
150
130
165
132
110
137
121
=STDEV(B2:B8) is 18.18
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 150 | 18.184242 | ||
| Row2 | 130 | |||
| Row3 | 165 | |||
| Row4 | 132 | |||
| Row5 | 110 | |||
| Row6 | 137 | |||
| Row7 | 121 |
