However, we usually use the sum of the squared residuals (variously abbreviated SSR, RSS, SSE) or RSQ to measure fit. With the estimated y-values in Z1:Z23000, the percentage difference for Y1 is: You can vote as helpful, but you cannot reply or subscribe to this thread. With your x-data in X1:X23000 and y-data in Y1:Y23000, select A1:B1 (2 horizontal cells) and array-enter (press ctrl+shift+Enter instead of just Enter) the following formula: How does one increase the number of significant figures reported in a linear trendline equation (my results only give the slope and intercept to one significant figure) This thread is locked. But for exponential trendlines, that requires a little finesse, which might be overwhelming. Now you can copy-and-paste the coefficients into your spreadsheet.Īlternatively, you could use LINEST to calculate the coefficients directly in your spreadsheet.
I prefer Scientific with 14 decimal places, because that displays all coefficients with the greatest precision that Excel formats, regardless of magnitude.īut in your case, Number with 9 decimal places would probably suffice (the smallest coefficient with 6 significant digits). On the right, click a Category and enter a number of decimal places. Right-click the trendline label, click Format Trendline Label, Number. For a Line chart, the trendline is based on x=1,2,3,etc instead of the actual values on the x-axis. If you are getting the formula from your own chart, you can change the format of the trendline label to show greater precision.įirst, be sure that you are using an XY Scatter chart, not a Line chart.
