The STDEVA function calculates standard deviation for a sample of data. Unlike the STDEV function, STDEVA will evaluate text and logicals that appear in references.
Purpose of Excel STDEVA Function
To calculate standard deviation for an entire population, use STDEVPA or STDEV.P.
Return value
The sample standard deviation of a supplied set of values.
Syntax
=STDEVA (number1, [number2], …)
Arguments
| Arguments | Description | Remarks |
| number1 | First number or reference in the sample. | Mandatory |
| number2 | Second number or reference. | Optional |
Usage notes
- Use STDEVA when you need to evaluate logicals or text in the standard deviation calculation.
- STDEVA calculates standard deviation using the “n-1” method.
- STDEVA calculates standard deviation using the “n-1” method.
- Values are supplied as arguments.
- They can be supplied as actual numbers, ranges, arrays, or references that contain numbers.
- STDEVA evaluates logical values and/or numbers in supplied references.
- To ignore these values use STDEV or STDEV.S .
Availability
Since 2007 for Windows.
Since 2011 for Mac.