Excel will then calculate and display the variance value based on the population formula. If your dataset is a sample rather than the entire population, use the `VAR.S` function instead.