# STDEVPA

## Content

This function returns the standard deviation for an entire specified population, including text or logical values as well as numeric values.

## Syntax

`STDEVPA(value1, [value2], ...)`

## Arguments

<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">This function has these arguments:</span>

| <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Argument</span> | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Description</span> |
| -------- | ----------- |
| *<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">value1, value2, ...</span>* | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;"> </span>Value1 is required, subsequent values are optional. 1 to 255 values corresponding to a population. You can also use a single array or a reference to an array instead of arguments separated by commas. |

## Remarks

The standard deviation is a measure of how widely values are dispersed from the average value.
The standard deviation is calculated using the "biased" or "n" method.
The equation for calculating the standard deviation for a population is:
![](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/Func-STDEVPA.png)
where x is the value and n is the number of values.
This function assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using the STDEVA function.
This function differs from STDEVP because it accepts text or logical values as well as numeric values.

## Examples

`STDEVPA(A1,B2,C3,D4,E5,F6)`
`STDEVPA(A1:A9)`
`STDEVPA(R1C2,R3C4,R4C5,R7C2)`
`STDEVPA(95,89,73,87,85,76,100,96,96)` gives the result 8.8079649700