![Excel linest function returns error](https://kumkoniak.com/74.jpg)
![excel linest function returns error excel linest function returns error](https://newtonexcelbach.files.wordpress.com/2015/06/linest5-9.png)
It is important to note that in the event that there are more variables x, the number of columns may vary according to their number, but there will always be 5 rows. Since we have only one variable x, it is necessary to select a range consisting of two columns and five rows. For example, on the A1:B6 range, we will build a table with the ratio of y and x corresponding to the amount of money earned by the student for a period of 5 months. Now, using the example of solving the second task, let's analyze the need for displaying not only the slope and segment, but also additional statistics. The result of applying the function becomes:
![excel linest function returns error excel linest function returns error](https://newtonexcelbach.files.wordpress.com/2020/03/linest6-4.png)
Knowns_y’s is the set of values of y, which are already known for the relation y = mx + b.To work with the function, you must fill in at least 1 required and, if necessary, 3 optional arguments: The general syntax of the LINEST function call is as follows: The function returns an array that describes the resulting straight line.
#Excel linest function returns error series
LINEST function calculates statistics for a series using the least squares method, calculating a straight line that best approximates the available data. Meaning of the output statistical information functions LINEST
![Excel linest function returns error](https://kumkoniak.com/74.jpg)