If there are multiple ranges of x-values, where the dependent y-values are a function of the independent x-values.
Instructions follow the examples in this article. Because this function returns an array of values, it must be entered as an array formula. You can also combine LINEST with other functions to calculate the statistics for other types of models that are linear in the unknown parameters, including polynomial, logarithmic, exponential, and power series. The LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line. Find links to more information about charting and performing a regression analysis in the See Also section. This article describes the formula syntax and usage of the LINEST function in Microsoft Excel.
0 kommentar(er)
