=LINEST(A1:A5 B1:B5) entered as an array formula after selecting cell A7.

What else can be a reason for this I really need to do this regression. I have checked that my columns does not contain any blank cells. The array formula returns the value 2 in cell A1 and the value 1 in cell B1. Calculates the statistics for a line by using the least squares method to calculate a straight line that best fits your data, and returns an array that. This problem occurs because the LINEST function is unable to correctly calculate results if you use blank input values. 4 1 Hello, I'm trying to run a simple regression analysis on my Y and X variables but I get this error 'Regression - LINEST () function returns error. This argument can take the form of an explicit cell range (such as D1:D100), the name of a named range, the name of a database range, or an inline constant array. STEYX(A1:A6,B1:B6) yields the standard error of the regression of 0.36515 0.8 FORECAST(6,A1:A6. This argument can take the form of an explicit cell range (such as A1:C100), the name of a named range, the name of a database range, or an inline constant array.ĭata X contains the set of known x-values to be used to determine the regression equation. Fitting a regression line using Excel function LINEST. The dimensions of the returned array depend on the nature of the arguments.ĭata Y contains the set of known y-values to be used to determine the regression line. Returns an array of decimal numbers that are the statistics for a straight line that best fits the input data set. Calculates the straight line that best fits a supplied data set and optionally returns detailed statistics on the regression. For each type of equation, the spreadsheet again uses the Excel function LINEST to find the best-fitting straight line through the data the important.

Excel linest function returns error