Calculates the population standard deviation of a set of numbers, including values of type Text and Logical.
VARPA(Number 1[; Number 2[; ...[; Number 255]]])
Returns a non-negative real number which is the population standard deviation of a set of numbers passed in the 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.
- 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.
|=VARPA(3;4;5;6;2;3;1)||The function calculates the variance of the given population||2.53061224489796|
|=VARPA(3;4;5;6;2;3;1;"alpha")||The function calculates the variance of the given population. Text has the value 0.||3.5|
|=VARPA(A1:A5) where A1:A5 contains 1,2,3,4,5||The function calculates the variance of the population passed as a reference to the cell.||2|
|=VARPA(3,4,-5,6.05,2,3,-1.5)||The function calculates the sample variance of the given population||11.8278571428571|
|=VARPA(A1:A6) where A1:A6 contains 1,2,3,4,5, alpha(text)||The function calculates the variance of the population passed as a reference to the cell. Text has the value 0.||2.91666666666667|
|=VARPA(3)||The function will returns 0 since only one argument is passed.||0|
Related LibreOffice functions:
Equivalent Excel functions: