VARS

Calculates the sample variance of a dataset to measure how widely values are spread from the mean.

The VARS function returns the sample variance of a dataset. It measures how widely values are spread from the mean when the data represents a sample of a larger population. The calculation uses (n − 1) in the denominator to provide an unbiased estimate.

Syntax#

VARS(number1, [number2], ...)

Arguments#

The VARS function syntax has the following arguments:

• number1, number2, ... - The numeric values for which you want to calculate the sample variance. Required.

Example#

VARS(10, 20, 30)
// Returns 100
VARS(10, 20, 30, 40, 50)
// Returns 250

You can use the VARS function to analyze how widely values are spread from the mean by calculating the sample variance for metrics such as sales, revenue, or performance scores.

VARS(SELECT([Revenue], 1, 4))

Excel Equivalent#

VARS

FAQs#

Q1. How is VARS calculated?

VARS (Sample Variance) is calculated by taking the sum of squared deviations from the mean and dividing it by (n − 1).

Where:

• x = each value in the dataset
• = mean of the values
• n = number of values

It measures how widely the values are spread from the mean by calculating the sample variance, which represents the average squared deviation from the mean.