Variance measures how far a set of numbers are spread out from their average value.
Try it with AIIn Excel, variance is calculated as the average of the squared differences from the mean. It provides a numerical measure of data volatility, where a higher value indicates that data points are spread further from the mean.
=VAR.P(range) or =VAR.S(range)If you have test scores of 80, 85, and 90, the variance helps quantify the consistency of these scores relative to the mean of 85.
VAR.P calculates variance for an entire population, while VAR.S calculates it based on a sample of the population.