# STDEVA

## Content

This function returns the standard deviation for a set of numbers, text, or logical values.

## Syntax

`STDEVA(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;"> </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 sample of 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 "non-biased" or "n–1" method.
The equation for calculating the standard deviation is the same as for [STDEV](/document-solutions/java-excel-api/docs/online/formula-reference/compatibility-functions/stdev):
![](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/Func-STDEVA.png)
where x is the value and n is the number of values
This function assumes that its arguments are a sample of the population.
This function differs from STDEV because it accepts text or logical values as well as numeric values.

## Examples

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