Calculates the variance based on a sample of data.
تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.
VAR(number1, [number2], …)The VAR 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(10, 12, 23, 23, 16, 23, 21, 16)النتيجة: 28.57143
Calculates the sample variance of the provided set of numbers.
VAR calculates variance based on a sample, while VARP calculates variance based on the entire population.