VAR.S()/VAR()
Syntax. VAR.S(number1,number2,...)
Definition. This function estimates the variance based on a sample. VAR.S() indicates how the data are distributed around 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
Note
The VAR.S() function assumes that its arguments are a sample of the entire population. If the data passed as arguments is a population, calculate the associated variance with the VAR.P() function.
Logical values (TRUE and FALSE) and text are ignored. If you want to include logical values and text in the calculation, use the VARA() function.
Background. The most commonly used spreads in statistics ...
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.
