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

STDEVS

Estimates standard deviation based on a sample.

Sample Usage

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

Syntax

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

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

Examples

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