VARA Function Explained
The VARA
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 sample as a number.
VARA Function Syntax
VARA(data, [alpha])
data
– An array or range of numeric values.alpha
– (Optional) A significance level used to calculate the confidence level. The default value is 0.05.