The VARA function returns the variance for a mixed sample.
This function is used in statistics to measure the dispersion of data when a data set contains not only numerical values, but also text and logical values.
Syntax
VARA(value1, [value2, ...])
Argument |
Description |
Permitted values |
|---|---|---|
value1 |
First value or sample range |
Numerical values or cell ranges |
[value2, ...] |
(optional) Additional values or ranges that need to be included in the sample |
Numerical values or cell ranges (up to 255 arguments) |
Examples of use
Calculating the sample variance of values in the range
=VARA(A1:A10)
The result will be equal to the sample variance of values in this range.
Calculating the sample variance of several individual values
=VARA(10, 12, 14, 16)
Result: approximately 6.66.
Notes
–If the arguments are not numerical values, they will be ignored.
–If all arguments are equal, the function will return 0.