VARPA Function Explained
The VARPA Function in Microsoft Excel calculates the variance of a population based on a supplied set of values. It takes up to 255 arguments, which can be numbers, cell references, or ranges. It returns the population variance of the supplied arguments.
VARPA Function Syntax
VARPA(data, [alpha])
- data: The array or range of data for which you want to calculate the variance.
- [alpha]: Optional. The significance level used to calculate the confidence interval for the variance. The default value is 0.05.