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.|
|* 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.office.com
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top