Note the first two, slope and intercept are returned by default. The table below shows the statistics that can be returned by the LINEST function. In other versions of Excel, you must enter the LINEST as a multi-cell array formula to see all values. ![]() In Excel 365, which supports dynamic arrays, the array of values will spill into cells in the worksheet automatically. Optionally, LINEST can also return 10 separate statistics for the regression analysis as shown in the worksheet above. In its most basic form, LINEST returns just intercept and slope. The LINEST function returns more than one value at a time in an array. ![]() ![]() The LINEST function returns statistics for a best fit straight line through supplied x and y values. The values returned by LINEST include slope, intercept, standard error values, and more, up to 10 different statistics in total. To find the best fit of a line to the data, the LINEST function uses the "least squares" method, the standard approach in regression analysis.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |