What's the difference between VAR and VARP?

[Michel Walsh]

Hi,


Variance of a sample and variance of a population. One divide by n-1,
since one degree of freedom has been spent to estimate the mean, while the
other divide by n, not n-1.


{1, 2, 3, 4}, n=4; mean= 2.5,


1.5^2 + .5^2 +.5^2 +1.5^2 = 5


so, StDev: ( 5/ (4-1) ) ^ 0.5 = 1.29099...
StDevP: ( 5/ 4) ^ 0.5 = 1.1180...



Hoping it may help,
Vanderghast, Access MPV

 

[news.microsoft.com]

In Jet SQL, there two aggregate functions: VAR and VARP. And what's
difference bettween these two funtions? How to use them?

 

[news.microsoft.com]

Thank you very much!