Calculates the y-intercept of a linear regression line using existing x and y values.
Syntax
INTERCEPT(known_ys, known_xs)Arguments
known_ysrequired
The dependent set of observations or data.
known_xsrequired
The independent set of observations or data.
The INTERCEPT function determines the point where a line intersects the y-axis by using the best-fit linear regression line through the provided data points. It is commonly used to analyze the relationship between two variables when one is dependent on the other. The function uses the formula a = ȳ - bx, where b is the slope calculated by the SLOPE function.
=INTERCEPT({2,3,9,1,8}, {6,5,11,7,5})→0.048Calculates the y-intercept for the provided sets of y and x values.
Prepare your data
Organize your dependent variables (y) and independent variables (x) into two separate ranges or arrays.
Enter the formula
Select a cell and type =INTERCEPT(known_ys, known_xs), replacing the arguments with your data ranges.
The INTERCEPT function ignores cells that contain text, logical values, or empty cells.