VAR

Calculates the variance based on a sample. Learn more

Video field
Statistical

In Google Sheets, the VAR function is used to calculate the variance of a sample or a population based on a set of values. The syntax of the VAR function is as follows:

VAR(value1, [value2, …])

Here's a breakdown of the components:

value1, value2, and so on: These are the individual values or cell references representing the dataset for which you want to calculate the variance.

You can include multiple values or cell references separated by commas.

The VAR function calculates the variance of the dataset using the following formula:

Variance = Sum of Squares of Differences / Number of Data Points

The variance measures the dispersion or spread of data points around the average. It provides an indication of how much the individual values in the dataset deviate from the mean.

The higher the variance, the more the data points are spread out from the mean.

It's important to note that if you want to calculate the variance of an entire population, you should use the VAR.P function.

If you want to calculate the variance of a sample, you should use the VAR.S function. The VAR function in Google Sheets assumes a sample variance calculation by default.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!