Please try to briefly and clearly tell us: What you want, What you tried, and What happened. When I choose the linear trend line and check on show equation and correlation coefficient. Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left. TREND returns the y-values along that line for the array of newxs that you specify. It fits a straight line (using the method of least squares) to the arrays knownys and knownxs. 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. The TREND function returns values along a linear trend. I just had a play with this, and I am new to it but here is what I found. 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. 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). Display more digits in trendline equation coefficients in Excel.

#More decimals in excel trendline manual# Although a trendline is not fitted to excel column charts generally, you can try adding. I uploaded part of the data to skydrive, please check the link below. However, when I tried to use the original x data to calculate y using the trendline equation, it doesnt appear right. 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). I used excel to fit a curve to some data points (x,y). One thing I found was that the equation displayed on the chart has an erroneous value for the Y intercept. This is demonstrated on sheet2, where I set up a very simple chart using data representing the line: y = 3x + 5. The tend line equation displays the equation as: y = 3x + 17, whereas the LINEST() results are correct.

#More decimals in excel trendline manual#Īttachments TREND LINES.ods (48.4 KiB) Downloaded 715 times Not sure if I am missing something or not.

Excel trendline equation more digits