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.