SheetFX
Back to Functions

INTERCEPT

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

StatisticalINTERCEPT(data_y, data_x)

The INTERCEPT function in Google Sheets is used to calculate the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).

Parameters

  • data_y: The array or range containing the dependent variable data points.
  • data_x: The array or range containing the independent variable data points.

Step-by-Step Tutorial

  1. Using INTERCEPT to calculate the y-intercept:
    • Example: =INTERCEPT(A1:A10, B1:B10)

Use Cases and Scenarios

  1. Linear Regression: Calculate the y-intercept for a given dataset.

Related Functions

  • None

Related Articles

  • None

Newsletter

More INTERCEPT examples coming soon.

We are building short, practical updates for Sheets power users.