VARA
Returns the sample variance (allowing text and logical values).
Syntax:
VARA(number1, number2, ... number30)
number1 to number30 are up to 30 numbers or ranges containing numbers. Logical values and text may also be included.
VARA returns the standard deviation where number1 to number30 are a sample of the entire population.
Logical values are regarded as 1 (TRUE) and 0 (FALSE).
Text values are always regarded as zero.
With N values in the sample, the calculation formula is:
Example:
VARA(2, 6, 4)
returns 4.
VARA(B1:B3)
where cells B1, B2, B3 contain red, TRUE, and 2 returns 1, the variance of 0, 1 and 2.
PRODUCT & FEATURES
CAPTCHA Protection
RESOURCES
© 2023 Zapof