Description Returns the standard deviation of a population based on a sample of supplied values. The standard deviation of a population represents an average of deviations from the mean within a list of values.
This function is equivalent to the STDEV function, but its implementation treats text and logical values in cell and range references differently.
Syntax STDEVA ( 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 .55634864:
See Also STDEV, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA
