Documentation/Calc Functions/STDEVA

From The Document Foundation Wiki
Jump to: navigation, search

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:
Stdev n.png

where s is the standard deviation, xi is Number i, n is the count of xi'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:

STDEV.P

STDEV.S

STDEV

STDEVP

STDEVPA

VAR

VAR.P

VAR.S

VARA

VARP

VARPA

ODF standard:

Section 6.18.73, part 2

Equivalent Excel functions:

STDEVA