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

Statistical

STDEV 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

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 "n-1" 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:
    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 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