Description Returns the standard deviation of a population based on an entire population of values. The standard deviation of a population represents an average of deviations from the population mean within a list of values
This function is equivalent to the STDEVP function, but its implementation treats text and logical values in cell and range references differently.
Syntax STDEVPA ( number_list )
| Argument | Description |
|---|---|
| number_list | A list of up to 30 numbers. The list may contain numeric values, cell references, range references, or array constants.Text in cells referenced by this function is treated as the number 0 (this includes zero-length text). Text entered in the argument list will be evaluated as a number, if possible; otherwise it causes a #VALUE! error. Text and logical values in arrays are ignored. Logical values referenced in cells or entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE. |
Example This function returns .52:
See Also STDEV, STDEVA, STDEVP, VAR, VARA, VARP, VARPA
