Statistical
STDEV.S Function
Estimates the standard deviation based on a sample of values or selected database entries.
by
Charley Kyd, MBA Microsoft Excel MVP, 20052014
The Father of Spreadsheet Dashboard Reports

STDEV.S
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).
Syntax
STDEV.S(number1,[number2],...)

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
population. You can also use a single array or a reference
to an array instead of arguments separated by commas.
Applies To
Excel 2010 and above.
Remarks
 STDEV assumes that its arguments are a sample of the
population. If your data represents the entire population,
you should calculate the standard deviation using STDEVP.
 The standard deviation is calculated using the
"nonbiased" or "n1" method.
 Arguments can either be numbers, names, arrays, or
references that contain numbers.

If an argument is an array or reference, only numbers in
that array or reference are counted. Empty cells, logical
values, text, or error values in the array or reference are
ignored.
 Arguments that are error values or text that cannot be
translated into numbers cause errors.
 Cell C7 in the Example below shows an Excel version of
the formula for this function, shown here:
Examples
You can
download this example workbook here,
along with all other example workbooks I've completed for this
Excel help area.
Other Help
Related Functions
For a complete list of related functions, see
Microsoft's page of Statistical Functions.
