Manuals/calci/STDEVPA
Jump to navigation
Jump to search
STDEVPA(V1,V2,...)
Where V1,V2......are integers.
This function calculates standard deviation based on the entire population by the given arguments, text and logical 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.
- The text representations of numbers are also counted.
- In this function, TRUE evaluate as 1; and FALSE evaluate as 0 (zero).
- o find STDEVPA, the formula is:
Where x is the sample mean average (V1,V2........) and n is the sample size.
STDEVPA
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 |
