ProductSolutionsTemplatesResources

INTERCEPT

Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0). Learn more

Video field
Statistical

In Google Sheets, the INTERCEPT function is used to calculate the y-intercept of a linear regression line that best fits a set of given data points.

The y-intercept represents the value of the dependent variable (y) when the independent variable (x) is equal to zero.

The syntax for the INTERCEPT function is as follows:

INTERCEPT(datay, datax)

Here's a breakdown of the function's parameters:

data_y: This is the range or array of dependent variable values (y-values) for which you want to calculate the y-intercept.

datax: This is the range or array of independent variable values (x-values) corresponding to the dependent variable values in datay.

The INTERCEPT function returns the y-intercept of the linear regression line as the output.

Please note that the INTERCEPT function assumes a linear relationship between the variables and calculates the best-fit line using the least squares method.

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!