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