What's the difference between VAR and VARP?

  • Thread starter Thread starter Michel Walsh
  • Start date Start date
M

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
 
In Jet SQL, there two aggregate functions: VAR and VARP. And what's
difference bettween these two funtions? How to use them?
 
Back
Top