ProductSolutionsTemplatesResources

COVAR

Calculates the covariance of a dataset. Learn more

Video field
Statistical

In Google Sheets, the COVAR function is used to calculate the covariance between two sets of data. It measures the degree to which the variables vary together or the extent of their linear relationship.

The syntax for the COVAR function is as follows:

COVAR(datay, datax)

data_y: This is the range or array of values representing the dependent variable or the y-values in the data set.

data_x: This is the range or array of values representing the independent variable or the x-values in the data set.

The COVAR function calculates the covariance, which is a measure of how much two variables change together. A positive covariance indicates a positive linear relationship, while a negative covariance indicates a negative linear relationship. The magnitude of the covariance does not provide a standardized measure of the strength of the relationship.

Visit Official Docs

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!