The intercept point is based on a regression line plotted with known x and y values.
A regression line is a line that best fits that known data points.
The INTERCEPT function takes twoarguments,known_ysandknown_xs, which should be arangeorarrayof numeric values.
Theknown_ysrepresent dependent values andknown_xsrepresent independent values.
Both arguments must contain the same number values, or INTERCEPT will return #N/A.
A regression line is a “best fit” line based on known data points.
The values returned by LINEST include slope, intercept, standard error values, and more.
