Manuals/calci/STDEVA
STDEVA (v1, v2...)
Where v1,v2.....are arguments.
In standard deviation the values are dispersed from the mean.
- 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.
STDEVA
150
130
165
132
110
137
121
=STDEVA(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 |
