Calculates the variance based on a sample, including numbers, text, and logical values.
الصيغة
VARA(value1, [value2], ...)المعاملات
value1مطلوب
The first value or range of values to include in the calculation.
value2اختياري
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.