STDEVA()
Syntax. STDEVA(value1,value2,...)
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). The STDEVA function includes text and logical values (TRUE and FALSE).
Arguments
value1 (required) and value2 (optional). At least one and up to 255 value 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 STDEVA() function assumes that its arguments are a sample from the entire population. If your data represents a population, calculate the standard deviation with STDEVPA(). ...
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.
