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

STDEV.S

Estimates standard deviation based on a sample.

Sample Usage

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

Syntax

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

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

Examples

STDEV.S(1,2,3,4) returns a value of 1.2909
STDEV.S(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.S will return an error.
  • STDEV.S will ignore any cells that include text and logical values. To calculate variance while interpreting text values as 0, use STDEVA.
  • STDEV.S calculates variance for a sample. To calculate variance for an entire population, use STDEV.P.