LINEST Function
The LINEST function is one of the statistical functions. It is used to calculate 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; because this function returns an array of values, it must be entered as an array formula.
Syntax
LINEST(known_y's, [known_x's], [const], [stats])
The LINEST function has the following argument:
| Argument | Description |
|---|---|
| known_y's | A known range of y values in the equation y = mx + b. This is the required argument. |
| known_x's | A known range of x values in the equation y = mx + b. This is an optional argument. If it is omitted, known_x's is assumed to be the array {1,2,3,...} with the same number of values as known_y's. |
| const | A logical value that specifies if you want to set b equal to 0. This is an optional argument. If it is set to TRUE or omitted, b is calculated normally. If it is set to FALSE, b is set equal to 0. |
| stats | A logical value that specifies if you want to return additional regression statistics. This is an optional argument. If it is set to TRUE, the function returns the additional regression statistics. If it is set to FALSE or omitted, the function does not return the additional regression statistics. |
Notes
Please note that this is an array formula. To learn more, please read the Insert array formulas article.
How to apply the LINEST function.
Examples
The first value of the resulting array will be displayed in the selected cell.
Host ONLYOFFICE Docs on your own server or use it in the cloud
Article with the tag:
Browse all tags