Re: Simple variance question (Microsoft Excel)
When the full population of values is known, the true variance of the population is the sum of squared deviations from the mean, divided by the size of the population, VARP.
When only a sample from the full population is known, then the unbiased estimator of the population variance is the sum of squared deviations from the sample mean, divided by the size of the sample minus one, VAR.
|