This post will guide you how to use the **VARA function** with syntax and examples in Microsoft excel.

Table of Contents

### Description

The Excel VARA function returns the variance of a population based on a sample of numbers, text, or logical values. The variance is used to identify the amount that the values vary from the average value across a set of values. And if you want to calculate the variance for an entire population, you can use the VARP function or the newer VAR.P function.

The VARA function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function.

The VARA function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

### Syntax

The syntax of the VARA function is as below:

=VARA(value1, [value2], ..)

Where the VARA function arguments are:

**Value1**-This is a required argument. The first number, text or logical value or cell reference in a sample of a population.**Value2**-This is an optional argument. Value arguments 2 to 255 corresponding to a sample of a population. And it can only accept up to 30 number arguments in Excel 2003 or older.

**Note:**

- Arguments can be the following: numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference.
- Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
- The VARA function is only used for its arguments are a sample of the population. And if the argument represents the entire population, you need to use the VARAP function to calculate the variance.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
- If the argument contain the logical values and text representations of numbers and those values will be counted.
- VARA uses the following formula:

### Excel VARA Function Examples

The below examples will show you how to use Excel VARA Function to calculate the variance for data that represents a sample of the population.

**1# **to get variance of a sample of data, using the following formula:

=VARA(A1:A2)

### Related Functions

- Excel VAR Function

The Excel VAR function returns the variance of a population based on a sample of numbers. This function has been replaced by the VAR.S function in Excel 2010. The syntax of the VAR function is as below:=VAR(number1,[number2],…)… - Excel VARP Function

The Excel VARP function returns the variance of a population based on an entire population of numbers. The syntax of the VARP function is as below:=VARP(number1,[number2],…)… - Excel VARPA Function

The Excel VARPA function returns the variance of a population based on an entire population of numbers, text, or logical values. The syntax of the VARPA function is as below:= VARPA (value1, [value2], ..)…

## Leave a Reply

You must be logged in to post a comment.