/
STDEVS
STDEVS
- Charles Bishop (Deactivated)
Owned by Charles Bishop (Deactivated)
Jan 30, 2018
Analytics
Loading data...
Syntax
Description
Estimates standard deviation of its arguments. It assumes that the arguments are a sample of the population. If they represent the entire population, use STDEVP instead. STDEVS supports more than 255 arguments.
Examples
STDEVS(#sheet!Column1;#sheet!Column2)
| Column1 | Column2 | STDEVP returns |
|---|---|---|
| 1 | 9 | 5.656854349492381 |
| 23 | 33 | 7.0710678118654755 |
| 43 | 34 | 6.363961030678928 |
| 22 | 11 | 7.7781745930520225 |
| 6 | 23 | 12.020815280171307 |
| 32 | 234 | 142.8355697996826 |
| 24 | 342 | 224.8599564173221 |
, multiple selections available,