Documentation/Calc Functions/VARPA

Function name:
VARPA

Category:
Statistical Analysis

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

Syntax:
VARPA(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 VARPA is:

where xi is Number i, n is the count of xi's and x̄ is mean value.
 * For more details on the variance of the entire population, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/VAR VAR]

[[Special:MyLanguage/Documentation/Calc_Functions/VAR.S VAR.S]

[[Special:MyLanguage/Documentation/Calc_Functions/VARA VARA]

[[Special:MyLanguage/Documentation/Calc_Functions/VAR.P VAR.P]

[[Special:MyLanguage/Documentation/Calc_Functions/VARP VARP]

[[Special:MyLanguage/Documentation/Calc_Functions/STDEV STDEV]

[[Special:MyLanguage/Documentation/Calc_Functions/STDEV.P STDEV.P]

[[Special:MyLanguage/Documentation/Calc_Functions/STDEV.S STDEV.S]

[[Special:MyLanguage/Documentation/Calc_Functions/STDEVA STDEVA]

[[Special:MyLanguage/Documentation/Calc_Functions/STDEVP STDEVP]

[[Special:MyLanguage/Documentation/Calc_Functions/STDEVPA STDEVPA]

ODF standard:
Section 6.18.85, part 2

Equivalent Excel functions:
VARPA