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).


  • 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.


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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.