STDEVPA()
Syntax. STDEVPA(value1,value2,...)
Definition. This function calculates the standard deviation based on a population indicated as arguments, including text and logical values. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Arguments
value1 (required) and value2 (optional). At least one and up to 255 values (30 in Excel 2003 and earlier versions) corresponding to a population. You can also use a single array or a reference to an array instead of arguments separated by commas.
Note
The STDEVPA() function assumes that its arguments are the entire population. If your data represents a sample of the population, calculate the standard deviation with STDEVA().
Arguments that contain TRUE ...
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.