Documentation/Calc Functions/STDEVPA

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

STDEVPA

Category:

Statistical Analysis

Summary:

Calculates the population standard deviation of a set of numbers, including values of type Text and Logical.

Syntax:

STDEVPA(Number 1[; Number 2[; ...[; Number 255]]])

Returns:

Returns a non-negative real number which is the population standard deviation of a set of numbers passed in the arguments.

Arguments:

Number 1, Number 2, ..., Number 255 are real numbers, an array of real numbers, reference to a cell or to cell ranges of numbers. Text has the value 0.

  • If only one value is passed the function will return 0.
  • If any of the arguments contain text value being passed with double quotes then the function uses the value 0 for that text. However, if the text is passed without double quotes then the function returns a name (#NAME?) error.
  • If a cell contains text, logical values, error value, 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 STDEVPA is:
Stdev.p n.png

where s is the standard deviation of the population, xi is Number i, n is the count of xi's and x̄ is mean value.

  • For more details on the standard deviation of the entire population, visit Wikipedia.

Examples:

Formula Description Returns
=STDEVPA(3;4;5;6;2;3;1) The function calculates the sample standard deviation of the given population 1.59078981795143
=STDEVPA(3;4;5;6;2;3;1;"alpha") The function calculates the sample standard deviation of the given population. Text has the value 0. 1.87082869338697
=STDEVPA(3,4,-5,6.05,2,3,-1.5) The function calculates the sample standard deviation of the given population 3.43916518109514
=STDEVPA(A1:A5) where A1:A5 contains 1,2,3,4,5 The function calculates the sampe standard deviation of the population passed as a reference to the cells. 1.4142135623731
=STDEVPA(A1:A5) where A1:A5 contains 1,2,3,4,5, alpha(text) The function calculates the sample standard deviation of the population passed as a reference to the cells. Text has the value 0. 1.70782512765993
=STDEVPA(3) The function will returns 0 since only one argument is passed. 0

Related LibreOffice functions:

STDEV

STDEV.S

STDEVA

STDEV.P

STDEVP

VAR

VAR.P

VAR.S

VARA

VARP

VARPA

ODF standard:

Section 6.18.75, part 2

Equivalent Excel functions:

STDEVPA