what's the difference between variance population and variance sample, what's their excel formulas?

Answer:The major difference between both the variance of population and sample variance is the estimation of varianceStep-by-step explanation:The major difference between both the variance of population and sample variance is the estimation of variance. In five steps, the variance is measured. Firstly mean is determined, then deviations from the average is estimated, and thirdly the resulted deviations are squared, fourthly the resulted square deviations are added up and finally, this summation value is divided by the number of entities for which the variance is measured.when variance is calculated from population data, n is taken as total number of entities.  However when variance is calculated from sample data, one is deducted from total entities.Population variance [tex]\sigma^2 =  \frac{\sum_{i =1}^{n}(x_i - x_{avg})^2}{n}[/tex]sample variance [tex]\sigma^2 = \frac{\sum_{i =1}^{n}(x_i - x_{avg})^2}{n-1}[/tex]