VARP Function Explained
The VARP function in Microsoft Excel calculates the variance of a population based on a sample of numbers. It takes up to 255 arguments, which can be numbers, cell references, or ranges. It returns the variance of the population, which is a measure of how far the numbers in the sample are spread out from their average value.
VARP Function Syntax
VARP(number1, [number2], ...)
number1: The first number, cell reference, or range for which you want to calculate the variance.number2: (optional) Additional numbers, cell references, or ranges for which you want to calculate the variance.