# Documentation/Calc Functions/STDEV.P

STDEV.P

## Category:

Statistical Analysis

## Summary:

Calculates the population standard deviation of a set of numbers.

## Syntax:

STDEV.P(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.

• If only one value is passed the function will return 0.
• 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 a cell contains text, error value, or empty cells, then the function ignores these values. For logical values, TRUE is considered as 1 and FALSE is considered as 0.
• If a cell contains 0 then the function includes it.

• The formula for STDEV.P is:

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
=STDEV.P(3;4;5;6;2;3;1) The function calculates the sample standard deviation of the given population 1.59078981795143
=STDEV.P(A1:A5) where A1:A5 contains 1,2,3,4,5 The function calculates the sample standard deviation of the population passed as a reference to the cells. 1.4142135623731
=STDEV.P(3,4,-5,6.05,2,3,-1.5) The function calculates the sample standard deviation of the given population 3.43916518109514
=STDEV.P(3,"alpha",-5,6.05,2,3,-1.5) The function returns an error value since one of the numbers is a string. Err:504
=STDEV.P(3) The function will returns 0 since only one argument is passed. 0

STDEV

STDEV.S

STDEVA

STDEVP

STDEVPA

VAR

VAR.P

VAR.S

VARA

VARP

VARPA

None

STDEV.P