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.