The LINEST function returns more than one value at a time in anarray.
In its most basic form, LINEST returns just intercept and slope.
Optionally, LINEST can also return 10 separate statistics for the regression analysis as shown in the worksheet above.
InExcel 365, which supportsdynamic arrays, the array of values will spill into cells in the worksheet automatically.
In other versions of Excel, you must enter the LINEST as amulti-cell array formulato see all values.
Available Statistics
The table below shows the statistics that can be returned by the LINEST function.
Note the first two, slope and intercept are returned by default.
The other statistics are returned by setting thestatsargument to TRUE.
When all statistics are returned, they are delivered in a 2Darray, 5 rows by 2 columns.
In the worksheet shown above, the range F4:G8 shows the order in which statistics are returned.
Examples
By default, LINEST returns just two statistics, slope and intercept.
A regression line is a “best fit” line based on known data points.
