Syntax
Description
Estimates standard deviation on the entire population. If they represent only a sample of the entire population, use STDEVS instead. STDEVP supports more than 255 arguments.
Examples
STDEVP(#sheet!Column1;#sheet!Column2)
| Column1 | Column2 | STDEVP returns |
|---|---|---|
| 1 | 9 | 4 |
| 23 | 33 | 5 |
| 43 | 34 | 4.5 |
| 22 | 11 | 5.5 |
| 6 | 23 | 8.5 |
| 32 | 234 | 101 |
| 24 | 342 | 159 |