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

STDEVA

Estimates standard deviation based on a sample, setting text to the value `0`.
 

Sample Usage

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

Syntax

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

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

Examples

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