Related Function:

The STDEVPA function returns  the standard deviation based on the entire population given as arguments, including text and logical values. The standard deviation is a measure of how widely values are dispersed from the average, or mean, value.

### Syntax

=STDEVPA(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

#### 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 =STDEVPA(A2:A8) 2,883.297 Standard deviation of values provided in cells A2:A8

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