- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - STDEVA Function
Description
The STDEVA function estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Syntax
STDEVA (value1, [value2] ...)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Value1 |
1 to 255 values corresponding to a sample of a population. You can also use a single array or a reference to an array instead of arguments separated by commas. |
Required |
Value2,... | Optional |
Notes
STDEVA uses the following formula −
$$\sqrt{\frac{\sum \left ( x-\bar{x} \right )^2}{n-1}}$$
Where $\bar{x}$ is the sample mean AVERAGE (value1, value2…) and n is the sample size.
STDEVA assumes that its arguments are a sample of the population. If your data represents the entire population, you must compute the standard deviation using STDEVPA
The standard deviation is calculated using the "n-1" method
Arguments can be −
Numbers
names, arrays, or references that contain numbers
text representations of numbers
logical values, such as TRUE and FALSE, in a reference
Arguments that contain TRUE evaluate as 1. Arguments that contain text or FALSE evaluate as 0 (zero)
If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
If fewer than two numeric values are supplied to the Function, STDEVA returns the #DIV/0! Error value.
If any values that are supplied directly to the function are text values that cannot be interpreted as numeric values, STDEVA returns the #VALUE! Error value.
If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the STDEV function.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016