RINTERCEPT returns 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.
SYNTAX:
RINTERCEPT(X Cell Range,Y Cell Range)
X Cell Range: The cell range for the X-Axis data.
Y Cell Range: The cell range for the Y-Axis data
EXAMPLES:
=RINTERCEPT(E9:E14,C9:C14)
See Also: RCORRCOEFF, RSLOPE