![Microsoft.office.interop.excel linestyle Microsoft.office.interop.excel linestyle](/uploads/1/2/5/6/125617649/903182621.png)
![Microsoft Excel Linest Microsoft Excel Linest](/uploads/1/2/5/6/125617649/394886005.jpg)
Microsoft Excel has for many years included a worksheet function called LINEST(), which returns a multiple regression analysis of a single outcome or predicted variable on one or more predictor variables. LINEST() returns a regression equation, standard errors of regression coefficients, and goodness-of-fit statistics.
Description The Microsoft Excel LINEST function uses the least squares method to calculate the statistics for a straight line and returns an array describing that line. The LINEST function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the LINEST function can be entered as part of a formula in a cell of a worksheet. The LINEST function uses the following line equation: y = mx + b (for a single range of x values) y = m1x1 + m2x2 +. + b (for multiple ranges of x values).
Inputting an Array Formula To input an array formula, you need to first highlight the range of cells for the function result. Type your function into the first cell of the range, and press CTRL-SHIFT-Enter.Go to the page for more details. As the Linest function returns an array of values, it must be entered as an. If the function is not entered as an array formula, only the first 'm' value in the calculated array of statistical information will be displayed in your spreadsheet. You can see if a function has been input as an array formula, as curly brackets will be inserted around the formula, as it is viewed in the formula bar.
This can be seen in the examples below. Linest Function Example 1 Cells A2-A10 and B2-B10 of the spreadsheet below list a number of known x- and known y-values, and also shows these points, plotted on a chart. Cells D1-E5 of the spreadsheet show the results of the Excel Linest function, which has been used to return statistical information relating to the line of best fit through these points. As shown in the formula bar, the formula for the Linest function is.