Using either method, the Chart linear trend/fit or the LINEST function, I get exactly the same answer for the linear fit: Y = 7.3613e-04 X + 1.72632e-01, R^2 = 0.998650Īs far as the speed of drawing the chart, there is a small lag but I don't find it that objectionable. You can change the number format of the values shown in the trend line equation by selecting the equation object, then Format > Object Properties > Numbers and increase the number of decimals for the format. Attachments TREND LINES.ods (48.4 KiB) Downloaded 708 times Not sure if I am missing something or not. 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).
#Show the equations for trend line in excel for mac manual#
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. The CPU of my machine is Inter P4 3.0G, the memory is 2G.Ĭode: Select all Expand view Collapse view 53.8000000 0.2121636 PS: It's too slow to draw a chart in OO.o, even to draw a chart for 10 pair numbers. When I choose the linear trend line and check on show equation and correlation coefficient. Please try to briefly and clearly tell us: What you want, What you tried, and What happened.
0 kommentar(er)
