The STDEVA function returns an estimate standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average, or mean, value.

### Syntax

=STDEVA(num_1,[num_2], … )

Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.

#### Arguments

Argument | Description |
---|---|

num_1 | The first number, cell references or range argument corresponding to a population |

[num_2], … | Optional. Additional numbers, cell references or ranges for which you want the skew, up to a maximum of 255 |

Note: The STDEVA function is used when calculating the standard deviation for a

sampleof a population, e.g. if your data set records the individual heights of a sample of males. If you are calculating the standard deviation of anentirepopulation, you should use the STDEVP or the STDEVPA function.

#### Examples

A | B | C | D | |
---|---|---|---|---|

1 | Data | |||

2 | 10,647 | |||

3 | 10,677 | |||

4 | 17,193 | |||

5 | 14,162 | |||

6 | 11,609 | |||

7 | 17,381 | |||

8 | 10,292 | |||

9 | ||||

10 | Formula | Result | Notes | |

11 | =STDEVA(A2:A8) | 3,114.317 | Standard deviation of values provided in cells A2:A8 |

#### Common Function Error(s)

Problem | What went wrong |
---|---|

a | Occurs if any values that are supplied directly to the function are text values that cannot be interpreted as numeric values |

#DIV/0! | Occurs if fewer than two numeric values are supplied to the function |

Standard deviation is a statistical measure, that is closely linked to the variance. Both measures are commonly used across a set of values, to identify the amount the values differ, or deviate, from the average value.

Standard deviation is give by the square root of the variance, i.e.:

where,

- x is the sample mean
- n is the sample size

See Wikipedia for more information on standard deviation.