# Documentation/Calc Functions/STDEVA

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

STDEVA

## Category:

Statistical Analysis

## Summary:

Calculates the sample standard deviation of a set of numbers. The value of text is 0.

## Syntax:

STDEVA(**Number 1**[; **Number 2**[; ...[; **Number 255**]]])

## Returns:

Returns a non-negative real number which is the estimated sample standard deviation based on the numbers passed in the arguments.

## Arguments:

**Number 1**, **Number 2**, ..., **Number 255** are numbers, references to cells or to cell ranges of numbers.

- The parameters should specify at least two values. If there are less than two values, then the function will return a division (#DIV/0!) error.
- If any of the arguments contain text values either being passed directly then the function returns a name (#NAME?) error and if passed with double quotes then the function recognizes it as text and uses 0 for that value.
- If a cell contains text, error value, or empty cells, then the function uses the value 0 for them. For logical values, TRUE is considered as 1, and FALSE is considered as 0. However, empty cells are ignored.
- If a cell contains 0 then the function includes it.

## Additional details:

- The formula for STDEVA is:

where s is the standard deviation, x_{i} is **Number i**, n is the count of x_{i}'s and x̄ is mean value.

- For more details on standard deviation, visit Wikipedia.

## Examples:

Formula | Description | Returns |
---|---|---|

=STDEVA(3;4;5;6;2;3;1) | The function calculates the sample standard deviation of the data | 1.71824938596845 |

=STDEVA(3;4;5;6;2;3;1;"alpha") | The function calculates the sample standard deviation of the data. Text has value 0. | 2 |

=STDEVA(3,4,-5,6.05,2,3,-1.5) | The function calculates the sample standard deviation of the data | 3.71472295961175 |

=STDEVA(3,"alpha",-5,6.05,2,3,-1.5) | The function calculates the sample standard deviation of the data. Text has value 0. | 3.59882586673037 |

=STDEVA(A1:A6) where A1:A5 contains 1,2,3,4,5, alpha(text) | The function calculates the sample standard deviation of the data passed as a reference to the cells. Text has value 0. | 1.87082869338697 |

=STDEVA(3) | The function will return a division error since less than 2 arguments are available. | #DIV/0! |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

STDEVA