SheetFX
≡
<< Go back to all functions

INTERCEPT

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).

Function Syntax and Parameters

Syntax: INTERCEPT(data_y, data_x)

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