jaeatlantic.blogg.se - Openoffice calc standard deviation

The function calculates the sample standard deviation of the given population

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

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

If a cell contains 0 then the function includes it.

For logical values, TRUE is considered as 1 and FALSE is considered as 0.

If a cell contains text, error value, or empty cells, then the function ignores these values.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 returns an error value (Err:504).If only one value is passed the function will return 0.

, Number 255 are real numbers, an array of real numbers, reference to a cell or to cell ranges of numbers. Returns a non-negative real number which is the population standard deviation of a set of numbers passed in the arguments. Calculates the population standard deviation of a set of numbers.