# How to Use VARA Function in Google Sheets

The VARA function in Google Sheets is useful when you need to calculate the variance of a sample dataset.

The variance is calculated by getting the sum of the squares of each value’s deviation from the mean and divides by the total number of values minus one.

The rules for using the `VARA` function in Google Sheets are as follows:

• The function requires at least two values in the form of specified values or ranges.
• The function then outputs the variance of the provided sample values.

First, let’s understand what we mean by variance.

Variance refers to the numerical value that shows how spread out the data points in a dataset are from the mean. A variance of zero means that all the data is equal to the mean. A greater variance means that values are more spread out.

In statistics, we can get the variance of either the population as a whole or just a sample of that population. To compensate for lack of information, sample variance is slightly higher.

Population variance follows the formula  Σ(xi-x-)/n where n is the number of items. Computing the sample variance is similar, but it subtracts 1 from the denominator n.

Let’s look at a specific use case to use the `VARA` function.

Let’s say we have two species of tree. Our dataset has a size of 200 with 100 different data points for both species. Our main concern is to know the average height (mean) of the trees and the sample variance.

With the `VARA` function, it becomes a straightforward calculation to find the sample variance for each species.

This use case is just one way to use the `VARA` function in Google Sheets. The variance calculation can also help with making decisions in personal and business finance, economics, and social studies.

Now that we know when to use the `VARA` function, let’s learn how to write it in Google Sheets.

## The Anatomy of the VARA Function

The syntax of the `VARA` function is as follows:

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

Let’s look at each term to understand what each of them means.

• We use the equal sign “=”  to start any function in Google Sheets.
• VARA() is our `VARA` function. It calculates the variance based on a sample.
• value1 refers to the first value or range of the sample.
• value2 refers to the additional values or ranges to include in the sample.
• The `VARA` function supports an arbitrary number of arguments.
• `VARA` considers all text values as 0 when calculating. If you want text values to return an error, you can use the `VAR` function instead.
• Remember that we use `VARA` when handling a sample of a population. If you’re working with the entire population, you may want to use the `VARPA` function instead.

## A Real Example of Using VARA Function

Let’s look at a real example of the `VARA` function being used in a Google Sheets spreadsheet.

In the sample table below, we have a dataset in range A1:C102 which describes the heights of two different species of trees: Type A and Type B. Using the `AVERAGE` function, we were able to compute the mean of both species. Using the `VARA` functions, we were also able to get the sample variance of each type of tree.

Note that we use the `FILTER` function to filter out each range by species before computing the mean and sample variance.

To get the sample variance of Type A, we just need to use the following formula:

`=VARA(FILTER(C2:C101,B2:B101 = F1))`

Let’s begin writing it ourselves! In the next section, we’ll look into how to use the `VARA` function step-by-step.

## How to Use VARA Function in Google Sheets

This guide will show you how to get the variance of a sample dataset using the tree height data shown earlier.

Follow these steps to start using the `VARA` function:

1. Select the cell where we’ll place our `VARA` result. In this example, we’ll fill in the sample variance entry under the Type B column.
2. Next, we just have to type the equal sign ‘=‘ to begin the function, followed by ‘VARA(‘.
3. You may see a tooltip box with information on using the `VARA` function. Click on the arrow in the top-right-hand corner of the box to minimize it if needed.
4. Next, we need to specify the range of our sample dataset. We can use the `FILTER` function to get the data points in rows where the species is “Type B”.

Afterward, we can hit
Enter on the keyboard to let the function evaluate. Now we know that the variance in the height of species of Type B is 3420.53, which is higher than the variance of Type A. This means that the heights of Type B trees are much more spread out from the mean than those of
other species.

1. How does the VARA function compute for variance?
The `VARA` function simply takes the sum of the squares of each value’s distance from the mean. We then divide the sum by the number of total values minus one.
2. Why does my formula return an error?
Make sure that the dataset contains at least two numbers. If the total number of values is less than two, `VARA` will return a `#DIV/0!` error.

This step-by-step guide shows you how easy it is to find the sample variance of a given dataset.

You can now use the VARA functions in Google Sheets together with the various other Google Sheets formulas available to create powerful worksheet solutions.

Make sure to subscribe to our Google Sheets newsletter to be the first to know about the latest guides and tutorials from us.

Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'd love what we are working on! Readers receive ✨ early access ✨ to new content.

## How to Find the Highest N Values in Each Group in Google Sheets

This guide to find the highest N Values in each group in Google Sheets is useful if you…

## How to Use ARRAYFORMULA Function in Google Sheets

The ARRAYFORMULA function in Google Sheets is useful to apply a formula to an entire column in Google…

## How to Use BINOMDIST Function in Google Sheets

The BINOMDIST function in Google Sheets calculates for the binomial distribution or cumulative distribution of the probability. The…

## How to Convert Time to Decimal in Google Sheets

At times, you may run into a situation where you need to convert time to a decimal number…