Calculates the variance based on a sample, including numbers, text, and logical values.
Cú pháp
VARA(value1, [value2], ...)Đối số
value1bắt buộc
The first value or range of values to include in the calculation.
value2tùy chọn
Additional values or ranges, up to 254 arguments.
The VARA function estimates variance based on a sample of data. Unlike the VAR.S function, VARA evaluates text and logical values (TRUE/FALSE) within references, treating text as 0 and TRUE as 1.
=VARA(10, "text", TRUE)→25Calculates variance for 10, 0 (text), and 1 (TRUE).
Select a cell
Click on the cell where you want to display the variance result.
Enter the formula
Type =VARA() and insert your data range or values inside the parentheses.
VARA treats text strings as the number 0.