![]() Frequently, INTERCEPT includes 2 ranges of cells containing the data, such as INTERCEPT(A1:A100, B1:B100). The arguments, known_y's and known_x's, must be arrays or cell ranges that contain equal numbers of numeric data values. The INTERCEPT( known_y's, known_x's) function returns the INTERCEPT of the linear regression line that is used to predict y values from x values. ![]() This article discusses the INTERCEPT function in Microsoft Excel, illustrates how to use the function, and compares its results for Excel 2003 and for later versions of Excel with its results in earlier versions of Excel. For more information about this change, read this blog post. Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise.
0 Comments
Leave a Reply. |