Calculates the variance based on a sample of data.
الصيغة
VAR.S(number1, [number2], ...)المعاملات
number1مطلوب
The first number or range corresponding to a sample population.
number2اختياري
Additional numbers or ranges up to 254 arguments.
The VAR.S function estimates variance based on a sample of a population. It ignores logical values and text contained in references, focusing only on numeric data points.
=VAR.S(10, 12, 23, 23, 16, 23, 21, 16)→28.57Calculates the sample variance of the provided set of eight numbers.
Select a cell
Click on the cell where you want to display the variance result.
Enter the formula
Type =VAR.S( and select the range of cells containing your sample data, then close the parenthesis.
VAR.S is used when your data is a sample of the population, while VAR.P is used when your data represents the entire population.