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
=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
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.
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:
Figure 1. STDEV.S_Function
Consider the following points before using Excel STDEV.S function:
- Data values in arguments must represent a sample. If data set corresponds to entire population then use Excel STDEV.P or STDEVP function.
- 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.
- The standard deviation is calculated using “n-1” method.
- Logical values and text representations of numbers supplied directly as an argument in function are evaluated as numbers.
- It ignores text representations of numbers in cell references; however, it evaluates them as numbers, if supplied directly as an argument in the function.
- Text value(s) entered directly as argument causes the function to return #VALUE!