Statistical
STDEV 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

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 2003 and above.
Remarks
 STDEV is deprecated. Use STDEV.S instead. See
What's a
'Deprecated' Function in Excel? for a list of deprecated
functions and their replacement.
 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 STDEV.P.
 The standard deviation is estimated using the
"nonbiased" or "n1" method.
 Arguments can 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.
