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

STDEV

Estimates standard deviation based on a sample.
 

Sample Usage

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

Syntax

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

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

Examples

STDEV(1,2,3,4) returns a value of 1.2909
STDEV(A2:A6) returns the standard deviation of the numbers in cells A2 through A6.
 

Notes

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