excel trendline equation increase decimel

> coefficients from the 'Display equation' option, the data diverge > 6th order polynomial, however, If I re-plot the data using the > Excel's built-in trendline function shows a good fit (R2=0.9999) for a > I am trying to fit a polynomial regression (trendline) to a X, Y > How can I increase the precision in Excel's 'Display Equation' option It will often be an extremely difficult numerical problem, well beyond Even if the polynomial degree is theoretically justified, fitting Often fitting a polynomial with this high a degree is overfitting theĭata. Right click on the displayed trendline equation and format as scientific > simple? Do I need to change a preference setting I don't know about? > I can't figure out why it won't work correctly. > the equation as y = 2x^3 + 3x^2 - 6x + 8 > Excel's automatic trendline seems to work fine, correctly identifying > Here is the equation I used (using the 'array enter' crtl-shft-rtrn) See my enhancements of Dave Braden's code atĮxcel, PowerPoint, and VBA add-ins, tutorials To get the results of a chart's trendline result into a Excel worksheet Possible you are doing something wrong though I cannot of think of Maybe, XL2004 hasn't caught up with XL2003? Of course, it is Select a block 7 columns wide, 5 rows deepĮnter =LINEST(y-range, x-range^). I am using Excel 2004 for Mac (OSX) Ver11.2 PS Here is the equation that Excel displays on my chart I can make it calculate, but the values don't match data.Īny help with this problem would be appreciated.

Liengme's website ( ), however, I can't seem to make this work properly.

I also tried using the 'linest' function as described in Mr. I am trying to fit a polynomial regression (trendline) to a X, Y scatterplot I have created.Įxcel's built-in trendline function shows a good fit (R2=0.9999) for a 6th order polynomial, however, If I re-plot the data using the coefficients from the 'Display equation' option, the data diverge significantly.Īpparently, for high order polynomials, you need to have a high level of precision in your coefficients (many decimal places accurate) in order to actually re-plot the same curve. How can I increase the precision in Excel's 'Display Equation' option for trendlines?

Excel trendline equation increase decimel