For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

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, 2005-2014
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 "n-1" 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:
    Formula that calculates the STDEV function

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Example of Excel's STDEV.S function.

 

Other Help

Related Functions

For a complete list of related functions, see Microsoft's page of Statistical Functions.

 

Charley's SwipeFile charts


Free Excel Dashboards