Calculates the variance based on a sample of data.
Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.
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)Wynik: 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.