STDEV.S()/STDEV()
Syntax. STDEV.S(number1,number2,...)
Definition. This function estimates the standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Arguments
number1 (required) and number2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) corresponding to a sample of the population. You can also use a single array or a reference to an array instead of arguments separated by commas.
Note
The STDEV.S() function assumes that its arguments are a sample of the entire population. If the data passed as arguments are a population, calculate the standard deviation with the STDEV.P() function.
The calculated standard deviation is an ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.