Manuals/calci/STDEVP
STDEVP(N1,N2,...)
Where N1,N2, ... are the arguments .
This function calculates the standard deviation on the entire population.
- S D is calculated by the "n" method.
- The Arguments can be numbers or names, arrays, or references.
- Empty cells, logical values, text, or error values are ignored.
- ** STDEVP is counted using this formula:
Where x is the sample mean average (V1,V2........) and n is the sample size.
STDEVP
Lets see an example,
150
130
165
132
110
137
121
=STDEVPA(B2:B8)is 16.84
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 150 | 16.835337 | ||
| Row2 | 130 | |||
| Row3 | 165 | |||
| Row4 | 132 | |||
| Row5 | 110 | |||
| Row6 | 137 | |||
| Row7 | 121 |
