Excel STDEV.S Function

Excel STDEV.S Function

Excel STDEV.S function estimates standard deviation based on a sample, ignoring logical and text values in the sample. This tutorial will show you the definition and implementation of STDEV.S Function in Excel

Formula

=STDEV.S (number1, [number2], ...)

Excel STDEV.S function syntax has the following arguments:

number1 (required) – It is the first argument of a sample

[number2], … (optional) – These are the additional argument of sample

Explanation

Excel STDEV.S function has been introduced to replace STDEV function in Excel 2010 and later. It estimates the standard deviation of sample data set ignoring logical and text values. Total 255 arguments can be supplied in Excel STDEV.S function

Arguments of Excel STDEV.S function can be numbers, arrays, named ranges or cell references. These arguments may contain numbers, text values, logical values, and empty cells. Excel STDEV.S function evaluates numbers, excluding text, logical values and empty cells in cell references of sample data.

Text representations of numbers in cell references are considered as text values and are ignored in the calculation. However, text representations of numbers supplied directly as an argument in Excel STDEV.S function are evaluated as numbers.

Example

For example, you have a sample of values including text values and you need to estimate the standard deviation of sample values, excluding text values found in cell references. Excel STDEV.S function is used in the following formula:

=STDEV.S(A2:A11)

 

Figure 1. STDEV.S_Function

Notes

Consider the following points before using Excel STDEV.S function:

  1. Data values in arguments must represent a sample. If data set corresponds to entire population then use Excel STDEV.P or STDEVP function.
  2. It ignores text values, logical values, and empty cells in cell references. If you want to evaluate text and logical values in cell references of sample data set then use STDEVA function.
  3. The standard deviation is calculated using “n-1” method.
  4. Logical values and text representations of numbers supplied directly as an argument in function are evaluated as numbers.
  5. It ignores text representations of numbers in cell references; however, it evaluates them as numbers, if supplied directly as an argument in the function.
  6. Text value(s) entered directly as argument causes the function to return #VALUE!

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar