The tend line equation displays the equation as: y = 3x + 17, whereas the LINEST() results are correct. This is demonstrated on sheet2, where I set up a very simple chart using data representing the line: y = 3x + 5. One thing I found was that the equation displayed on the chart has an erroneous value for the Y intercept. I have attached a spreadsheet with your data, and you can see below the chart the results of the LINEST() function (by the way I had to change the number format to display more decimal places). What you can use is the LINEST() function, which can more accurately return the slope and Y intercept (and a number of other results from the data analysis which I don't understand, but look in the help manual for a full explanation). ![]() When I set a linear trend line, and ask it to display the equation, there is very few significant digits displayed, and because the slope of the line generated by your data is so flat it is rounded to zero. I just had a play with this, and I am new to it but here is what I found.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |