Estimates standard deviation based on a sample (ignores logical values and text in the sample).

The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

STDEV.S takes 1 required argument and 253 optional arguments:

Syntax: STDEV.S(number1, [number2], ... )

#1)
The arguments for the STDEV.S function are:
Argument Required? Description
number1 Required The first number argument corresponding to a sample of a population. You can also use a single array or a reference to an array instead of arguments separated by commas.
number2, ... Optional Number arguments 2 to 254 corresponding to a sample of a population. You can also use a single array or a reference to an array instead of arguments separated by commas.
comments powered by Disqus