VAR(area1,area2,…)
area1: first cell area
area2: second cell area
VAR is also known as the N-1-variance.
Since the N-1-variance includes Bessel's correction, whereas the N-variance calculated by VARPA or VARP does not, under reasonable conditions the N-1-variance is an unbiased estimator of the variance of the population from which the sample is drawn.
This function is Excel compatible.