Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

STDEV.P

Calculates standard deviation based on an entire population.

Sample Usage

STDEV.P(1,2,3,4)
STDEV.P(A2:A6)
STDEV.P(A2:A10, B2:B10)

Syntax

STDEV.P(value1, [value2, ...])

  • value1 - The first number or range of the population.
  • value2, .. - [OPTIONAL] Additional numbers or ranges to include in the population.

Examples

STDEV.P(1,2,3,4) returns a value of 1.118
STDEV.P(A2:A6) returns the returns the standard deviation of the numbers in cells A2 through A6, assuming this to be the complete dataset.

Notes

  • A minimum of two values must be supplied as value arguments. Else, STDEV.P will return an error.
  • STDEV.P will ignore any cells that include text and logical values. To calculate variance while interpreting text values as 0, use  STDEVPA.
  • STDEV.P calculates variance for an entire population. To calculate variance for a sample, use STDEV.S.