# INTERCEPT

INTERCEPT(known_y's, known_x's)

Returns the intersection with the y-axis using a linear regression plotted through known values.

 known_y's The dependent set of observations or data. known_x's The independent set of observations or data.

 REMARKS
 * Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the intercept when you want to determine the value of the dependent variable when the independent variable is 0 (zero).* The arguments should be either numbers or names, arrays, or references that contain numbers.* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.* If "known_y's" and "known_x's" contain a different number of data points or contain no data points, then #N/A is returned.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =INTERCEPT({2, 3, 9, 1, 8}, {6, 5, 11, 7, 5}) = 0.048 2 =INTERCEPT({2, 4, 6}, {6, 3, 8}) = 2.211 3 =INTERCEPT({2, 4, 6}, {6, 3, 8, 2, 3, 7}) = #N/A 4 =INTERCEPT("some text", {6, 3, 8}) = #N/A