martpax.blogg.se -

Double-click the trendline equation or R-squared text.

Method 2: Microsoft Office Excel 2003 and earlier versions of Excel

In the Category list, click Number, and then change the Decimal places setting to 30 or less.

Right-click the trendline equation or the R-squared text, and then click Format Trendline Label.

Open the worksheet that contains the chart.

To display a greater number of digits, use one of the following methods: Method 1: Microsoft Office Excel 2007 The trendline equation and R-squared value are initially displayed as rounded to five digits. This article explains how to display more digits in the coefficients.

For some purposes, this may not be a sufficient number of significant figures. This way you only change the coefficients, not the formulas based on them.When you add a trendline to a chart, and then display the equation and R-squared value for the trendline, the equation shows only the first five digits of each coefficient. For example, put your coefficients into cells D1:D4, put your X values into A3:A6, enter this formula into B3Īnd fill this down to B6. If you're just finding it tedious to retype the formula =A+B*x+C*x^2+D*x^3 in each cell, well, you should be entering the coefficients into separate cells, and point the formulas at these cells. If you don't want to enter the trendline coefficients inaccurately time after time, use LINEST.

I'm also not sure what you're asking for.

You say it's not linear, but what you showed before was best approximated by a linear fit. So be careful what formula you will use for extrapolating. I see that both of those points were already covered by John Peltier. That's the maximum precision that Excel chooses to format and it works equally well for all coefficients, regardless of magnitude. I prefer to use the format Scientific with 14 decimal places. If the LINEST coefficients do not seem to work, it might be necessary and sufficient to copy the coefficients from the chart trendline label.īut if you do that, be sure to format the trendline label to display sufficient precision. That is possible and okay, as long as both predict about the same yhat.) (Note: I am not talking about when LINEST and the chart trendline derive very different coefficients. I believe that happens because the input to LINEST is arrays of exponentially-scaled values, resulting in differences beyond the limits of 64-bit binary floating-point. However, there are data sets for which LINEST does not behave as well as the chart trendline algorithm. Shg demonstrates how to use LINEST for that purpose in posting #4.